4 Ways to Backup your WordPress Database
January 14, 2010 by uttoransen
Filed under Blogging Tips
WordPress is the leading CMS for blogs and is used by most self-hosted blogs on the Internet these days. Today in this article, am going to talk about a few ways to back up your wordpress database so that if something went bad, you will have sufficient backup files to restore your blog to a previous safe and secure state.
-
database export wordpress
Export from wordpress panel – this is the easiest way to backup a wordpress blog. All you have to do is, login to your wordpress admin panel and navigate to the tools option. In the tools you will find a tab that says export. Click on that and download an xml backup file of your wordpress containing your posts, pages, comments, custom fields, categories, and tags. This is one of the easiest ways to backup wordpress database, and when you need to use the xml backup, just use the import option and wordpress will slowly import everything from the xml backup file.
-
database manager plugin wordpress
Next option is to backup using a wordpress plugin – wordpress has many utility plugins that provides a wide array of features. One such plugin is, “WP-DBManager”. This is not only for database backups but also have a lot of features, which includes database repair and optimize which has helped me a lot in the past.
- Back up from the control panel – Your hosting provider gives you a control panel, most likely it will be cpanel, however my host is godaddy and it provides me with a custom panel. If you are a godaddy user then login to your godaddy account. Select the hosting account you want to backup for and then click on – “manage account” next to it. After that click on database and select mysql. From the mysql page click on edit/view details button under the “action” button. That will slide down some options, which will include backup database and restore database.
- Backup from PhpMyAdmin – Its not that much technical as it sounds, rather it’s a quick way to access and manage database. For backing up a database from phpmyadmin, just click on the “open manager” button on the same page of point number 3. Once you click on the open manager button, it will take you to phpmyadmin page, there you will be first asked for database login details. Once you login, you will enter phpmyadmin. There, simply select the database and click on the export button. Select sql file as backup file and you are done. In the same way for restoring a backup, use the import button.
Note: You will find database and phpmyadmin options in your cpanel as well.
Proper and timely backups will surely make blogging life easy. Remember it takes just a few minutes to make backups and the same few minutes to restore a backup, but if something goes wrong without a backup then it can take ages of manual labor to get your blog to a state, where it was, when it was up and running.
This is great information on backing up your word press.. There is nothing like losing information.
hi Cheapest Domain Name Registration,
if you put your name in the name field, it will be easy for me to address you,
anyways, thanks for your comments, glad you like it,
regards,
uttoransen,
Cheers mate,
good info here.
hi Nathan,
thanks for your comments,
Another good database backup is WP-DB-Backup plugin
http://wordpress.org/extend/plugins/wp-db-backup/
hi Andy Brudtkuhl,
thanks for your comment,
We do it the simple way – just go into your dbadmin control panel and export in the default sql format. If you need to view the information inside your database you can export to a word document and search out relevant content.
Hope this helps -
Jonathan Patterson
Patterson Communications
Thought you’d be interested in the plugin we released today – that automagically backs up both your WP files and database to amazon S3. We are backing up our entire network of WP sites with it now – works fantastic. No manual backups and no PHPMYAdmin, etc!
I backup my wordpress database by use export facility, and also use “DB-manager” plugin as second choice.
.-= Dana @ Blogging Update´s last blog ..The Right Website Design Company Can Help Your Business =-.
db manager is good, by export you mean the mysql export from phpmyadmin or the one available in the wordpress admin under tools? the xml file export of wordpress do not export all the things available in the mysql database though…
I mean the export tools in wordpress admin.
.-= Dana @ Blogging Update´s last blog ..The Right Website Design Company Can Help Your Business =-.
that tool is a personal favorite, but it surely has some limitations, it doesnot backs up everything that is in the database…
if there have any other source or only this one?
sorry warrichpk, would not understand what you mean by that, can you please rephrase that? thanks,
It is also easy to backup and transfer all your websites from one server to another server if you have cPanel installed:,~
I have 100 domains on Godaddy and i can say that this company is very reputable.*”:
A cool way of backup the entire data,which is very important if any time the data get corrupted then and then only you can backup your data get the thing easy..
I usually using wp db backup to backup my wp database daily sent to my email. It help me so much and not worrying anything when something happen to my blog
Thanks for this article – it helped me a lot as a WordPress newbie.