sagar-webonise · July 25, 2012 09:12 · shenhab · May 27, 2017 · ghost · Mar 15, 2018
diff --git a/readme.txt b/readme.txt
 --- created by sagar shirsath ([email protected])---

 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


diff --git a/pydump.py b/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()
	--- created by sagar shirsath ([email protected])---

	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
	#!/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()