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

This article mainly introduces how to migrate MySQL 5.7database, the article is very detailed, has a certain reference value, interested friends must read it!

Back up the database with mysqldump in the source database:

Mysqldump-uroot-p-- default-character-set=utf8 ora | gzip > ora.sql.gz

Transfer the backup to the target library.

You can use the SSH command to transfer, or you can use the tools XSHELL, XFTP to transfer.

Extract the backup file in the target library:

Gzip-d ora.sql.gz

Establish the target database:

Create database ora

Restore the database:

/ usr/local/mysql/bin/mysql-uroot-p-- default-character-set=utf8 ora < / data/ora.sql

If the restore times out:

Set the mysql parameters:

Set net_write_timeout=7200

Set net_read_timeout=3600

The restore was successful.

These are all the contents of the article "how to migrate MySQL 5.7Database". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.