Import MySQL test database employee error

Import MySQL Test Database employee Error

: https://launchpad.net/test-db/

Upload unzip:

[Email protected] ~]# Tar XF employees_db-full-1.0.6.tar.bz2

[Email protected] ~]# CD employees_db

Using the MySQL command line tool, import the build table statements and data

Employee.sql is a built-in database statement, the default is to use the InnoDB engine, you can modify your own

[email protected] employees_db]# Mysql-uroot-p123456-t < Employees.sql # There will be an error:

ERROR 1193 (HY000) at line : Unknown systemvariable' storage_engine '

This is because the downloaded data does not follow the MySQL version upgrade changes, after the mysql5.7.5, this variable was removed, instead of default_storage_engine can be, modified as follows:

Set default_storage_engine = InnoDB;

--Set storage_engine = MyISAM;

--Set storage_engine = Falcon;

--Set storage_engine = PBXT;

--Set storage_engine = Maria;

Select CONCAT (' Storage Engine: ', @ @default_storage_engine) as INFO;

[Email protected] employees_db]# Mysql-uroot-p123456-t < Employees.sql

Import MySQL test database employee error