The fastest way to migrate MySQL databases across operating systems
Source: Internet
Author: User
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.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.