Changes

Jump to: navigation, search

Talk:MySQL - dumping and restoring

265 bytes added, 21:13, 7 April 2009
Different method proposed
Wouldn't it be easier to do this in a for loop instead?
Something like this:

for i in $(echo 'SHOW DATABASES;' | mysql -u<username> -p<password> | grep -v '^Database$'); do
mysqldump --<some-options-for-mysqldump> $i > db-backup_$i.sql
done

-- Tor (tor@tblab.net)
Anonymous user

Navigation menu