O'Reilly logo

WordPress® All-in-One For Dummies® by Michael Torbert, Andrea Rennick, Kevin Palmer, Cory Miller, Lisa Sabin-Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Backing Up Your Database

Before upgrading your WordPress software installation, make sure you back up your database. This step isn't required, of course, but it's a smart step to take to safeguard your Web site and ensure you have a complete copy of your Web site data in the event that your upgrade goes wrong.

The best way to back up your database is to use the MySQL administration interface provided to you by your Web hosting provider. (Book II, Chapter 5 takes you through the steps of creating a new database by using the phpMyAdmin interface.)

image cPanel is a Web hosting interface provided by many Web hosts as a Web hosting account management tool that contains phpMyAdmin as the preferred tool to use to manage and administer databases. Not all Web hosts use cPanel or phpMyAdmin, however, so if yours doesn't, you need to consult the user documentation for the tools that your Web host provides. The instructions in this chapter are provided by using cPanel and phpMyAdmin.

The following takes you through the steps of creating a database backup, using the same phpMyAdmin interface:

  1. Log in to the cPanel for your hosting account.

    Typically, browse to http://yourdomain.com/cpanel to bring up the login screen for your cPanel. Enter your specific hosting account username and password in the login fields and click OK to log in.

  2. Click the phpMyAdmin icon.

    The phpMyAdmin interface opens and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required