MySQL database backup and recovery implementation code

#grammar:
# mysqldump -h server-u username-p password database name> backup file.sql

#Example:
#Single database backup mysqldump -uroot -p123 db1 > db1.sql
mysqldump -uroot -p123 db1 table1 table2 > db1-table1-table2.sql

#Multi-database backup mysqldump -uroot -p123 --databases db1 db2 mysql db3 > db1_db2_mysql_db3.sql

#Backup all librariesmysqldump -uroot -p123 --all-databases > all.sql

#Method 1:
[root@egon backup]# mysql -uroot -p123 < /backup/all.sql

#Method 2:
mysql> use db1;
mysql> SET SQL_LOG_BIN=0; #Turn off binary logging, only effective for the current session mysql> source /root/db1.sql