2 replies to this topic

[LukeyJ]

Hi all,

I'm trying to run a SQL file from the mysql command prompt. I connect to a DB and type:

source c:\etc...

without the dots. Unfortunately, I lose the prompt as if it is expecting more input. I type in ; to end it, but it won't stop reading. cntrl and C closes the window. Am I doing this correctly?

I have 3 SQL commands in the .sql file.

Any help would be brilliant.

[Vaielab]

try adding quote "" around the file name

Did you select the database first (with use databaseName; )
And did you put the ; at the end of the first line?

If this is a long query, it may take some time.

[LukeyJ]

Thanks for the input.

I'm sorry to say it was a very silly mistake on my part. I saved it as a text file. So it didn't register the file name. Shame there was no meaningful warning. I'd just about given up on this, so thanks for pushing me just this little further to getting over the line! Blocker removed!