MySQL Automatic backup policy

A MySQL backup related command:

MYSQLDUMP-H host name-P Port-u user name-p password (–database) database name > file name. sql

Commands to back up the MySQL database

Mysqldump-hhostname-uusername-ppassword databasename > Backupfile.sql

backing up the MySQL database is a format with a delete table that allows the backup to overwrite the existing database without having to manually delete the existing database.
Mysqldump-–add-drop-table-uusername-ppassword databasename > Backupfile.sql

compress the MySQL database directly backup
Mysqldump-hhostname-uusername-ppassword DatabaseName | gzip > backupfile.sql.gz

back up a MySQL database (some) table
Mysqldump-hhostname-uusername-ppassword databasename specific_table1 specific_table2 > Backupfile.sql

back up multiple MySQL databases at the same time
Mysqldump-hhostname-uusername-ppassword–databases databasename1 databasename2 databasename3 > Multibackupfile.sql

backing up the database structure only
Mysqldump–no-data–databases databasename1 databasename2 databasename3 > Structurebackupfile.sql

back up all databases on the server
Mysqldump–all-databases > Allbackupfile.sql

commands to restore MySQL database
Mysql-hhostname-uusername-ppassword DatabaseName < Backupfile.sql

restore a compacted MySQL database
Gunzip < backupfile.sql.gz | Mysql-uusername-ppassword DatabaseName

to transfer a database to a new server

Mysqldump-uusername-ppassword DatabaseName | Mysql–host=*.*.*.*-C DatabaseName

===============================================================

Two. Copy the backup file to a different server

Set ' Date '

Mysqldump-s/export/servers/mysql/tmp/mysql.sock-hlocalhost-uroot [email protected] jd_ptesting | gzip >/export/data/mysql_backup/$1$2$3_backupfile.sql.gz
\cp/export/data/mysql_backup/$1$2$3_backupfile.sql.gz/mnt/nfs

MySQL Automatic backup policy