MySQL Forums
Forum List  »  General

Re: moving mysql database
Posted by: Rick James
Date: May 10, 2013 06:02AM

With suitable parameters, mysqldump will dump everything, including triggers, stored routines, etc.

Alternatively (instead of mysqldump), you could:
1. stop mysqld on old machine
2. copy entire directory tree (via scp or whatever) to new machine
3. start new mysqld

The my.cnf (my.ini) should probably be made freshly on the new machine. Consider tuning according to
http://mysql.rjweb.org/doc.php/memory

If the new machine has a newer version of mysql, you may need to run mysql_upgrade.

Options: ReplyQuote


Subject
Written By
Posted
Re: moving mysql database
May 10, 2013 06:02AM
June 08, 2013 05: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.