MySQL Data backup

Backup structure

1. Backing Up the table structure

- - - > a.sql

2. Back up all the table structures of the database

- - - > b.sql

3. Back up all table structures for multiple databases

- - - -- databases db1 DB2 ... > C.sql

4. Backing up the table structure for all databases

- - - -- all-databases > D.sql

Backing up the structure and data (rather than removing the-d option from the syntax of the backup structure)

1. Back up the table structure and data

- - > a.sql

2. Back up all table structures and data for the database

- -P dbname  > b.sql

3. Backing up the table structure and data for multiple databases

- - -- databases db1 DB2  > C.sql

4. Back up the table structure and data for all databases

- - -- all-databases > D.sql

MySQL Data backup