php - How to export and import large amounts of data in mysql

Question

Now we have a database here that reaches 10G. We want to export it and import it to other servers. Basic exports can no longer be used, such as mysqldump and navicat exports. Are there any other methods or tools that can export the database and then migrate it to other places?

Answer 1

Using the open source ETL tool, kettle, is very good, and various databases can be transferred to each other.

Answer 2

Importing is impossible, just write a script and run it

Answer 3

1.可以使用使用MySQL master/slave机制，将数据同步过去．
2.使用rsync(http://mah.everybody.org/docs/mysql-rsync)将MySQL的数据目录同步到另一台机器上．

Answer 4

The simpler way is to first convert the database table to MyIsam, and then directly copy the database file to other servers. Then modify it to the original database table engine.

Answer 5

Should we consider distributed storage?

Answer 6

Use xtrabackup to back up, then use rsync to transfer the backup to another server, and then use xtrabackup to restore. If it is transmitted through the intranet, the entire backup and restore time for 10G of data can be controlled within 1 hour (I am here 16 Core 32G server).

Answer 7

Offline the database and copy the physical files of the database

Answer 8

Can’t use mysqldump with only 10G? What the hell? I am running dump as usual with 100G here, and xtrabackup is also available

What level? Don't understand the answer? Report me? Weird! ! If you don’t understand, look it up! Please ask any questions, thank you!

Answer 9

Package data files directly?