How to import SQL files in Centos, centos import SQL files

How to import SQL files in Centos, centos import SQL files

For File Import,

In Centos, you must first create a database with the same name as the file.

For example:

mysql> create database Student;

Then enter the command:

mysql> use Student;

If there is no error, it indicates that the database you created is in progress.

Then set the encoding first:

mysql> set names utf8;

Enter the location of the database Student. SQL file you imported to Centos.

For example:

mysql>source /usr/database.sql;

Then you will see the success of many query statements on the screen, and then OK.