Migrate a 32-bit MySQL database to a 64-bit MySQL database _ MySQL

The 32-bit MySQL database is migrated to the 64-bit MySQL database, which is a 32-bit MySQL database in Windows 2003. The new server is Sun's 64-bit minicomputer, A 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.