not sure if it's what you're looking for... but you can always do mysql>"system -uuser1 -ppassword <foo.sql" which will then run whatever is inside foo.sql...
you can easily incorporate this approach inside a perl/php app after you've created the db object... -bruce -----Original Message----- From: Andre MATOS [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:21 AM To: [EMAIL PROTECTED] Subject: Scripts Hi List, Let's suppose that I have a script to create one database (tables, indexes, etc). How can I call another script from this script? For example: DROP DATABASE test; CREATE DATABASE test; (here call another script) back to the previous script Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]