Hi, If you type mysql at the prompt you must interactively type commands at the mysql> prompt and type quit to exit. However I think it's generally better in cases like yours to run in batch mode.
Type: mysql <pet.mysql. This will read the script from the file and execute it. If you want the output to be redirected to a file also add >pets.out. In batch mode by default a concise format is used, but if you want tables to be drawn around the output like in interactive mode use the -t switch. Finally if you want the output to contain your typed commands use the -vvv switch. So you end up with: c:\mysql\scripts> mysql -t -vvv <pets.mysql >pets.out I have only started using MySQL and only run it on a stand-alone system. If you are designing a database for a web site etc then you may need to provide extra parameters like the hostname. Hope this helps. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqibshaikh.com/ ----- Original Message ----- From: "Barbara Ferrell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 11, 2001 3:47 AM Subject: how to get a script to run/work > i want to convert my access database to mysql. and then it will run on a > linux server if i ever figure out how to run these darn scripts though.... > i downloaded mysql for windows 98. i have tried for a week to run these > scripts and even reinstalled mysql and even tried it on another computer > with nt4.0. this is where i saved mysql and the title of the script i want > to run. > > C:\mysql\scripts\pet.sql > > i am sitting at the mysql prompt and i have the server/daemon running in the > background. > > Please exactly what do i type after the mysql prompt?? > > > > > --------------------------------------------------------------------- > 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