MYSQL Import Export Database file

To export a database or table file from a database:

Mysqldump-u User name-p password-d database Name table name > script name;

Export the entire database structure and data
Mysqldump-h localhost-uroot-p123456 Database > E:\dump.sql

Export a single data table structure and data
Mysqldump-h localhost-uroot-p123456 database table > E:\dump.sql

Export the entire database structure (no data included)
Mysqldump-h localhost-uroot-p123456-d Database > E:\dump.sql

Export a single data table structure (no data included)
Mysqldump-h localhost-uroot-p123456-d database table > E:\dump.sql

Second, import the database or table to the database (the database should be built first )

Method 1:mysql-h localhost-uroot-p123456-d database table < E:\dump.sql

Method 2:

1. Enter Mysql:mysql-u root-p
2. Input: Use target database name
3. import file: Source E:\dump.sql

MYSQL Import Export Database file