MYSQL Import from SQL file

1. Run cmd into command mode and go to the bin directory in the MySQL installation directory (i.e. the directory where mysql.exe resides);

CD \ c \ "program Files" \mysql\ "MySQL Server 5.7" \ Bin

2. Log in to the database:

Mysql-u uid_test-p database_name;

Prompt to enter user password

3. Create a schema (that is, a database)

mysql> Create schema Uid_dev;

After successful creation, switch to the new data schema under mysql> use Uid_dev;

4. Importing SQL files

Mysql> source D:/uid_backup.sql; (note/direction)

Enter to start the import until completed:

Complete, the process is simple, record it so that the memo.

MYSQL Import from SQL file