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 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 Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com 

Are you MySQL certified?  http://www.mysql.com/certification/ 


****************************************************************
                        Please Note
The information in this E-mail message is legally privileged
and confidential information intended only for the use of the
individual(s) named above. If you, the reader of this message,
are not the intended recipient, you are hereby notified that 
you should not further disseminate, distribute, or forward this
E-mail message. If you have received this E-mail in error,
please notify the sender. Thank you
*****************************************************************

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to