WordPress Backup Shell Script
For those seeking to backup their WordPress installations on a nightly basis, I have decided to publish the following shell script.
Below, any instance of a tilde [~] indicates /home/[username]/. Referencing to user root is key to this. You could change it to /home/[username]/ if you so chose.
#!/bin/csh -f
# Determine current date
setenv CURDATE date +%Y%m%d
# Backup all WP databases to compressed, dated file in home directory
mysqldump -q -e -hlocalhost -u[user] -p[pass] [database] | gzip - > ~/${CURDATE}_db-backup.sql.gz
# Backup WP files to compressed, dated file in home directory
cd ~/path/to/wp-files/
tar cf - . | gzip - > ~/${CURDATE}_files.tar.gz
Any data in [brackets] should be filled in, sans brackets.
This should sit in userroot, chmod’d to 755 to be executable.
You will get errors for all files in wp-uploads on the second TAR run for the backups. If you don’t want backups of your WP files but are more concerned about the backup of the database, remove everything from the last comment on down.
I personally get an email sent to me to verify that there were no errors in the running of the script. I also use FTP Voyager’s scheduler to do a Move Down on the backups to a local machine. When I can get a RAID box running at home, I’ll be dumping it to that, since I trust RAID more than a single-point-of-failure HD machine. 
May 24th, 2004 at 2:28 pm
Carving a Side of Beef
Well, I’ve migrated to WP 1.2 here in the last couple of minutes. It’ll take far longer to write this entry than it did to make the update.
The IJSM.org WP Upgrade Process
My first process was to run my backup shell script so that I had a g…
February 25th, 2005 at 5:20 pm
WordPress Backup Shell Script
GFMorris.org has a WordPress backup shell script for those seeking to backup their WordPress installations on a nightly basis. This includes the files and MySQL database….
March 4th, 2005 at 8:20 am
[...] 05 WP Backup Shell Script Categories - WordPress Hack LinkyLoo — Mark WP Backup Shell Script After Photomatt’s recent calls for backup, I [...]
March 4th, 2005 at 11:40 am
[...] tor
Just Back Up WP
Matt said Just Back Up, so here is a shell script to help you along.
This en [...]
March 6th, 2005 at 12:37 am
I’m not much of a shell scripter, but I have been having problems getting this script to work. The first problem I was having was with the SETENV statement. I fixed this by changing it to:
set CURDATE = `date +%y%m%d`
My current problem has to do with ‘mysqldump’. I keep getting this error message:
mysqldump: Got error: 1045: Access denied for user: ‘davescha_wrdp1@localhost’ (Using password: YES) when trying to connect
I have everything correct, yet the thing keeps telling me that I can’t access the DB to back it up. I have tried several variations of what was in the script. They all report the same error.
I can access the DB fine from phpMyAdmin and WP.
Any thoughts?
March 6th, 2005 at 12:47 am
It seems to me that your host has disallowed you as a user to use mysqldump [assuming, of course, that you're being hosted ;)]. That you had to change the environment doesn’t hugely surprise me; thanks for posting the SETENV statement that works for you.
Sorry that it’s not working out for you.
GFM
March 6th, 2005 at 3:02 am
Thank you, that was the question that I needed to help me figure out the mysqldump part. The user isn’t DB_USER, it’s ACCOUNT_USER! I kept putting in the username I used for the database. I thought I had actually tried that combo when I was trying to get it to work earlier. Oh well…
I made the adjustment and now it’s working perfectly.
March 8th, 2005 at 12:54 pm
[...] Email Script Categories - Cool Scripts WordPress Hack — Mark Ever since Geoff wrote the small script to backup a Wordpress installation automatically [...]
March 8th, 2005 at 1:31 pm
Email WP DB Backups to Yourself
Mark Ghosh has extended my original WordPress backup shell script to email you the sqldump and then delete the temporary backups. Sweet. This comes recommended if you don’t have access to a computer [as I do] that stays on 24/7 and can do once-night…
April 4th, 2005 at 3:15 pm
[...] p python script #!/usr/bin/env python # # Ported by Christian Wilcox from shell script found at: # http://gfmorris.org/archives/2004/04/29/wordpress-backup-shell-script/ # # Make sure to set appropriate values to vars dictionary import os import ti [...]
March 11th, 2006 at 9:31 am
Wordpress backup python script
#!/usr/bin/env python
#
# Ported by Christian Wilcox from shell script found at:
# http://gfmorris.org/archives/2004/04/29/wordpress-backup-shell-script/
#
# Make sure to set appropriate values to vars dictionary
import os
import time
vars = {
…
June 18th, 2006 at 5:57 pm
[...] I use this shell script run as a cron job and save the files the same way. [...]
March 31st, 2007 at 1:31 pm
[...] gfmorris he trobat aquest script de shell per a fer una copia de seguretat d’un blog amb WordPress. [...]
June 16th, 2008 at 11:19 am
Hi ,
I am new to shell scripting but i am stuck with the following issue , as i want to catch a python script error and if there is an error then echo eyx message:
the shell script i wrote is
#!/bin/sh
case “xyz” in
get_xml)
cd xyz
python2.5 hello_xml.pyc;
if [[ $? -ne "1" ]]; then
echo “ERROR”
exit
else
echo “Done”
fi
;;
but issue is even the python script hello_xml.pyc throws an error the shell IF statement is not catching it , it always echo “done” only!!! in both case of failure and success.
Can some one point me to correct direction.