Shulou(Shulou.com)05/31 Report--

This article mainly explains the "mysql file copy and migration method", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's train of thought slowly in depth, together to study and learn "mysql file copy and migration method"!

A mysql server needs to be more a virtual machine. So it is necessary to carry out data migration. The amount of data is not large, about 100G. The downtime on weekends can be longer. Choose several options for migration

1: build the master and slave and drift directly to the past. Recommend the plan. The Lord has built countless things, yes. But the original test library. It doesn't matter.

2: export the database directly, copy the file to the new server, and import it on the new server.

Use MySQLMigrationTool in [MySQL GUI Tools].

4: the data files and database table structure files are directly copied to the new server and mounted to the MySQL service with the same configuration.

The fourth kind is mainly introduced here:

Direct copy of files

The third scenario d migration steps are described below:

Ensure that the version of Mysql is consistent, and the installation configuration is basically the same (Note: the data files and database table structure files here are specified in the same directory data)

1: stop the Mysql services on both sides. After stopping, you'd better copy part of the binlog.

2: delete all files under the data directory of server B Mysql

3: copy the files except ib_logfile and .err from the data directory of server A Mysql to server B data.

4: start the Mysql service of server B to detect whether an exception has occurred

5: after the migration is completed, the service starts normally and no other abnormal problems are found.

2019-11-05T09:21:30.515082Z 0 [ERROR] Failed to open log (file'/ mysql/binary_log/binlog.000015', errno 2)

2019-11-05T09:21:30.515087Z 0 [ERROR] Could not open log file

2019-11-05T09:21:30.515092Z 0 [ERROR] Can't init tc log

2019-11-05T09:21:30.515095Z 0 [ERROR] Aborting

Thank you for your reading, the above is the "mysql file copy migration method" content, after the study of this article, I believe you have a deeper understanding of the mysql file copy and migration method, the specific use of the need for you to practice and verify. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.