Mysql database backup and restoration command memo

Command mysqldump-hhostname-uusername-ppassword databasename> backupfile to back up MySQL database. the SQL backup MySQL database is in the format of a table with deletion. the MySQL database is in the format of a table with deletion. 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 compresses and backs up the MySQL database mysqldump-hhostname-uusername-ppassword databasename | gzip> batch back up a MySQL database table mysqldump-hhostname-uusername-ppassword databasename specific_table1 batch> backupfile. SQL simultaneously backs up multiple MySQL databases mysqldump-hhostname-uusername-ppassword-databases databasename1 databasename2 databasename3> multibackupfile. SQL only backs up the database structure mysqldump-no-data-databases databasename1 databasename2 databasename3> structurebackupfile. all databases on the SQL Backup Server mysqldump-all-databases> allbackupfile. SQL command for restoring MySQL database mysql-hhostname-uusername-ppassword databasename <backupfile. SQL restore compressed MySQL database gunzip <backupfile. SQL .gz | mysql-uusername-ppassword databasename transfers the database to the new server mysqldump-uusername-ppassword databasename | mysql-host = *. *. *. *-C databasename: Save the data mysql-h $ HOST-u $ USER-p $ PASSWD-e "select * from $ DB. $ table into outfile' "$ BAK_DIR/Tables table.txt'