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

Creating manual backups of your WordPress blog


If you must remember only one recipe from the entire book, then it has to be this one. All of your WordPress data (posts, pages, categories, comments, and so on) are saved in a MySQL database. Without the database, the only thing you'll get is an empty theme. Having backups of your WordPress database is not just important, it's mandatory.

Getting ready

In this recipe, we're going to manually create a backup of your MySQL database using phpMyAdmin.

To achieve this recipe, you have to be sure that phpMyAdmin is successfully installed on your web server. Most web hosts have it installed by default. However, you will have to check and see whether it is installed on yours or not.

How to do it...

  1. Log in to your phpMyAdmin (the phpMyAdmin URL depends of your server, ask your web host if you don't know its URL yet).

  2. If you're using multiple databases, then select the one related to your WordPress blog.

  3. Click on the export button on the horizontal menu.

  4. From...