Sunday, August 26, 2012

PyMyDB Backup 0.5.1

The first version of PyMyDB Backup has been released and is based on Python 2.4.3. This is a Python script that will back up your MySQL databases, calculate the size of the backed up files, tarball and compress the contents, then email the results.
To use:
    Download the EPEL RPM which can be found at: http://download.fedora.redhat.com/pub/epel/
     Install pymydb-0.5.1-1.noarch.rpm which can be found at: GitHub
         This script creates the necessary directories and user account
     After installation, there will be two scripts placed in /usr/local/bin which are pymydb.py and setup.py
     Run the setup.py script, this will configure the pymydb.py script
         Logs into the MySQL server
         Creates the backup user, sets a password, and gives him select and lock tables privileges
         Configures the email settings
     Change the permissions on the pymydb.py script
         chown root.pymydb pymydb.py
     Add the pymydb.py script into cron and make sure to add a password for the system user
 You can download it at my GitHub page

No comments:

Post a Comment