Failed to open file 'home/Scripts/Log/42.sql', error: 2

**Windhan** · 01-31-2008

Hi,

Can some one tell why the file is failed to open?

Code:

mysql> \. /home/Scripts/Log/42.sql
ERROR:
Failed to open file 'home/Scripts/Log/42.sql', error: 2
mysql>

**Windhan** · 02-04-2008

I even checked the permission for that file in that folder

Code:

myserver:/home # l -lrth
drwxrwxrwx  3 root  root  4.0K 2008-02-04 09:29 Scripts/

Code:

myserver:/home # cd /home/Scripts/
myserver:/home/Scripts/ # l -lrth
drwxrwxrwx  3 root  root  4.0K 2008-02-04 09:29 Log/

I even have full rights to access the folder and the sub-folder

But when i execute a DB Script file,

Code:

mysql> \. /home/Scripts/Log/42.sql
ERROR:
Failed to open file 'home/Scripts/Log/42.sql', error: 2
mysql>

But When i copy the same file to the home and tried,

Code:

myserver:/home/Scripts/Log # 42.sql /home/
mysql> \. /home/42.sql
Executed Successfully !!!!!!!

I could not understand the Issue here?
Some one here can help me ?

**Windhan** · 02-06-2008

Some one here to help me ?

**Windhan** · 02-07-2008

Got the solution,

But this is an alternative one,

Code:

mysql> SOURCE /home/Scripts/Log/42.sql
Executed Successfully !!!!!
mysql>

Thanks for all.