Please help, I am trying to run the .sql file

[reddymade]

Can you please help me.
I have a .sql file which has all the scripts to create tables in mysql .

my database name is mydatabase.

The .sql file is located at the path: c:\myapp\loader\db_tables_01.sql

Can you please help me, i am using on windows 2000 server.

Thank you very much.

[tomhath]

Have you tried doing what the manual suggests? Was there a problem?

http://dev.mysql.com/doc/mysql/en/Batch_mode.html

[reddymade]

Hello Tomhath,

I tried to do
source "c:\mydbfile\dbmyfiles.sql" ;

I am using windows with mysql getting the error saying: unable to open file error: 22

I have also downloaded the sql administrator utility: can you please tell me how i can run the batch using the utility.

Thank you very much.

[tomhath]

Assuming you have mysql installed in c:\mysql and you have a mysql user account name of reddymade, open a command tool, the session should look something like this:

c:> cd \myapp\loader
c:\myapp\loader> c:\mysql\bin\mysql -u reddymade -p
Enter password: ******
mysql> use mydatabase
Database changed
mysql> source db_tables_01.sql
<output from your script>
mysql> exit
Bye
c:\myapp\loader>

If you haven't set up an account with a password, try running mysql without the "-u reddymade -p" part, it should let you right in as the default user with no password.

If you have phpmyadmin installed, open it up in a browser (usually http://localhost/phpmyadmin/), select the database from the dropdown on the left, pick the SQL tab, and enter the location of the textfile in the lower part of the page and press Go.