how do you guys back up your WP sites?
- Thread starter BlackxHat
- Start date
I use siteground for hosting, there are some good tutorials on that site on how to create backups, below are the links
hxxp://www.siteground.com/tutorials/wordpress/wordpress_backup.htm
hxxp://www.siteground.com/tutorials/php-mysql/mysql_export.htm
anyone can view the tutorials, you dont have to be a customer
hxxp://www.siteground.com/tutorials/wordpress/wordpress_backup.htm
hxxp://www.siteground.com/tutorials/php-mysql/mysql_export.htm
anyone can view the tutorials, you dont have to be a customer
I export and download the SQL file through phpmyadmin, then compress and download the public_html directory as a zip
If I want to get really fancy, I use a php script called transload and move the zip to another server in about 2 seconds.
When migrating, I export the sql file, however I untick the "save as a file" box and then copy and paste into the new database and use transload to migrate the whole site as a zip.
I admin over 150 sites, so this seems to work for me
If I want to get really fancy, I use a php script called transload and move the zip to another server in about 2 seconds.
When migrating, I export the sql file, however I untick the "save as a file" box and then copy and paste into the new database and use transload to migrate the whole site as a zip.
I admin over 150 sites, so this seems to work for me
stradivari
Junior Member
- Mar 25, 2010
- 127
- 28
Another vote for mysql dump on text file (compressed with phpmysql if too large) + zipping the html root folder. HTH.
madhackercracker
Newbie
- Nov 29, 2008
- 18
- 8
I use "WP-DB-Backup" Plugin for database backup and "Wordpress Backup (by BTE)" Plugin for backing up Images, Theme and Plugins Folder. Also use "Export" option under the "Tools" menu in the Wordpress dashboard.
Thanks for mentioning the BTE plugin. I've been casually wondering how I was going to backup my themes and plugins. Looks like I have a solution.
Anyone else needing a file backup for wp should look into this. It has all the options of the WP-DB backup I recommended earlier, it can email backups, schedule them, etc.
Last edited:
adultsubmitter
Newbie
- Jul 3, 2010
- 6
- 0
Just installed "WP-DB-Backup plugin" not used it...
wpbacklinks
Elite Member
- Mar 27, 2010
- 3,762
- 1,499
i backup my wp sites manually..
dragonfly0607
Newbie
- Jun 30, 2010
- 37
- 2
I usually back it up in some site that provide database back up like drivehq.
do you have shell access to your server? then you could write a small shell script to backup your files and database contents to amazon s3 storage services. very reliable and cheap prices.but dont just create a backup plan, also create a restore concept. nothing is more worse to have all files backed up but dont know how to restore them within a short time on failure. for myself an important part. (i'm backing up my files and database dumps on FTP every night at 1:45)
MySQLdump and cron. Below is a part of my script which I use to backup all my mysql databases on my server.
Code:
for db in `find /var/lib/mysql/ -type d`
do
db2=$(basename $db)
/usr/bin/mysqldump --user root --password="youradminpasswd" --opt $db2 | bzip2 -c > /home/dump/$db2.sql.bz2
done