Shulou(Shulou.com)06/01 Report--

Import the sql file into the Mysql database through the command

Step1: if you do not mysql the installation path in the windows environment variable path, copy the sql file to the C:\ Windows\ Temp file. This gives the mysql server permission to read.

Step2: enter the bin folder under the MySQL directory: the path to the bin folder of cd MySQL is like the command line I entered: cd D:\ Program Files\ MySQL\ MySQL Server 5.1\ bin (or add the path directly to the windows environment variable path).

Step3: enter the MySQL:mysql-u username-p password as I entered on the command line: mysql-uroot-p123.

Step4: create the database you want to build, and then the database is a database without tables. For example, I created a new database called ygeshop.

Step5: enter: mysql > use target database name, such as: mysql > use ygeshop.

Step6: import file: mysql > source imported file name; such as the command line I entered: mysql > source ygeshop.sql.

Command to restart the mysql service:

1. Enter cmd first to open the command window

two。 Stop service: net stop mysql

3. Start the service: net start mysql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.