zero477 Posted December 5, 2011 Share Posted December 5, 2011 Hello everyone, My old server version is:5.0.91-log My new MySQL client version: 5.0.77 I am trying to export my database from the old version to the new one. But when I import it I receive this error message: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Successfully backed up database: mresenas1' at line 1 or What is the best way to export and import big databases in MySQL? Link to comment https://forums.phpfreaks.com/topic/252480-exporting-and-importing-databases-to-new-mysql-client-version/ Share on other sites More sharing options...
fenway Posted December 5, 2011 Share Posted December 5, 2011 That's not an SQL command -- should have been commented out. Link to comment https://forums.phpfreaks.com/topic/252480-exporting-and-importing-databases-to-new-mysql-client-version/#findComment-1294487 Share on other sites More sharing options...
zero477 Posted December 5, 2011 Author Share Posted December 5, 2011 Hello, I know that is not an SQL command. I was trying to export it using phpMyAdmin.... I do not understand your signature... you mean doing this? // Here I put stuff of PHP I have solved the problem already. When I exported the DB from phpmyadmin, it exported it with some informational commands at the beginning that had to be erased. Link to comment https://forums.phpfreaks.com/topic/252480-exporting-and-importing-databases-to-new-mysql-client-version/#findComment-1294662 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.