(1)下载文件 employees_db-full-1.0.6.tar.bz2
(2)通过xshell rz方式上传文件,通过以下命令解压
tar jxf employees_db-full-1.0.6.tar.bz2
(3)安装employee数据库
[root@localhost employees_db]# mysql -uroot -S /tmp/mysql.sock -p < employees.sql
Enter password:
INFO
CREATING DATABASE STRUCTURE
ERROR 1193 (HY000) at line 38: Unknown system variable 'storage_engine'
解决方法:
[root@localhost employees_db]# vim employees.sql
DROP DATABASE IF EXISTS employees;
CREATE DATABASE IF NOT EXISTS employees;
USE employees;
SELECT 'CREATING DATABASE STRUCTURE' as 'INFO';
DROP TABLE IF EXISTS dept_emp,
dept_manager,
titles,
salaries,
employees,
departments;
set storage_engine = InnoD