Hi, This should do the trick....
mysql > source /path/to/file.sql or shell > mysql databasename < /path/to/file.sql And it doesn't matter about the file extension. Kevin ----- Original Message ----- From: "Jarlath . Hennelly" <[EMAIL PROTECTED]> To: "MySQL (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, January 22, 2002 1:18 PM Subject: Running SQL Scripts > Dudes & Dudettes, > > I got a SQL script with all the SQL to setup a database. But I can't seem to > access the script. I did this before so I know it can be done, but I've to > do it for a new project, and I can't remeber how. > > So I've 2 questions : > - Does my script file need to be a .sql file or just a plain .txt file??? > - What command do I use : mysql < file_name <<<<<< Is this correct > > Any help would be greatly appreciated. > > cheers, > J > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php