MySQL backup remote database to local (reprint)

1. First create a local database (for backup).

Log in to MySQL

sudo mysql-u root-p root

Create DATABASE test; The test here is the same name as the remote database.

2. Back up the remote database to a local testbackup.sql

Mysqldump-h 172.26.100.145-uroot-proot Test--DEFAULT-CHARACTER-SET=GBK--opt-q-R--skip-lock-tables>/home/ Testbackup.sql

3. Then import the Testbackup.sql into the local test

Log in to MySQL

sudo mysql-u root-p root

Use test;

Source/home/testbackup.sql;

To recover a database:

Mysql-hlocalhost-uroot-proot Test < Testbackup.sql

Original link: http://blog.csdn.net/tingyuanss/article/details/46784779

MySQL backup remote database to local (reprint)