MySQL database backup and Restoration

Directly compress and back up the MySQL database, and the previous data will be cleared.  - - Add  -  Drop  -  Table   - Hhostname - Uusername - Ppassword databasename | Gzip >  Backupfile. SQL .gz mysqldump  -- Add-drop-table -- Single-transaction-hlocalhost-udiscuz-pdiscuzexp discuz | gzip> backupfile. SQL .gz  Restore the compressed MySQL database gunzip  < Backupfile. SQL .gz | MySQL - Uusername -  Ppassword databasenamegunzip  < Backupfile. SQL .gz | MySQL - Udiscuz - The pdiscuzexp discuz backup MySQL database is in the format of deleting tables. This allows the backup to overwrite existing databases without manually deleting the original database. Mysqldump  - - Add  -  Drop  -  Table   - Uusername - Ppassword databasename >  Backupfile. sqlmysqldump  --  Add-drop-table -- Single-transaction-hlocalhost-udiscuz-pdiscuzexp discuz> backupfile. SQL Command for restoring MySQL database MySQL  - Hhostname - Uusername - Ppassword databasename <  Backupfile. sqlmysql  - Hlocalhost - Udiscuz - Pdiscuzexp discuz < Backupfile. SQL