mysql < your_script.sql or
cat your_script.sql | mysql This assumes you have your username and password set up in your my.cnf or .my.cnf (home directory). If not, add the -u[username] -p[password] switches. --jeff ----- Original Message ----- > From: "Chetan Lavti" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, February 23, 2002 12:06 AM > Subject: Script for database creation > > > > > > hi, > > I have written a script for database creation and table creation. Now I > > want to run this script from the MySQL prompt. How can I do this..? > > Please , anybody know about this , so that I can create my database by > > simply running that script. > > > > Thanks and regards, > > Chetan Lavti > > > > > > > > --------------------------------------------------------------------- > > 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