Using your database backup

Wednesday, July 14th, 2010 at 8:39 am

Hopefully this is something you never need. One of the things I do and recommend is a regular backup of your database for your blog. It is a preventive item and if you ever need it you will be ever so glad that you have done this.

You can use a plugin (WPDatabase Backup) to email you a copy of your data base and I set up a special Gmail account to collect them so I can just login once a week and make sure that the automation I think I have set up is actually working .

Remember you can leave your questions in the comments for future answers here. Now to today’s question.

Mike, you mention back-up routines several times. I have learned the hard way and doing this now. I can backup and restore through cpanel. You can also backup from within WP (under tools) but nothing on that page on how to restore. Then you can export and use the file to import to another site. Just wondering when you want to do that.

You can’t import the database back into WordPress from the WordPress dashboard. You will need to login to your cpanel and use PhpMyAdmin to replace the database.

Now if I had a data base injection I would start with a new data base and import an uncorrupted past data base to this new data base. It would mean I would need to edit the wp-config.php file to point to the new data base.

Below I have added a video that will show you how to import a data base in to this new one.

The other part of the question was when you would use this. That would be a rare case where you have decided to move your content to a new domain but would need to have all the proper redirects set up on a previous domain.

Not likely for a single entrepreneur but a company that gets taken over by another would be a case where this might be used.

Remember that you can ask your questions in the comments for future posts.

One other note that the $10 discount on Profitable Blog Steps ends on the 20th. If you are looking for a step by step plan to get your affiliate marketing running better check it out.

About the author

Mike Paetzold got started blogging in 2003 and has become an expert on using WordPress. He has become known as The WordPress Guy.

After being an under ground niche marketer using his blogs he has surfaced to share some of the ways he uses blogs to enter various niches profitably.

If you would like help in building your business check out my coaching offer.