Skip navigation links

MySQL Forums :: Newbie :: Run Mysql Script from Command Prompt


Advanced Search

Run Mysql Script from Command Prompt
Posted by: Vishwaradhya J ()
Date: January 16, 2008 01:39AM

HI ,


I am new to Mysql,

I have set of instructions in a script file called Test.sql file and tried to run the file from the command prompt.

I have set the environmental variables for Mysql and from the command prompt, i have type mysql and it will use mysql.

The command i have typed is " mysql> source Test.sql" and get an error:

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

Could please guide me through :

Queries:

1. I want to know where i have to save the script file in which i will be having mysql commands.
2. And what command i have to type in the command prompt to execute the script file.

Regards
Vishwa

Options: ReplyQuote


Subject Written By Posted
Run Mysql Script from Command Prompt Vishwaradhya J 01/16/2008 01:39AM
Re: Run Mysql Script from Command Prompt liu yingjiang 01/16/2008 07:02AM
Re: Run Mysql Script from Command Prompt Vishwaradhya J 01/17/2008 12:23AM
Re: Run Mysql Script from Command Prompt liu yingjiang 01/17/2008 12:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.