Re: read in a .sql file

Thanks all, I had to use the use database name as well as put the password in the first line and that worked... >>> Paul DuBois <[EMAIL PROTECTED]> 07/18/03 02:59PM >>> At 14:44 -0500 7/18/03, Taylor Lewick wrote: >I have a large SQL file that contains a bunch of create table statements... >How d

Re: read in a .sql file

At 14:44 -0500 7/18/03, Taylor Lewick wrote: I have a large SQL file that contains a bunch of create table statements... How do I get mysql to read in this file and process the sql. mysql < file.sql or mysql db_name < file.sql if you need to set the database name first. -- Paul DuBois, Senior

Re: read in a .sql file

after creating the database with "mysql create DATABASE" do a mysql < .sqlfile. Make sure to add the line use DATABASENAME; at the top of the sql file. On Fri, 2003-07-18 at 14:44, Taylor Lewick wrote: > I have a large SQL file that contains a bunch of create table statements... > How do I get mys

read in a .sql file

I have a large SQL file that contains a bunch of create table statements... How do I get mysql to read in this file and process the sql. I am not thinking load data infile because it isn't text... Please No