Shulou(Shulou.com)06/01 Report--

This article mainly introduces some commonly used backup commands of MySQL database, the contents of the article are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand some common backup commands of MySQL database.

Commands for backing up MySQL databases

The code is as follows:

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

Back up the MySQL database in a format with deleted tables

The backup MySQL database is in the format with deleted tables, which allows the backup to overwrite the existing database without manually deleting the existing database.

The code is as follows:

Mysqldump-- add-drop-table-uusername-ppassword databasename > backupfile.sql

Compress backup of MySQL database directly

The code is as follows:

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

Back up some table (s) in the MySQL database

The code is as follows:

Mysqldump-hhostname-uusername-ppassword databasename specific_table1specific_table2 > backupfile.sql

Backup multiple MySQL databases at the same time

The code is as follows:

Mysqldump-hhostname-uusername-ppassword-databases databasename1databasename2 databasename3 > multibackupfile.sql

Just back up the database structure

The code is as follows:

Mysqldump-no-data-databases databasename1 databasename2 databasename3 > structurebackupfile.sql

Back up all databases on the CVM

The code is as follows:

Mysqldump-- all-databases > allbackupfile.sql

Commands for restoring MySQL databases

The code is as follows:

Mysqlc:/beifen.sql

After reading some of the common backup commands about MySQL database, many readers must have some understanding. If you need more industry knowledge and information, you can continue to follow our industry information column.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.