MySQL Forums
Forum List  »  Newbie

Re: Migrate to new server
Posted by: Peter Brawley
Date: October 11, 2016 02:03PM

1. Run mysqldump to make a complete dump of all databases, eg ...

mysqldump –uUSR –pPWD –K –E –A –R –f >some_backup_dir/backup51.sql

2. Install 5.1.30 on the new machine. Verify that it works.

3. Import backup51.sql eg in the mysql client eg ...

source c:/some_backup_dir/backup51.sql

4. Verify that it works, then repeat step 1 for the new installation

5. Upgrade the installation at least to the latest 5.1 (5.1.72) from https://downloads.mysql.com/archives/community/

Options: ReplyQuote


Subject
Written By
Posted
October 10, 2016 09:53PM
October 10, 2016 10:54PM
October 11, 2016 09:45AM
Re: Migrate to new server
October 11, 2016 02:03PM
October 12, 2016 12:51PM
October 12, 2016 12:58PM
October 14, 2016 03:26AM


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.