is there a way to remotely grab the databases (ie mysqldump) and have it place everything in a different file for every database? or has anyone written a script to do something like this?
dbserver having databases mysql, db1, db2 and creating backup files mysql.sql db1.sql db2.sql and at different times, databases can be added and removed from the servers, and it would be nice to have those backed up as well. (ie later in the week db3 is added and the nightly backup starts making a db3.sql file without having to edit the backup script) -- mysql, sql, query --------------------------------------------------------------------- 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