Retrieving mysql database v4.1 to mysql 4.0

If you encounter error from dumping the database from mysql 4.1 into old version mysql 4.0 (see below):

 

[root@cadisetrama]# mysql database

ERROR 1064 at line 21: 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 ‘DEFAULT CHARSET=latin1’ at line 21

 

you may fix it with redumping the database using below code from server A with mysql version 4.1

mysqldump -uroot -pkunGfu123 –compatible=mysql40 database > database.sql

 

details

-u[user] -p[password] compatibility for version 4.0 your database filename database.sql extension

mysqldump -uroot -pkunGfu123 –compatible=mysql40 database > database.sql

 

Hope this may help ^__^

 

Cheers

Advertisements

Mag-iwan ng Tugon

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Baguhin )

Twitter picture

You are commenting using your Twitter account. Log Out / Baguhin )

Facebook photo

You are commenting using your Facebook account. Log Out / Baguhin )

Google+ photo

You are commenting using your Google+ account. Log Out / Baguhin )

Connecting to %s