How to remotely back up the mysql database to the local through mysqldump

This article mainly introduces "how to remotely backup the mysql database through mysqldump to the local". In the daily operation, I believe many people have doubts about how to remotely backup the mysql database through mysqldump to the local problem. The editor consulted all kinds of materials and sorted out a simple and easy-to-use method of operation. I hope it will be helpful to answer the question of "how to remotely backup the mysql database to the local through mysqldump". Next, please follow the editor to study!

[root@test] # mysqldump-h 139.100.210.22-u root-pendant 123'-- default-character-set=utf8 test_db > / tmp/test_db.sql

[root@test ~] # mysqldump-h remote server IP or domain name-u remote database account-p 'remote database password'-default-character-set=utf8 database name > / tmp/test_db.sql

You can generate test_db.sql files locally

If you want to execute in the background, you can write a crontab

[root@t03 ~] # vi / tmp/backup

#! / bin/sh

Cd / usr/local/mysql/bin

. / mysqldump-h 139.100.210.22-u root-paired test 123'-- default-character-set=utf8 test_db > / tmp/test_db.sql

Then write crontab-l

[root@t03 ~] # crontab-l

26 01 * / tmp/backup

30 22 * / usr/local/mysql/bin/mysqldump-h 139.100.210.22-u root-pendant 123'-- default-character-set=utf8 test_db > / tmp/test_db.sql

Execute on a regular basis.

OK

At this point, the study on "how to remotely backup the mysql database to the local through mysqldump" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!