Re: Dumping from 4.1.10a to 4.0.28

[Umesh Shastry]

Hi!!


On MySQL SERVER version 4.1 run the mysqldump command to generate a dump compatible to mysql40..


shell> mysqldump --compatible=mysql40 --opt db_name -uuserName -p > backup-file.sql

Also in a single go..from old host to new host

shell> mysqldump --host=old_host --compatible=mysql40 --opt db_name -uuserName -ppassword | mysql --host=new_host -uuserName -ppasswd -C db_name


For details check out here

http://dev.mysql.com/doc/mysql/en/mysqldump.html

Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221