Re: Migrate to new server
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/
Subject
Written By
Posted
Re: Migrate to new server
October 11, 2016 02:03PM
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.