Re: How to move my data to a new installation of MySQL?
Assuming the old & new versions are adjacent in the sequence 5.1->5.5->5.6->57->8.0, the simplest and most reliable method: run mysqldump on the old system eg ...
mysqldump –uUSR –pPWD –K –E –A –R –f >some_backup_dir/mysqlbackup.sql
... substituting your mysql username & password for USR & PWD, and import that file into the new installation with the source command in the mysql client program.
Depending on the versions, some touchups of the dump file may be needed. See the release notes for the version you are installing.
Edited 1 time(s). Last edit at 06/19/2018 09:12AM by Peter Brawley.
Subject
Written By
Posted
Re: How to move my data to a new installation of MySQL?
May 31, 2018 08:35PM
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.