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]