Small script to dump all local mysql databases

dumpdatabases.py

#!/usr/bin/env python
import os
import re
import subprocess

user="onlyme"
password="xxxxxxx"

proc = subprocess.Popen(["mysql", "-u" + user, "-p" + password],
	stdin=subprocess.PIPE, stdout=subprocess.PIPE, stderr = subprocess.PIPE)
output, errors = proc.communicate("SHOW DATABASES")

for database in output.splitlines()[1:]:
    if database != 'information_schema':
        print "Dumping %s" % database
        file = open("%s.sql" % database, 'w')
        proc = subprocess.Popen(["mysqldump", "-u" + user, "-p" + password, database],
        	stdout=file)
        proc.communicate()
        file.close()

It has been very useful, just what I needed. Thank you!!!