Installing Employees Sample Database on MySql 5.5.2.24?

mysql

Solution

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'.

Problem

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 ```

Original source