MySQL command back up the database

　　

One, MySQL database backup command

MySQL database using command Line Backup

For example:

Database address: 127.0.0.1

Database user name: root

Database Password: Pass

Database name: MyWeb

Back up database to D disk and directory

Mysqldump-h127.0.0.1-uroot-ppass myweb > D:/backupfile.sql

Back up to current directory The MySQL database is formatted with the Delete table, allowing the backup to overwrite the existing database without having to manually delete the existing database

Mysqldump--add-drop-table-h127.0.0.1-uroot-ppass myweb > Backupfile.sql

Backup the MySQL database compression backup to the D drive and directory directly

Mysqldump-h127.0.0.1-uroot-ppass MyWeb | gzip > d:/backupfile.sql.gz

Back up some (some) tables from the MySQL database. This example backs up the Table1 table and the Table2 table. Back up to the Linux host under/home

Mysqldump-h127.0.0.1-uroot-ppass myweb table1 table2 >/home/backupfile.sql

Back up multiple MySQL databases at the same time

Mysqldump-h127.0.0.1-uroot-ppass--databases myweb myweb2 > Multibackupfile.sql

Simply back up the database structure. Back up both the MyWeb database and the named MYWEB2 database

Mysqldump--no-data-h127.0.0.1-uroot-ppass--databases myweb myweb2 > Structurebackupfile.sql

Back up all databases on the server

Mysqldump--all-databases-h127.0.0.1-uroot-ppass > Allbackupfile.sql

The command to restore the MySQL database. Restore a database that is currently backed up with the name Backupfile.sql

Mysql-h127.0.0.1-uroot-ppass MyWeb < Backupfile.sql

Restore a compacted MySQL database

Gunzip < backupfile.sql.gz | Mysql-h127.0.0.1-uroot-ppass MyWeb

Transfer the database to the new server. This example copies the local database myweb to the remote database named Serweb, where the remote database must be known as a serweb database

Mysqldump-h127.0.0.1-uroot-ppass MyWeb | MySQL--host=***.***.***.***-u database user name-p database password-c serweb

Second, the use of multi-backup backup software

(1), open the MySQL database backup, fill in the database related parameters.

IP: Default 127.0.0.1; Domain name: localhost

User name: Account name of the login database

Password: password to log in to the database

Port number: Default 3306, or find mysql.ext and open, enter the password and press ENTER, after mysql> enter "show global variables like ' Port ';" Enter

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/F4/wKiom1U7PG-BMJi6AADurTZWrdo075.jpg "title=" Picture 11.png "alt=" Wkiom1u7pg-bmji6aadurtzwrdo075.jpg "/>

(2), fill out the parameters, click "Next", tick the database that needs to be backed up, click "Done", the task is created (the file began to be automatically backed up)

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/F0/wKioL1U7Pd2wbX1NAAD0az0lQG4401.jpg "title=" Picture 12.png "alt=" Wkiol1u7pd2wbx1naad0az0lqg4401.jpg "/>

(3), click "Set Frequency" under "Operation", set the frequency of task backup; " Edit Parameters "Set the user name, password, port number of the connection number library; Backup content re-selects the database that needs to be backed up.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/F4/wKiom1U7PJDzpCldAADcegOf5Kk907.jpg "title=" Picture 13.png "alt=" Wkiom1u7pjdzpcldaadcegof5kk907.jpg "/>

Tip: If you need to create a database backup task again, click "Backup Content" under "Actions", click "Add Database", and then follow the same steps as when creating the first database task.

(If the number of tasks is not enough, please redeem the number of tasks on the official website; only one can be created for the same database)

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/F0/wKioL1U7PgbgaIocAAEGGv8C8D8310.jpg "title=" Picture 14.png "alt=" Wkiol1u7pgbgaiocaaeggv8c8d8310.jpg "/>

3.3. SQL Server Database backup

(1), open the MSSQL database, fill in the relevant parameters;

Instance name: In general, all instance names will be displayed for you to choose, and click "Edit" to fill them in manually.

User name: Account name of the login database

Password: password to log in to the database

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/F0/wKioL1U7PhjxU1_oAAEMINtLVOQ956.jpg "title=" Picture 15.png "alt=" Wkiol1u7phjxu1_oaaemintlvoq956.jpg "/>

(2), the other steps as the backup MySQL database, as above.

Summary: Compared with the above two methods, it is obvious that the use of multi-backup software is more convenient. Save a lot of time and effort without a manual backup, and use multiple backups to monitor backup status in real time and solve problems immediately. The final result of the backup will also notify the user in the form of mail, so we do not have to worry about the success of the backup when recovering, if the heart of the hurriedly use up!

MySQL command back up the database