Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- # backs up wordpress database and files
- set -e
- ###### set your variables
- BLOGDIR="/home/username/public_html/blog" ## location of blog on server
- BUDIR="/home/username/blogbu" ## location of backups on server
- DBNAME='dbname' ## name of your blog's database
- DBUSER='dbuser' ## database username
- DBPW='dbpasswd' ## database password
- ### cron is funky about its PATH, so add paths to all commands here:
- PATH=/bin:/usr/bin:/usr/local/mysql/bin
- ### set date & time
- datetime=`date "+%Y%m%d-%H%M"`
- echo $datetime
- ### Backup database in BUDIR
- echo "Creating db backup..."
- mysqldump --user $DBUSER --password=$DBPW $DBNAME | gzip > $BUDIR/wpdb-$datetime.sql.gz
- echo "Done with db backup"
- ### Backup files into BUDIR
- echo "Creating wp file backup..."
- tar -czf $BUDIR/wpfiles-$datetime.tar.gz $BLOGDIR
- echo "Done with wp file backup"
- ### Delete backups over three days old (adjust depending on need/space)
- echo "Deleting backups over three days old..."
- find $BUDIR -mtime +3 -exec rm -f {} \;
- echo "All Done";
Add Comment
Please, Sign In to add comment