Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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()
Add Comment
Please, Sign In to add comment