Hi, > 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?
There's propably a more refined way to do this, but this simple hack should do the trick. (Substitute HOST, USER and PASS with values matching your site): --start backup.sh-- #!/bin/sh for i in `echo show databases|mysql -s -hHOST -uUSER -pPASS` do mysqldump -hHOST -uUSER -pPASS --opt $i > $i.sql done --end backup.sh-- -- Med venlig hilsen / Kind regards, Tommy Eriksen Systemadministrator, ModuleWEB.NET http://www.modulweb.dk/ - [EMAIL PROTECTED] +45 70 22 33 04 - +45 70 22 33 08 (direct) --------------------------------------------------------------------- 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
