Mysql import/export Password Change command Summary (note 3)

1. Export data from the database

Note that these statements are executed before the mysql command line is started.

C: \ Windows \ system32> Export command

Instead

Mysql> Export command

1. Export the entire database

Or enter the password directly.

 

2. Export the structure of all tables in the database

3. export data from one or more database tables

4. Export the structure of a database table

Import External SQL files to the database

Clear all data in the database table at one time

Pilot output

In fact, it is the same as exporting only the table structure

Then, create a database

Create database

Before entering

Mysql> source xx. SQL

Modify mysql password

C: \ Windows \ system32> mysqladmin-uroot-p Original password New password