MySQL Import SQL file

Importing a SQL file into MySQL saves you time creating your own database.

Suppose the SQL file name you want to import is Xxx.sql

1. Log in to MySQL
2. Create database mysql>create databases XXX;
3. Toggle Mysql>use XXX;
4. Import Mysql>source D:\XXX.sql; Write the path to the SQL file here, and if you are afraid of trouble, copy the SQL file to the D drive.

• You can also use the mouse to drag the SQL file directly to the command-line console after the 4th Mysql>source, this time, sometimes not, you can try.

The result is successful.

MySQL Import SQL file