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...
do a mysql>show databases command. If you don't see your database there then it's either a zipped file, scripts to create your database or something else.
Regards,
JG
I tried the source <filename command. Even the batch mode option. I keep getting an error regarding "Source file not found" and "Outfile disabled".
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.