Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import an .sql file into mysql
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... -
Newb question, How to open a database in mysql
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 -
Import an .sql file into mysql
I tried the source <filename command. Even the batch mode option. I keep getting an error regarding "Source file not found" and "Outfile disabled". -
Import an .sql file into mysql
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.
