I'm moving some sites to a new server, and using phpmyadmin to export the mysql db's. I've tried a bunch of different settings and searched all over for answers... I keep getting unclosed quote errors when I try to import the databases into phpmyadmin on the new server. Ex. ERROR: Unclosed quote @ 272 STR: ' It's probably obvious already, but I don't know much about mysql... Thanks in advance.
in .sql format. I tried many different settings, and never could get rid of the unclosed quote errors in phpmyadmin. In ended up exporting them with a tool called SQLyog, and they imported fine after that.
I tried a lot of different options exporting and importing. The only thing that worked was downloading an external db client like SQLyog. Then I still kept having problems with the db's on the new host, so I gave up altogether moving the sites. I'll try again some other time.