Shulou(Shulou.com)06/03 Report--

The following content mainly brings you how to make a remote backup of mysql. The knowledge mentioned here, which is slightly different from books, is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing. I hope to bring help to the majority of readers.

Error using CVM for remote database backup:

[root@zfer13] # mysqldump-u root-p111111-h 192.168.1.163-- databases test > / tmp/test.sql

Mysqldump: [Warning] Using a password on the command line interface can be insecure.

Error message can not be entered in the interface password, for the sake of security

Remote machine backups can be done using the following methods:

1. Enter the password manually

Mysqldump-u root-p-h 192.168.1.163-- databases test > / tmp/test.sql

two。 Parameters are used. If a warning is issued during access, it can be thrown into the system null.

Mysqldump-- defaults-extra-file=/etc/my.cnf-h 192.168.1.163-uroot-p111111 test > test11.sql 2 > / dev/null

For the above about how to make remote backup of mysql, if you need to know more, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sale and after-sales on the official website. I hope this article can bring you some knowledge updates.

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.