Missed file

[Wagner Bianchi]

HI friends,

When I tried to load a restore of employees database on MySQL, I miss file "load_departments.dump".

+-----------------------------+
| INFO |
+-----------------------------+
| LOADING departments |
+------------------------------+
1 row in set (0,00 sec)

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

...and then, MySQL said "Bye" to me... :(

What about? Can you help me?

Thanks!

[Giuseppe Maxia (giuseppe-maxia)]

It looks like you have only downloaded the code, without the dump files.
If you get the "full" package, you should be able to run everything smoothly

[Wagner Bianchi (wagnerbianchi)]

Ok Mr Maxia, Iĺl try download the complete package and then proceed with
restore process.

Thnak you!

A presto.

WBianchi

2009/11/15 Giuseppe Maxia <email address hidden>

> It looks like you have only downloaded the code, without the dump files.
> If you get the "full" package, you should be able to run everything
> smoothly
>
> ** Changed in: test-db
> Status: New => Incomplete
>
> --
> Missed file
> https://bugs.launchpad.net/bugs/483154
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Sample database with test suite: Incomplete
>
> Bug description:
> HI friends,
>
> When I tried to load a restore of employees database on MySQL, I miss file
> "load_departments.dump".
>
> +-----------------------------+
> | INFO |
> +-----------------------------+
> | LOADING departments |
> +------------------------------+
> 1 row in set (0,00 sec)
>
> ERROR at line 108: Failed to open file 'load_departments.dump', error: 2
>
> ...and then, MySQL said "Bye" to me... :(
>
> What about? Can you help me?
>
> Thanks!
>

--
Wagner Bianchi - Consultor/Especialista em Bancos de Dados MySQL
Eac Software Divisão de Banco de Dados e Segurança da Informação
E-mail: <email address hidden>
Phone: (31) 3273 - 4415 ramal 228 / (31) 8448 - 0496
Home: www.eacsoftware.com.br

[Robin Wen (wgbno27)]

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