Export the database to SQL file in MySQL
First, enter CMD in the run, enter the DOS interface: then through the CD Path command into the installation directory under the bin path, enter the command, and it will prompt for a password, you enter the correct login password, will be named MyDB database exported to the root directory e disk, and named Mydb.sql.
Import SQL files in MySQL
Import the *.sql file into the MySQL database, you need to go to the command line,mysql> how to enter: if the local host operation: Mysql-u root-p, the system prompts: Enter Password: you: Enter the password.
Then establish the *.sql file corresponding database (if not, you need to create one), enter the command: Create Database mydb;
Enable database: Use MyDB;
Import *.sql file: source e:/mydb.sql; (Note: You must enable the appropriate database, otherwise you will be prompted No database selected)
Can be through show databases; Query the database tables, or you can view the corresponding tables created by the *.sql file in the database through show tables.
MySQL Import export SQL file