How to import External SQL scripts from mysql

There are two import methods: one is to use graphical tools, such as SQLYog and Navicat, and the other is to use the MySql command line interface. The following sections describe:

I. command line interface

1. Start mysql:

2. log on to mysql:

3. Create a database to store the imported SQL:

4. Find the SQL path and use the source command to import it to the created database:

Ii. Use Navicat to import an SQL script:

1. Establish a connection with MySql

2. Find the database to import

3. Run the SQL file and select the path of the SQL file.

4. Start Import

Import succeeded. You can view the imported SQL file in the database.