The original is the 32-bit MySQL database under Windows2003, and the new server is Sun's 64-bit minicomputer and 64-bit MySQL database.
The original is the 32-bit MySQL database in Windows 2003, and the new server is Sun's 64-bit minicomputer and 64-bit MySQL database.
The database file is large, about 70 GB,
For normal migration, You need to export data in the original database and then import data in the new database.
After careful consideration, is the format of MySQL database file storage identical in different operating systems?
The test procedure is as follows:
Install MySQL 64-bit on 64-bit SUN
Stop MySQL Service
Copy the 32-bit MySQL Data Files (all, except system and log files) on Windows to a 64-bit machine,
Modify the corresponding file and directory permissions,
The file is chmod 660.
The directory is chmod 700.
Then restart the MySQL service and run normally.
Summary:
Don't think it looks very simple. Many people mistakenly think that the storage of different operating systems is not universal, and this example proves that the storage structure of the same database data is no different, it can be used directly.
Attach a small exception encountered in the middle, that is, the database data directory, must have executable permissions, that is, 7 permissions, 6 can not.
My Testing Process
