MySQL Forums
Forum List  »  Newbie

Re: How do I downgrade my MySQL data file from ver 4.1 to ver 4.0?
Posted by: Umesh Shastry
Date: May 23, 2005 01:01AM

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


Hope this helps!

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

Options: ReplyQuote


Subject
Written By
Posted
Re: How do I downgrade my MySQL data file from ver 4.1 to ver 4.0?
May 23, 2005 01:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.