MySQL Forums
Forum List  »  Newbie

Re: Migrating mysql databases into new server
Posted by: Phillip Ward
Date: October 05, 2016 07:38AM

Quote

LUNS would be copied from one storage to another ... a new linux installation and new mysql installation ... what are the steps I need to follow in order to bring the databases up and running in target?

There are none.
As has been said before ...

You cannot reliably move a MySQL database by duplicating file systems.

The only reliable way, that is guaranteed to work, is to use mysqldump to unload the source databases and mysql to load them into the new installation.

Anything else has the potential to fail in "weird and wonderful" ways that are simply not work getting into.

Regards, Phill W.

Options: ReplyQuote




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.