I prefer dumping things one database at a time so I can more easily
recover them. See script below, run from the mysqlback directory which
is at the same level as the directory containing the directories of all
of the files.
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
#!/bin/sh
date
cd ../mysql
for d in *
do
mysqldump -u root --password=ROOTPASSWORD --add-drop-table -l $d >
../mysqlback/$d.dmp
done
date
---------------------------------------------------------------------
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
