Reference | Reference Manual | data | database | Chinese InnoDB chinese reference Manual---Dog dog (heart sail) Translation 7 move InnoDB database to another machine
As long as the machine's floating-point number format is consistent, the InnoDB data and log files are binary compatible on any platform. You can move a InnoDB database by simply copying all the relevant files, as described in the previous section. If the floating point format of the two machines is different, but you do not use FLOAT or DOUBLE data types in your table, you can also use this method: just copy the related files. If the machine has a different format and uses floating-point data, you have to move those tables by using mysqldump and Mysqlimport.
When importing data into a database, it is best to turn the autocommit (autocommit) switch off to improve performance, and if the Insert transaction exhausts all available tablespaces, it will cause a large rollback. It is recommended that you commit a transaction after you insert a full table or table fragment.
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.
