MySQL Database backup command

MySQL Database Backup Command

Mysqldump-hhostname-uusername-ppassword databasename > Backupfile.sql
Backing up the MySQL database to a format with a delete table
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-ppassworddatabasename | gzip > backupfile.sql.gz
Back up a MySQL database (some) table

Mysqldump-hhostname-uusername-ppassworddatabasename 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 databasename1databasename2 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

MySQL Database backup command