MySQL Forums
Forum List  »  Backup

Re: physical export
Posted by: Rick James
Date: March 22, 2014 11:04PM

It will probably work.
Some potential issues...
There is a .../mysql/ directory and there is a .../mysql/data/mysql directory -- move the upper one and everything under it.
If the new machine has smaller RAM, then some of the my.ini settings will need decreased.
If the version of MySQL is different there could be incompatibilities. See mysql_upgrade.
If the new machine is another Slave, then server_id need to be different.
InnoDB uses ibdata1 and iblog*, but you will be moving them intact, so there is no problem.
If you put the /mysql/ in a different path, you may need to change something in my.ini.
32-bit/64-bit and big-endian/little-indian should not matter.
Windows to/from non-Windows could matter due to case folding of directory and file names (that is, database and table names) in Windows but not in non-windows.

Options: ReplyQuote

Written By
March 21, 2014 05:16AM
Re: physical export
March 22, 2014 11:04PM

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.