Back up and restore a MySQL database

Command for backing up MySQL database
Mysqldump-hhostname-uusername-ppassword databasename> backupfile. SQL

Back up the MySQL database in the format of a table with deletion
Backing up a MySQL database is in the format of deleting a table. This allows the backup to overwrite the existing database without the need to manually delete the original database.
Mysqldump -- add-drop-table-uusername-ppassword databasename> backupfile. SQL

Directly compress and back up the MySQL database
Mysqldump-hhostname-uusername-ppassword databasename | gzip> backupfile. SQL .gz

Back up a MySQL database 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

Back up database structures only
Mysqldump-no-data-databases databasename1 databasename2 databasename3> structurebackupfile. SQL

Back up all databases on the server
Mysqldump-all-databases> allbackupfile. SQL

Command for restoring MySQL database
Mysql-hhostname-uusername-ppassword databasename <backupfile. SQL

Restore a compressed MySQL database
Gunzip <backupfile. SQL .gz | mysql-uusername-ppassword databasename

Transfer database to new server
Mysqldump-uusername-ppassword databasename | mysql-host = *. *-C databasename