It's been over 2 months since I've wrote any posts for the blog series and honestly, this might be the last one. There is tons of info online laid out beautifully on how to do stuff with Wordpress, so to avoid re-inventing the wheel I will likely stop with this post.
I just wanted to write up this quick post about how to backup your WP database (and some other important files). It's not necessary to backup the entire WP installation because those files can be easily downloaded from Wordpress.org if need be. I always just backup any files that I have modified or customized and any other files that I created. The WP installation files collectively are too big just to back them up for the heck of it.
Back when I used to develop web sites I would always have the most recent copy of the site on my computer so I always had a backup. Plus the database was a stand alone file so there was no exporting necessary. Now with WP, because it uses MySQL, the DB has to be exported and the development files aren't on my local machine. There is an easy and automated way to back up the DB. The rest of the files don't really need to be backed up too often. (But it really depends how often you make changes and how reliable the backup that your web hosting provider offers. I don't rely on my web host at all for backups.)
For my installations...I usually just backup the folder that contains all my encrypted affiliate redirect files, the images folder (or wp uploads if you use that), my customized .htaccess and robots.txt files, and the plugins and themes folder.
Automatic Wordpress DB Backup Direct to Email
I started using a plugin for backing up my Wordpress DB. You can backup anytime you want manually and download the export file or have it compressed and emailed to you. I just set it up to automatically email me a copy once a week (you can change the schedule to never, hourly or daily). When the new one comes in, I delete the old one. Anytime a new plugin is installed and creates tables in the DB, you can go back into Manage > Backup to add the new tables so they will be backed up as well.
 |
 Associated WordPress .com Two Premium Domain Names NR!  US $1.25
|
 Wordpress Blogs Made Easy Video Series + Resell On CD US $4.99
|
 WordPress For Dummies ~ NEW ~ Never Read ~ US $18.99
|
 6 Brand New Wordpress Review Sites Pack US $2.99
|
 How to Create & Post Your Own Wordpress Blog 10 VIDEOS US $2.99
|
| Powered by phpBay Pro |
Related posts:
- Blog Series – From Setup To ? – Part 2 – Downloading And Installing WordPress
- Blog Series – From Setup To ? – Part 2a – Quick-Installing WordPress with GoDaddy
- Blog Series – From Setup To ? – Part 4 – Changing The Theme
- Blog Series – From Setup To ? – Part 3 – Steps Before Changing The Theme
- Blog Series – From Setup To ? – Part 1
Enter your first name and email address below to receive exclusive money making tips.
July 4th, 2008 at 9:28 am
I use the same plugin for my db backups. Piece of mind is a great thing! Of course, to really get piece of mind I should attempt to do a restore on another site but I haven’t tried that yet.
Peter Answerss last blog post..Tarot Cards – The Two of Cups
July 4th, 2008 at 12:39 pm
I’ve done the restore when moving my site to a different hosting account…worked beautifully…