Book Image

WordPress 2.7 Cookbook

Book Image

WordPress 2.7 Cookbook

Overview of this book

About 120,000 blogs are created every day. Most of them quickly die, but a few stay, grow up, and then become well known and respected places on the Web. If you are seriously interested in being in the top league, you will need to learn all the tricks of the trade. WordPress 2.7 Cookbook focuses on providing solutions to common WordPress problems, to make sure that your blog will be one of the ones that stay. The author's experience with WordPress enables him to share insights on using WordPress effectively, in a clear and friendly way, giving practical hands-on solutions to WordPress problems, questions, and common tasks ñ from themes to widgets and from SEO to security. Are you feeling limited with WordPress, or are you wondering how popular blogs do a certain kind of thing that you can't? With this cookbook, you will learn many WordPress secrets and techniques, with step-by-step, useful recipes dedicated to achieving a particular goal or solve a particular problem. You'll learn the secret of expensive premium themes, how to optimize your blog for SEO and online profits, and how to supercharge WordPress with killer functions used by the most popular blogs over the Internet.
Table of Contents (17 chapters)
WordPress 2.7 Cookbook
Credits
About the Author
About the Reviewers
Preface
2
Finding and Installing Themes
Index

Restoring a MySQL backup


Now that you know how to create a backup of your blog database, the next very important point is to know how to restore it when needed. Believe it or not, I have read about a lot of users asking for help on the forums, as they had the backup of their database, but were not able to restore it in their database.

Getting ready

To achieve this recipe, you need a backup of your blog database. If you don't have one, then create one by carrying out the steps in the previous recipe.

Note

Don't try this recipe on a production blog! This is for emergencies only. If you want to test it, then you should install WordPress locally and perform your tests on this local install.

How to do it...

  1. Log in to phpMyAdmin and select your WordPress database.

  2. Click on the Import tab from the horizontal menu.

  3. Click on the Browse button and select the backup on your hard drive.

  4. Once done, scroll down the page and click on the Execute button.

  5. The database backup has been imported into your database and...