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

Do not understand the method of backup and recovery of MySQL database? In fact, it is not difficult to solve this problem. Let the editor take you to learn how to solve it. I hope you will gain a lot after reading this article.

Backup of database

# syntax: # mysqldump-h server-u user name-p password database name > backup file .sql # example: # single library backup mysqldump-uroot-p123 db1 > db1.sqlmysqldump-uroot-p123 db1 table1 table2 > db1-table1-table2.sql# multi-library backup mysqldump-uroot-p123-databases db1 db2 mysql db3 > db1_db2_mysql_db3.sql# backup all libraries mysqldump-uroot-p123-all-databases > all.sql

Data recovery

# method 1: [root@egon backup] # mysql-uroot-p123

Use db1;mysql > SET SQL_LOG_BIN=0; # disable the binary log, which is only valid for the current session mysql > source / root/db1.sql

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the methods of backup and recovery of MySQL database. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.