yes, write them all to a file and put that file in a directory you have access too. Then when you want to execute them:
mysql -u user -p < filename =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: Ilyas Keser [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 7:11 AM To: [EMAIL PROTECTED] Subject: sql-commands in a file HI all; I have 3 databases. I want backup all this databases by giving one command. I use the backup command to backup my databases, it seems to be the fastest way. Can I write sql the sql-commands below in a file and execute them by giving only one command? use db1 backup table tab1, tab2 tab3 to '/backup/db1'; use db2 backup table tab1, tab2 tab3 to '/backup/db2'; use db3 backup table tab1, tab2 tab3 to '/backup/db3'; Thanks Ilyas --------------------------------------------------------------------- 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
