Error when restoring backup


I’m developing on localhost with easyphp and now I would like to import database created into my onlline CS-Cart installation.

I tried to export DB from CS-Cart (localhost) and to import this DB on CS-Cart online, using integrated tools.

But I receive an error telling me:

ERROR 1064 at line 13: You have an error in your SQL syntax near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line 1

I also tried using PhPMyAdmin to export all tables with “DROP”…

And I’m also trying by server console to import…always same error…

Any ideas, please?




I’m not SQL freak but it looks as though there is are error within the latin1 (english) character set, or else the server is set to read a different language.

Check to see if phpmyadmin has the same settings as your webhost.


Thanks, solved…

It was an error created by EasyPHP 1.8…I edited sql file and I deleted referrals to swedish languages collate and now works fine :slight_smile: