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
What is the best way to export and import big databases in MySQL?
Exporting and Importing Databases to new MySQL client versio
Moderator: General Moderators
Re: Exporting and Importing Databases to new MySQL client ve
export:zero477 wrote:What is the best way to export and import big databases in MySQL?
Code: Select all
mysqldump database_name > some_file.sqlCode: Select all
mysql database_name < some_file.sqlRe: Exporting and Importing Databases to new MySQL client ve
Thanks for your answers.
I have solved it now. When I exported from phpmyadmin the DB, it was exported with some informational lines at the beginning of the file.
I just had to remove them before importing the DB.
I have solved it now. When I exported from phpmyadmin the DB, it was exported with some informational lines at the beginning of the file.
I just had to remove them before importing the DB.