Installing Employees Sample Database on MySql 5.5.2.24?

Question

I am trying to install sample database from http://dev.mysql.com/doc/employee/en/index.html. I have fresh WAMP installation on my Windows 7 machine. There is currently no password setup on MySql.

When I try to run employees.sql using command bellow it reads the file creates the database and tables, but it can't load dump files. Error given is: failed to open file load_titles.dump error 2

source C:\temp\employees_db\employees.sql

Answer 1

You need put the full path to the dump files in the Employees.sql file. Edit this file on your text editor before the import.

Exemple:

'c:/user/download/load_departments.dump' instead 'load_departments.dump'.

Answer 2

You can install using MySQL workbench. click FILE>RUN SQL SCRIPT then select employees.sql

Thanks

Answer 3

Below worked for me by changing (\) to (/)

source C:/Users/pankaj/Downloads/test_db-master/show_elapsed.sql ;