Python script for taking mysqldump

readme.txt

--- created by sagar shirsath (sagars@weboniselab.com)---

the file pydump contains python code for taking sql dump .

How to run :
    Go to folder containing file pydump and run the following command
    $python pydump.py

pydump.py

#!/usr/bin/env python
import ConfigParser
import os
import time
import getpass

def get_dump():
    print "Enter user:"
    user = raw_input()

    print "Password will not be visible:"
    password = getpass.getpass()

    print "Enter host:"
    host = raw_input()

    print "Enter database name:"
    database = raw_input()


    filestamp = time.strftime('%Y-%m-%d-%I:%M')
    os.popen("mysqldump -u %s -p%s -h %s -e --opt -c %s | gzip -c > %s.gz" % (user,password,host,database,database+"_"+filestamp))
    
    print "\n-- please have a the dump file in "+database+"_"+filestamp+".gz --"

if __name__=="__main__":
    get_dump()
    

Hi Team,
I'm maintaining MySQL with 7 databases as per my application needs by excluding default dbs. Now I want one Python script to take mysql dump, it should give below requirements.

1. It should take dump all 7 databases into one backup folder, by excluding 5 tables from one of the databases.
2. It should make backup folder as zip with timestamp.
3. Upload this zip file to the AWS S3.
4. I should get mail even this process failed or succeeded.
5. Delete backup zip files which are existing more than 7 days.

Hey there,

Thanks for your effort.
I have upgraded the script to Python 3 here: https://github.com/gurutux/GuruTux/blob/master/MySQL/pydump.py

given link is not working(404)

Hey there,
Thanks for your effort.
I have upgraded the script to Python 3 here: https://github.com/gurutux/GuruTux/blob/master/MySQL/pydump.py

given link is not working(404)

yes @gurutux can you check the link

Hey there,
Thanks for your effort.
I have upgraded the script to Python 3 here: https://github.com/gurutux/GuruTux/blob/master/MySQL/pydump.py

given link is not working(404)

yes @gurutux can you check the link

Just go to his profile, it's there.