MySQL Forums
Forum List  »  Newbie

Re: How to transfer MySQL db from one host to another
Posted by: Umesh Shastry
Date: May 16, 2005 12:50AM

Hi!



mysqldump is also very useful for populating databases for copying data from one MySQL server to another:

shell> mysqldump --host=oldhostip -uoldhostusername -poldhostYoursecret --opt db_name | mysql --host=newhostip -unewhostusername -pnewhostYoursecret -C db_name

This would dump entire databse to the new host..

For more details you can check the mysql manual..

Also you can follow earlier post...export data+structure using phpmyadmin & use the same for importing...

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

Options: ReplyQuote


Subject
Written By
Posted
Re: How to transfer MySQL db from one host to another
May 16, 2005 12:50AM


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.