We are a small, intelligent App development studio. We love "Building Amazing Apps", solving problems and cultivating strong relationships with our clients.
Automatically backup mysql database to Amazon S3 using django (Python) script
By : rama
Many of us use Amazon S3 to backup their mysql databases.As we do it so often we thought of writing an automated script which does this task of taking the backup of a mysql database and then moving it to the Amazon S3 . Below is the django script .
1: def upload_db_to_Amazons3():
2: """ function which uploadd mysql database to amazon s3"""
3:
4: AWS_ACCESS_KEY_ID = settings.AWS_ACCESS_KEY_ID
5: AWS_SECRET_ACCESS_KEY = settings.AWS_SECRET_ACCESS_KEY
6: BUCKET_NAME = settings.BUCKET_NAME
7: MYSQL_DUMP_PATH = settings.MYSQL_DUMP_PATH
8: DATABASE_NAME = settings.DATABASE_NAME
9: ARCHIVE_NAME = settings.ARCHIVE_NAME
10: .....
11:
12: proc1 = subprocess.Popen(settings.MYSQL_DUMP_PATH+" --no-data -u root -pwelcome -x --databases ...
Recent Articles
- Common testing scenarios for Django app.
- Logging in Django
- Serving static files in Django
- Two Scoops of Django: Review
- Introduction to Python Workshop on February 15th, 2013
- Easy client side form validations for Django: Django Parsley
- MoreApps - Android Library Project: Open Sourced
- Tutorial: Building a Chrome app
- Password Generator App: Open Sourced
- Todo List App: Open Sourced
About Agiliq
Topics
Archives
- April 2013
- March 2013
- February 2013
- January 2013
- November 2012
- October 2012
- September 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- October 2011
- September 2011
- July 2011
- June 2011
- April 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- June 2010
- April 2010
- March 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- April 2009
- March 2009
- February 2009
- November 2008
- October 2008
- June 2008
- May 2008
- April 2008
Django with Mysql and Apache on EC2
By : Shabda Raaj
What is EC2
Unless you have been living on Mars these last few years, you are sure to have heard of EC2. Amazon's cloud offering, it offers infinite scalability. Using EC2, you can bring up any number of machines online at minutes notice, and after you are done with them, bring them down.
How does EC2 work?
A EC2 machine is nothing but a bare machine. An Amazon Machine Image (AMI) is a machine bundled as an Image, with preconfigured software which you can start at moments notice. We will take a AMI with a basic Ubuntu installed, and ...
more info..