Comment 3 for bug 483154

Platform and Version

$ uname -a
Linux robin.host.com 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

mysql> SELECT VERSION();
+------------+
| VERSION() |
+------------+
| 5.5.29-log |
+------------+
1 row in set (0.16 sec)

I downloaded the full sample database, then run:

$ mysql -uroot -proot -t < employees_db/employees.sql

I got an error for 'ERROR at line 108: Failed to open file 'load_departments.dump', error: 2'.

I tried to update the owner of employees_db directory. But I still got this error.

I viewed the 108th line of employees.sql:
$sed '108p' employees.sql -n
source load_departments.dump ;

So I understand the cause of this error. Relative Path!!!

Finally, I missed the directory of employees.sql. The right command is:
$cd employees_db
$ mysql -uroot -proot -t < employees.sql