mysql database backup command Share of mysql compressed database backup

Command to back up MySQL database

mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql

The MySQL database is backed up in a format with deleted tables

The backup MySQL database is in a format with deleted tables, enabling the backup to overwrite an existing database without having to manually delete the original database.

mysqldump - � add-drop-table -uusername -ppassword databasename > backupfile.sql

Compress the MySQL database backup directly

mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz

Back up some tables in the MySQL database

mysqldump -hhostname -uusername -ppassword databasename specific_table1 specific_table2 > backupfile.sql

Multiple MySQL databases are backed up simultaneously

mysqldump -hhostname -uusername -ppassword  � databases databasename1 databasename2 databasename3 > multibackupfile.sql

Only backup the database structure

mysqldump  � no-data  � databases databasename1 databasename2 databasename3 > structurebackupfile.sql

Back up all databases on the server

mysqldump  � all-databases > allbackupfile.sql

Restore the MySQL database command

mysql -hhostname -uusername -ppassword databasename < backupfile.sql

Restore the compressed MySQL database

gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename

Move the database to the new server

mysqldump -uusername -ppassword databasename | mysql  � host=*.*.*.* -C databasename 

Back up database data and stored procedure 1

mysqldump - � add-drop-table -uusername -ppassword databasename > backupfile.sql

0