MySQL Forums
Forum List  »  Newbie

Re: move mysql from one server to another
Posted by: Umesh Shastry
Date: June 01, 2005 04:46AM

Hi!!

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


shell> mysqldump --opt -hOldHostName -uusername -ppassword db_name | mysql -NewHostName -uusername -ppassword -C db_name

Take a look here for more..(for compatibility & other available options)

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

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

Options: ReplyQuote


Subject
Written By
Posted
Re: move mysql from one server to another
June 01, 2005 04:46AM


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.