SQL---->MYSQL Database 1------Additions and deletions change backup recovery

1. In terminal input: Mysql-uroot-p then enter the password to enter the client

2. Input: \s

3. Create a Database

3.1 Creating a character set is a utf-8 database

3.2 Create a database with a validation rule, the validation rules can be found in the API itself, here is used utf-8 Common check rules

4. View the database

4.1 Viewing database details

5. Deleting a database

6. Modify the database----- Modify the database, only modify the properties, cannot modify the library name

7. Back up the database-----save something first, and then back up

Back up in the terminal, not mysql>!!!

To the directory to view:

Success!

8. Restore the database (recover only the data of the library, unable to fully recover, so create a new database, import data)

The following executes the recovery database, in order to see the effect, first delete the database mydb2

8.1 Another way to recover-----under terminal

SQL---->MYSQL Database 1------Additions and deletions change backup recovery