Mysql-dumpall - Revision history

Smsldoo at 14:32, 25 March 2014

2014-03-25T14:32:43Z

Smsldoo at 00:59, 21 February 2012

2012-02-21T00:59:51Z

Smsldoo: Created page with "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 dat..."`


2012-02-21T00:58:20Z
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..."
New page
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 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

</code>



==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).

← Older revision		Revision as of 00:59, 21 February 2012
Line 1:		Line 1:
		+	[[category:Scripts]]
	Script to dump all database tables as individual .sql files.		Script to dump all database tables as individual .sql files.
	Can be set up as a cron for continuous dumps.		Can be set up as a cron for continuous dumps.

Mysql-dumpall - Revision history

Smsldoo at 14:32, 25 March 2014

Smsldoo at 00:59, 21 February 2012

Smsldoo: Created page with "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 dat..."

Smsldoo: Created page with "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 dat..."`