SEO Class in Chicago, IL
Are you a Google Analytics enthusiast?
More SEO Content
Double Escaping When Backing Up :-s
Posted 18 September 2009 - 11:04 AM
I'm now trying to back up the data to sql statements so I can just paste them into phpmyadmin on the server, but the backups I'm getting (from SQLyog) are escaping the escape characters :-s
So, when I look at the data through sqlyog's interface I see "Fred\'s lederhosen were red" but in my backup I get "Fred\\\'s lederhosen were red".
It may be because it's Friday afternoon, but I've never noticed this problem before and I can't figure out why it's happening now - any suggestions?
Posted 18 September 2009 - 01:51 PM
It didn't recognize that the character was already escaped, so every time it saved it escaped it again...
Posted 19 September 2009 - 06:45 AM
I think I may just install phpmyadmin to solve the problem. I like SQLyog, it's the first decent mysql management tool I used and I learned a lot by using it so I'm very comfortable with it, but every online server I've used has had phpmyadmin installed so it kinda makes sense to switch anyway.
Posted 19 September 2009 - 08:57 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users