How to backup your blog

Hello there! If you are new here, you might want to subscribe to the RSS feed for updates on this topic or sign up to my Email Newsletter.

hd_backupyourdata

It is very important to backup your blog’s data. You don’t want loose any of your data. There are two things that you need to do to backup the data. You need to backup the database and you need to backup the web site files.

How to backup the database files

Your web hosting company should have a application called phpMyAdmin. If you don’t have this then ask your web host to download it and install it onto the shared hosting or dedicated server. This will save you a lot of time to import sql files.

This is what the home page looks like when you first go into it.

phpmyadmin_screen1

You then want to pick the database that you want to export to sql file. I will pick my blogs database on the left hand side. At the root of the database you want to click on the Export link. This will pick all the tables that are in the database.

phpmyadmin_screen2

This shows the root of the database listing all of the tables that are in the database.

phpmyadmin_screen3

This screen is where you will pick the tables that you want to save to an SQL file. By default it selects all of the tables because we did the export at the root of the database. You then want to click on the check box save as file, and the final set is to hit the GO button. You will then pick the file location to save it and you can also put a different title so you can review it easy.

You should pick a schedule and stick with it. When I do a major change I will to a full backup of the database, and I will also do a full backup of the website files. You can also get a WordPress plugin that will email you your database. That will be good to do everyday because your website changes all of the time.

How to backup the web site files

All you have to do is pick your favorite FTP application and connect to your website. The next step that I like to do is highlight all files in the root directory and click the download button to download all the files that are in the whole folder for your website.

phpmyadmin_screen4

This how I backup my files for my blog. I can also backup every website that I host, and also backup all of the databases that attached to my shared hosting account. How does everyone else backup their data for their website?

Share and Enjoy:

If you enjoyed this post, make sure you subscribe to my RSS feed!

Related Posts

February 12, 2009 | Filed Under Blog

5 Comments

Comments

5 Responses to “How to backup your blog”

Posts about WordPress Plugins as of February 12, 2009 | The Lessnau Lounge on February 12th, 2009 11:34 am

[...] -> twitterLink for WordPress Comment ??? Extend › Plugins ???? ??????????????? How to backup your blog – gregellison.net 02/12/2009 It is very important to backup your blog’s data. You don’t want [...]
Quick Weight Loss on February 14th, 2009 6:28 am

I have seen this phpAdmin on my webhost, but I am scared of using it. I don’t want to mess up mu database that my website is gone.

How about the export capabilities on wordpress?
Administrator on February 14th, 2009 12:14 pm

The only why to learn is to try. Don’t be scared. You just don’t want to hit the empty link and you will be fine. Greg Ellison
Paul Morales on February 16th, 2009 4:54 pm

Thanks! I needed to learn how to back up my blog. Great post. I like your blog btw good job!
Administrator on February 16th, 2009 6:06 pm

Your welcome Paul. I am glade this post helped you out. Greg Ellison