Import a local SQL file into MySQL

CMD command operation: first create a database with the same name and then import the SQL file via source

1. Start MySQL

2.mysql-uroot-p Enter password to run MySQL

3. Create a database with the same name

Create DATABASE < databases name >;

Such as: Create Database Estoresystem;

4. Enter use < database name >;

such as: Use Estoresystem;

5. Importing SQL files via source

CMD under Input: Source < database file path >

such as: source D:\ Self-study file \javaweb actual combat \ Data + source + notes \bookestore\estoresystem.sql

Verify that the import was successful: You can show databases by entering the command;  See if the tables in the database have been imported, ①use < database names >; ②show tables;

Import a local SQL file into MySQL