search

datacharmer / test_db

A sample MySQL database with an integrated test suite, used to test your applications and database servers
4.06k stars 2.59k forks source link

Hitting an error during the sql script run #4

Closed toufiqalamau closed 7 years ago

toufiqalamau commented 7 years ago

08:44:34 set storage_engine = InnoDB Error Code: 1193. Unknown system variable 'storage_engine' 0.000 sec

When I run the 'employees.sql' I am getting this error. This is happening to all of the scripts. I am using MySql workbench the latest.

How do I make it work?

I am getting this warning as well:

action: DROP TABLE IF EXISTS dept_emp, dept_manager, titles, salaries, employees, departments

message: 0 row(s) affected, 6 warning(s): 1051 Unknown table 'employees.dept_emp' 1051 Unknown table 'employees.dept_manager' 1051 Unknown table 'employees.titles' 1051 Unknown table 'employees.salaries' 1051 Unknown table 'employees.employees' 1051 Unknown table 'employees.departments'

Would please tell me why is it happening? I am a novice learner. So, I do not know many details. Thanks.

datacharmer commented 7 years ago

You are apparently using am old version of the repository from Launchpad. Please get the latest code from this repository and try again.

The warning on "DROP TABLE IF EXISTS" is expected.