Page 1 of 1

Exporting and Importing Databases to new MySQL client versio

Posted: Sun Dec 04, 2011 6:22 pm
by zero477
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?

Re: Exporting and Importing Databases to new MySQL client ve

Posted: Sun Dec 04, 2011 9:27 pm
by Celauran
zero477 wrote:What is the best way to export and import big databases in MySQL?
export:

Code: Select all

mysqldump database_name > some_file.sql
import:

Code: Select all

mysql database_name < some_file.sql

Re: Exporting and Importing Databases to new MySQL client ve

Posted: Mon Dec 05, 2011 11:28 am
by zero477
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.