Error when restoring backup

General Forums General Questions
#1

Hello!



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?



Thanks,

Regards

Francesco

#2

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.



Jesse

#3

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:



Regards

Francesco