MySQL Forums
Forum List  »  Newbie

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

Quote

1) What about physical files? How would they be copied?

They would not be copied.

They would be created and loaded by the new MySQL instance running on the new machine. This is especially relevant if you're moving to a different version of MySQL.

Quote

2) Would mysqldump take all procedures,functions,triggers,grants etc backup as well?

Yes.

Quote

3) What about system databases? Do i Need to backup them as well?

Not for this exercise, because the new instance will have its own system databases.

However you should, of course, be backing up all your databases, system or otherwise, in case you ever need to recover them. :-)

Quote

4) Any specific considerations w.r.t. innodb or myISAM tables?

None at all.

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.