mysql newbie needs help

[Adam]

Hi,

I'm teaching myself mysql and I'm doing ok but I've run into a problem I can't seem to figure out. To experiment with running batch files I created a small file that contains...

show databases;

and named the file 'showdb.txt'. When I issue this command from the command prompt:

mysql>source showdb.txt;

I get this error...

ERROR:
Failed to open file 'showdb.txt', error: 2

At first I thought it was simply a path issue so I tried putting showdb.txt in various folders. I put it in: bin, data\nameofdatabase, mysql, but none of that worked. Does anyone know what I'm doing wrong?

Thanks,
Adam

[Ronald Wernecke]

Hi Adam,
welcome to the boards.

Under which os are you using this?
Are you root, or admin user?
Are you logged on to the database?

[Adam]

Hi Ronald,

In response:

>>>Under which os are you using this?
I am running this under windows 2000 professional. I have MYSQL installed on my system in the c:\mysql folder.

>>>Are you root, or admin user?
I have logged in as root and I have created a password for root. I have exited and logged back in several times without a problem.

>>>Are you logged on to the database?
I have typed in "show databases;" and I see both mysql and test databases. I typed 'use test;' to enter the test database. I have created tables successfully using the create command and I have dropped tables as well. From command line, all queries seem to work fine.

Thanks,
Adam