Difference between revisions of "Mysql-dumpall"
From James Dooley's Wiki
| Line 4: | Line 4: | ||
==Script== | ==Script== | ||
| − | < | + | <source lang='bash'> |
#!/bin/bash | #!/bin/bash | ||
for d in $(mysql -e 'show databases;' | grep -v Database); | for d in $(mysql -e 'show databases;' | grep -v Database); | ||
| Line 11: | Line 11: | ||
done; | done; | ||
done | done | ||
| − | </ | + | </source> |
==Usage== | ==Usage== | ||
Latest revision as of 14:32, 25 March 2014
Script to dump all database tables as individual .sql files. Can be set up as a cron for continuous dumps.
Script
#!/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).
