MySQL Install employees DB steps

Because you are ready to start learning the Advanced section of ASP, so tonight to install a database example, Baidu found that the original MySQL has a employees db

But simply follow the online approach, there is no way to import, so wrote this blog post, as a note.

2 articles are referenced in this article:

http://ari.iteye.com/blog/1066690

http://blog.csdn.net/xiaoshuai1127/article/details/50545181

I would like to express my appreciation to the two authors here.

The steps are as follows:

First, download

Address:https://launchpad.net/test-db/employees-db-1/1.0.6

Second, decompression

Unzip the downloaded files and store them in any directory, but for convenience, it is recommended to place them in a shorter path, and mine is placed in: E:\employees_db

Third, modify the contents of the import file

Using WordPad, open the contents of the Employees.sql in the previous folder, starting with the 38th line as follows:

   Set storage_engine = innodb;--Set storage_engine = myisam;--Set storage_engine = falcon;--Set storage_engine = PBXT;-- Set storage_engine = Maria;select CONCAT (' Storage Engine: ', @ @storage_engine) as INFO;

Without this step, in the next import, will prompt Storage_engine error, the specific reason I am not clear, but I know my MySQL root directory under the My.ini file, set up Default-storage-engine=innodb, This sentence represents the default storage engine that will be used when creating a new table, and you can see the statement in Employees.sql, which is the option to indicate that there are 5 storage_engine, the default is InnoDB, as I set it, but still the hint is not found, the estimate is the version of the problem, Because this employees_db is rather old,

Through Baidu to the result, as said inside, MySQL by default is InnoDB, so put this line also commented out on the line, by the way also the following query statement commented out, the code is as follows:

--Set storage_engine = innodb;--Set storage_engine = myisam;--Set storage_engine = falcon;--set storage_engine = PBXT; --Set storage_engine = maria;--Select CONCAT (' Storage Engine: ', @ @storage_engine) as INFO;

Iv. Import

Win + R, enter cmd to open the command line and enter the following command:

E:

CD employees_db

MYSQL-T-U root-p < employees.sql

Enter password

Complete, you can use it.

The following diagram is also very useful:

MySQL Install employees DB steps