Use the doscommand to import an SQL file to mysql.

Use the doscommand to import an SQL file to mysql.

To sum up the method of using the doscommand to operate the mysql database. I did not pay attention to it before. It is found that this method is fast. Especially when there is no image management tool for mysql on the server.

(1) first, you must ensure that you can access the database using the command line, that is, configure the path in the environment variable. Write the bin path of the mysql folder to path;

(2) then

Mysql-uroot-proot

Note that you cannot add points later !!!;

Enter the mysql database in this way;

(3) enter the database to be modified, such as the shop to be modified,

Use shop;

Use probably means you can use the database.

(4) In the use environment, you can import the SQL file to the database named shop. Run the following command:

Source d:/shop. SQL;

Source, as its name implies, is the import resource, followed by the resource path. It is best not to have a Chinese path.