Difference between revisions of "Mysql-dumpall"
From James Dooley's Wiki
(Created page with "Script to dump all database tables as individual .sql files. Can be set up as a cron for continuous dumps. ==Script== <code>[bash,n] #!/bin/bash for d in $(mysql -e 'show dat...") |
(No difference)
|
Revision as of 00:58, 21 February 2012
Script to dump all database tables as individual .sql files. Can be set up as a cron for continuous dumps.
Script
[bash,n]
- !/bin/bash
for d in $(mysql -e 'show databases;' | grep -v Database);
do for t in $(mysql $d -e 'show tables;' | grep -v Tables);
do mysqldump $d $t > /home/mysqldump/$d.$t.sql;
done;
done
Usage
Save on server and either run manually or set up cron job.
will need to create /home/mysqldump directory (or change the directory name).
