Re: How to transfer MySQL db from one host to another
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
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.