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? Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.