Import an .sql file into mysql

[frumunda1]

When I try to use the source filename.sql in the mysql console I get an error 22 something about outfile disabled.

Like orace you can type @test.sql to import the contents of the test.sql file into the buffer. How do you do this in mysql?

Thanks

Confused.

 

[ToeShot]

There is a section in the help file for MySql that tells you exactly how to import the SQL file. You may want to check the web site wince they have a copy of the help file there. Sorry I don't remember what setction it is in, I think it is in 3.X

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[tarn]

You should be able to (from the MySQL> prompt) do MySQL>source /path/to/your/test.sql

It's usually as simple as that ?

Good Luck

 

[frumunda1]

I tried the source <filename command. Even the batch mode option. I keep getting an error regarding &quot;Source file not found&quot; and &quot;Outfile disabled&quot;.

 

[tarn]

What OS?

on Linux/Unix you should (from the mysql prompt) do:

mysql>source /path/to/your.sql (Note: no < required here)

Or from the OS command prompt do:
User@Linux$>mysql < /path/to/your.sql ... prompted for password maybe ...

 

[frumunda1]

I got it. Thanks for the help. I am using Winblows to play with this thing and had the .sql file on the root drive of an XP PRO machine. I think it was a permission thing. Anyway, I modified the batch file to logon with a username and password into the mysql, run the statements, and logout.

Thanks again.