Data Backup and Recovery memo

1. Mysqldump BACKUP Database

First go to the command prompt environment and go to the directory where Mysqldump.exe is located (C:\Program files\mysql\mysql Server 5.7\bin).

Format

>mysqldump-u user-p dbname > Abc.sql (All tables in the backup library)

Eg: >mysqldump-u root-p test_db > C:/DbBackup/test_db.sql (note '/' direction)

2. Restore the database

>mysql-u user-p [dbname] < Filename.sql

Eg: >mysql-u uid_test-p uid_develop < C:/dbbackup/test_db.sql

3,mysqldump back up one or more tables:

> Mysqldump-u user-p [dbname] [table1 table2 table3] > Test.sql

If you back up multiple tables, the table names are separated by spaces

4. Backing up multiple libraries (--database)

> mysqldump-u user-h host-p--databases [dbname1 dbname2 dbname3 ...] > filename.sql

Use the--all-databases parameter to back up all databases on the system

> mysqldump-u user-h host-p--all-databases > Filename.sql

Data Backup and Recovery memo