fail to run batch file

Hi,

I am running server version: 4.0.20a-nt
on Win XP pro.

I am trying to run a batch file called 'lists.sql' from the mysql prompt as follows:

mysql> source lists.sql

I get the following error message:

ERROR:
Failed to open file 'lists.sql', error: 2

My file is saved in the following directory:
D:\MySQL\

My basedir is d:\MySQL\
I verified this by running the 'show variables' command which returned the following:

mysql> SHOW GLOBAL VARIABLES like 'basedir';
+---------------+-----------+
| Variable_name | Value |
+---------------+-----------+
| basedir | D:\MySQL\ |
+---------------+-----------+
1 row in set (0.00 sec)

Does anybody know why my batch file is not found? Should I place the batch file somewhere else and not in the basedir?

Any help much appreciated.
Thanks.
Daidalus13

Have you tried specifying the entire path in your source command?

Yes I did. Here is what I got:

mysql> source `d:\mysql\lists.sql`;
ERROR:
Failed to open file '`d:\mysql\lists.sql`', error: 22

here is what perror returned:
Illegal error code: 22

Any ideas?

Remove the backticks, and you should be fine.