Automate WordPress backup with Python / Fabric

Sep
11
2017

Python’s Fabric module makes automation easy. This post shows how to use a Fabric script to backup a WordPress installation, but could be used for most LAMP backup situations!

Goals of this Post:

backup SQL to /tmp
backup WEB ROOT to /tmp
tar SQL + site & zip
download
delete /tmp

The Fabric script is written for to be executed as a ‘sudo’ user. If you want to perform the actions in the script as root or another user, replace ‘sudo()’ with ‘run()’.

For help installing Fabric look at my previous post: https://www.savelono.com/linux/how-to-install-python-3-and-pip-3-for-centos-6.html

For more information on Fabric: http://www.fabfile.org/

Example:

[matt@mattcom1 wpbackup]$ fab backup_all
[savelono.com] Executing task ‘backup_all’
[savelono.com] sudo: mysqldump -u savelonoadmin -p45482lonoF#m! –database savelono > savelono-$(date +%m-%d-%Y).sql
[savelono.com] out: sudo password:
[savelono.com] out:
[savelono.com] sudo: cp -rfp /var/www/html savelono-site-$(date +%m-%d-%Y)
[savelono.com] out: sudo password:
[savelono.com] out:
[savelono.com] sudo: tar -czvf savelono-site-$(date +%m-%d-%Y).tar.gz savelono-*
[savelono.com] out: sudo password:
[savelono.com] out: savelono-09-11-2017.sql
[savelono.com] out: savelono-site-09-11-2017/
[savelono.com] out: savelono-site-09-11-2017/readme.9d9380967341b4551da5eb9ee499

…

[savelono.com] out: savelono-site-09-11-2017/json2.js
[savelono.com] out: savelono-site-09-11-2017/wp-login.php
[savelono.com] out: savelono-site-09-11-2017/images
[savelono.com] out:

[savelono.com] download: /home/matt/backup/savelono-site-backups/savelono.com/savelono-site-09-11-2017.tar.gz <- /tmp/savelono-site-09-11-2017.tar.gz
[savelono.com] sudo: rm -rf /tmp/savelono*
[savelono.com] out: sudo password:
[savelono.com] out:

Done.
Disconnecting from savelono.com:7022… done.

And that’s it! Easy Python syntax for issuing remote and local shell commands through SSH. Thank you for reading! I hope you find this useful.

fabfile.py:

#!/bin/python3



from fabric.api import *
from fabric.contrib import files


# WordPress Python backup tool
# copyright matt birkland, Savelono.com 2017
# License: GPLv2
#
# 


# Set the username
env.user   = "admin"

# Set the password [NOT RECOMMENDED]
env.password = ""

# set host
env.hosts = "myblog.com"

#set port
env.port = "22"

#Wordpress project name
wp_name = "myblog"

# MySQL user
mysql_user = "admin"

mysql_pass = "T78fvbGTfhj!!56546"

# MySQL db
mysql_db = "myblog_db"

webroot = "/var/www/html"

# folder for backups

backup_folder = "/home/john/site-backups"



#  wpbackup pseudo code
# ---------------------------
#
# - configure for site
# - configure for port
# - configure MySQL user/pass variable
# - configure web root
# - configure local download directory
#        

#   ----------------

# - backup SQL to /tmp
# - backup WEB ROOT to /tmp
# - tar SQL + site & zip
# - download
# - delete /tmp
#----------------------------


# backup sql
def backup_mysql():
    with cd("/tmp/"):
        sudo("mysqldump -u {} -p{} --database {} > {}-$(date +%m-%d-%Y).sql".format(mysql_user,mysql_pass,mysql_db,wp_name))



# backup WEB ROOT
def backup_html():
    with cd("/tmp/"):
        sudo("cp -rfp /var/www/html {}-site-$(date +%m-%d-%Y)".format(wp_name))


# tar & gz
def backup_tar():
    with cd("/tmp/"):
        sudo("tar -czvf {}-site-$(date +%m-%d-%Y).tar.gz {}-*".format(wp_name,wp_name))

# retrieve 
def backup_get():
    with lcd(backup_folder):
        get("/tmp/{}-site*.tar.gz".format(wp_name))


def backup_del():
    with cd("/tmp/"):
        sudo("rm -rf /tmp/{}*".format(wp_name))
    



def backup_all():
    backup_mysql()
    backup_html()
    backup_tar()
    backup_get()
    backup_del()

100

101

102

103

#!/bin/python3

from fabric.api import *

from fabric.contrib import files

# WordPress Python backup tool

# copyright matt birkland, Savelono.com 2017

# License: GPLv2

# Set the username

env.user = "admin"

# Set the password [NOT RECOMMENDED]

env.password = ""

# set host

env.hosts = "myblog.com"

#set port

env.port = "22"

#Wordpress project name

wp_name = "myblog"

# MySQL user

mysql_user = "admin"

mysql_pass = "T78fvbGTfhj!!56546"

# MySQL db

mysql_db = "myblog_db"

webroot = "/var/www/html"

# folder for backups

backup_folder = "/home/john/site-backups"

# wpbackup pseudo code

# ---------------------------

# - configure for site

# - configure for port

# - configure MySQL user/pass variable

# - configure web root

# - configure local download directory

# ----------------

# - backup SQL to /tmp

# - backup WEB ROOT to /tmp

# - tar SQL + site & zip

# - download

# - delete /tmp

#----------------------------

# backup sql

def backup_mysql():

with cd("/tmp/"):

sudo("mysqldump -u {} -p{} --database {} > {}-$(date +%m-%d-%Y).sql".format(mysql_user,mysql_pass,mysql_db,wp_name))

# backup WEB ROOT

def backup_html():

with cd("/tmp/"):

sudo("cp -rfp /var/www/html {}-site-$(date +%m-%d-%Y)".format(wp_name))

# tar & gz

def backup_tar():

with cd("/tmp/"):

sudo("tar -czvf {}-site-$(date +%m-%d-%Y).tar.gz {}-*".format(wp_name,wp_name))

# retrieve

def backup_get():

with lcd(backup_folder):

get("/tmp/{}-site*.tar.gz".format(wp_name))

def backup_del():

with cd("/tmp/"):

sudo("rm -rf /tmp/{}*".format(wp_name))

def backup_all():

backup_mysql()

backup_html()

backup_tar()

backup_get()

backup_del()

Written by mattb in: Automation,Python | Tags: automation, fabric, Python automation, WordPress backup

No Comments »

RSS feed for comments on this post. TrackBack URL

Save Lono

Linux Stuff, IT News, and Open Source Software

Automate WordPress backup with Python / Fabric

No Comments »

Leave a comment

Recent Posts