Several methods of MySQL database backup (1/3)

Back up the MySQL Tutorial database tutorial commands

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

Backing up the MySQL database for a deleted table format
Backing up the MySQL database is a format with a deleted table that allows the backup to overwrite the existing database without having to manually delete the original database.

mysqldump-–add-drop-table-uusername-ppassword databasename > Backupfile.sql

Directly compress MySQL database to backup

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

Backing up a MySQL database (some) tables

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

Backup multiple MySQL databases at the same time

mysqldump-hhostname-uusername-ppassword–databases databasename1 databasename2 databasename3 > Multibackupfil E.sql

Just back up the database structure

mysqldump–no-data–databases databasename1 databasename2 databasename3 > Structurebackupfile.sql

Back up all databases on the server

mysqldump–all-databases > Allbackupfile.sql

command to restore MySQL database

Mysql-hhostname-uusername-ppassword DatabaseName < Backupfile.sql

Restoring a compressed MySQL database

Gunzip < backupfile.sql.gz | Mysql-uusername-ppassword databasename

Transferring a database to a new server

Mysqldump-uusername-ppassword DatabaseName | mysql–host=*.*.*.*-c databasename

Several common use cases:

1. Export the entire database

mysqldump-u user name-p database name > exported file name
Mysqldump-u root-p Dataname >dataname.sql

This time will prompt you to enter the root username password, enter the password after the Dataname database is successfully backed up in the mysql/bin/directory.

2. Export a table

mysqldump-u user name-P database name Table name > exported file name
Mysqldump-u root-p dataname users> dataname_users.sql

3. Export a database structure

mysqldump-u wcnc-p-d–add-drop-table Smgp_apps Tutorials _WCNC
-D No data –add-drop-table add a drop table before each create statement

Home 1 2 3 last