Backing Up Your Wordpress Blog
Before I move on to upgrading your Wordpress Blog, let’s talk about backing up the blog. Before you upgrade to a new release of Wordpress, it’s a good idea…or I’ll put this more strongly…you SHOULD back up your Wordpress Database and files.
This post will show you how to back up your Wordpress database using utilities in your CPanel. One of the many reasons I suggest getting a hosting provider that has Cpanel.
Log into your CPanel with the user name/password you received from your hosting provider when you set up your website. On CPanel, look for the PHPMyadmin icon.
Click on the phpMYadmin icon.
Next select the databases line marked here with a red arrow.
The next step you select your Wordpress Database. You probably will have only one database here. It might start with wp_ or whatever prefix the blog database was set up with. Select the database.
Click on the export tab at the top of the next screen.
Here you see where you set up the parameters for the database backup.
EXPORT
Under Export all the tables should be highlighted. If not, click on select all. Make sure the radio button next to SQL is selected.
OPTIONS
Under options, select the box next to Structure then select the following:
DATA
Select the box next to Data, but leave the rest of this section unchecked.
SAVE as file
Under the Save as file option, leave the file name template just as it is. Click on zipped.
Click on Go. The database will be backed up and saved on your computer. My next post will be about backing up the actual files on your Wordpress install.
For more information regarding other ways to backup your Wordpress database, see this website.
If you would like to learn more about creating, maintaining, and promoting your author website along with the creative spirit it represents, please subscribe to our
full RSS feed.
Your directions are so much more clear than others I’ve read! Thanks!!!
I’m anxiously awaiting the instructions on upgrading to Wordpress 2.5. *g* I’m not brave enough to try it on my own.