Using Google Mail as Backup Storage
Over the years I have slowly found WordPress the ultimate content management system for not only blogs but a number for of websites that I’ve developed. However, until recently I didn’t have an ideal back up solution.
Running a content network, the most important element to my business and sites is content, more specifically the words. WordPress stores the words (and links to other media etc) in a database file and while I’ve found it easy to back up the pictures and other other media, backing up the MySQL database has been my biggest problem.
Until a few weeks ago I was occasionally making the odd MySQL backup. This ‘solution’ worked in as much as I ended up with a database but in the sprit of computer science I wanted to automate the manual process.
Enter WP-DBManager, a lovely WordPress plugin that will repair, optimize and backup your database.
This plugin allows you to schedule your database backup to run automatically. The file is the dumped into your WordPress directory for you use, but more importantly, the plugin will sent a copy of the backup in an email as an attachment.
This is the secret sauce of my backup solution, using Google Mail to store my backup files. It is all good and great to keep the files on the local disk but that uses up scarce disk space (I run a hosting company, I know that there is no such thing as ‘unlimited disk-space’) and what if the disk was to fail?
In my solution, I keep five days of backups on the local disk and intend to keep a year’s worth of backups on Google. Why Google? Well right now, Google is offing near to 7GB of disk-space free of charge for email storage and Google has a relatively good history of not losing email data.
When my backups hit Google, they are ‘labeled’ based on which blog they came from and archived using a filter.
With this set up, I can now back up the database of my sites as often as I like – right now, I’m backing up every eight hours. If I were really paranoid about data loss, I could set Google to forward email messages to the likes of Yahoo! Mail and repeat.
Restoring a backup is dead easy too. Using the plugin, I can select a database on the local disk and back up from that or upload an archived backup from Google.
That is my slightly paranoid back up procedure for my WordPress MySQL databases. How do you go about backing up your databases?
I use the exact same method
I agree this this same method that I used as well. This is an excellent a more cost effective method when it comes to small business.
In a sea of canoes, Google is a yacht. Gmail is awesome and doesn’t have all the bouncing issues that say, Yahoo or Hotmail have. I love the storage feature too. They do say to also back up the info elsewhere too, just in case the fringe benefits of Gmail should be interfered with.
Thank you for your message. Friends sent a link to it. Interestingly turned and looked, and others. Subscribe. I would have navedyvatsya
it is so sad that the king of pop is already dead… we are going to miss him but his music will be remembered forever…
Michael Jackson is my favorite pop artist ever since i was a child. He is truly the King of Pop and i am saddened by this news.
When looking for affordable hosting – This been quite some time since im looking for some way to answer my qestion on to make money online. Now i found it it your blog. I add this tomy favorites.
Michael Jackson was a really great singer. I like his lyrics and the way he tries to influent the listener. He is the only one and i thin people won’t forget him the next 1.000 years!
Greetings to all of you
Michael jackson was an phenominal artist and the Best dancer in the world , no one will be able to come even close to what he had achieved in his Life . Every Song of MJ is My Favourite Song.”I Love You forever”.He was the best . His music is so pure that i feels like i am in complete different world , infact i am listening to his music right now while writing this . Now (you are not alone ) Song is going on , i wish just for once in a life time i would have met him , I just can’t stop loving you Rest in Peace “MJ”.
Yo, nice blog, i’d be interested to know what spam plugin you use for comments because i get lots on my blog.
i will really miss the King of Pop. michael jackson is truly the best pop artist in this lifetime.:`: