WordPress 中文文档

出自WordPress Chinese 中文文档

wordpress.org.cn

It is strongly recommended that you backup your database at regular intervals and before an upgrade.

Restoring your database from backup is then possible if something goes wrong.

Backup using cPanel X

cPanel is a popular control panel used by many web host. The backup feature can be used to backup your MySql database. Do not generate a full backup. Look for 'Download a MySQL Database Backup' and click the name of the database. A *.gz file will be downloaded to your local drive.

There is no need to unzip this file to restore it. Using the same cPanel program, browse to the gz file and upload it. Once the upload is complete, the bottom of the browser will indicate dump complete. If you are uploading to a new host, you will need to recreate the database user along with the matching password. If you change the password, make the corresponding change in the wp-config.php file.

Using phpMyAdmin

phpMyAdmin is the name of the program used to manipulate your database.

Information below has been tried and tested using phpMyAdmin versions 2.5.3, 2.5.7-pl1, and 2.6.1-pl3 running on Unix.

Detailed options are listed below, though in most cases you will be fine with the default export options.

Backup Process with phpMyAdmin

ol liLog into phpMyAdmin on your server/libr liFrom the main login screen, select 'Databases'/li File:Podz backup 1.jpgbrbr

liNow click the name of your database - or your WordPress database if you have several databases./li File:Podz backup 2.jpgbrbr

liThe next screen will show you all the tables inside your WordPress database.br / Ignore those, and click the 'Export' tab on the top set of tabs./li File:Podz backup 3.jpgbrbr

liLook at the left box at the top of the Export section. All the tables in the database you selected are in that box./li File:PhpMyAdmin backup export.png ul liIf you have other programs that use the database, then choose only those tables that correspond to your wordpress install. They will be the ones with that start with wp_ or whatever 'table_prefix' you specified in your 'wp-config.php' file./li liIf you only have your WordPress blog installed, leave it as is (or click 'Select All' if you changed the selection)/li liEnsure that SQL is checked!/li /ulbr File:Phpmyadmin bentrem.jpg liThe SQL section /li Tick the following boxes:ulli'Structure'/li li'Add DROP TABLE / VIEW / PROCEDURE / FUNCTION'/li li'Add IF NOT EXISTS'/li li'Add AUTO_INCREMENT' and/li li'Enclose table and field names with backquotes'/li /ulbr

liThe DATA section/li Leave the boxes inside this section unticked, but make sure to keep the checkbox next to the DATA heading checked./li File:PhpMyAdmin backup data.pngbrbr

liTick the 'Save as file' option, and leave the template name as is./li File:Podz backup 5.jpgbr

liNow click 'Go' and you should be prompted for a file to download. Save the file to your computer.br / Depending on the database size, this may take a few moments./libr

liYou have now backed up your database./li If you wanted, you could download a backup in each of the compression formats. Your choice. For example: None and zipped: File:Podz backup 6.gif

Remember - you have NOT backed up the files and folders - such as images - but all your posts and comments are now safe./li /ol

Using Straight MySQL Commands

phpMyAdmin can not handle large databases so using straight MySQL code will help.

1. Change your directory to the directory you want to dump things to:

preuser@linux:~ cd files/blog/pre

2. Use codemysqldump/code to dump all database tables. To dump only certain tables from the database, give their names at the place shown by code(tablename tablename tablename)/code, and omit the parentheses code( )/code in any case. (For help, try: codeman mysqldump/code.):

preuser@linux:~/files/blog mysqldump --add-drop-table -h mysqlhostserver

-u mysqlusername -p databasename (tablename tablename tablename) | bzip2
-c  blog.bak.sql.bz2

Enter password: (enter your mysql password) user@linux~/files/blog/pre

pre Example: mysqldump --add-drop-table -h db01.example.net -u dbocodex -p dbwp | bzip2 -c blog.bak.sql.bz2

Enter password: my-password user@linux~/files/blog /pre

The codebzip2 -c/code after the | (pipe) means the backup is compressed on the fly, and the codegt; blog.bak.sql.bz2/code sends the codebzip/code output to a file named codeblog.bak.sql.bz2/code. It does in one line the same thing that these two commands do: pre mysqldump --add-drop-table -h db01.example.net -u dbocodex -p dbwp blog.bak.sql bzip2 blog.bak.sql /pre

Using MySQL Workbench

MySQL Workbench (formerly known as MySQL Administrator) is a program for performing administrative operations, such as configuring your MySQL server, monitoring its status and performance, starting and stopping it, managing users and connections, performing backups, restoring backups and a number of other administrative tasks.

You can perform most of those tasks using a command line interface such as that provided by mysqladmin or mysql, but MySQL Workbench is advantageous in the following respects:

• Its graphical user interface makes it more intuitive to use.
• It provides a better overview of the settings that are crucial for the performance, reliability, and security of your MySQL servers.
• It displays performance indicators graphically, thus making it easier to determine and tune server settings.
• It is available for Linux, Windows and MacOS X, and allows a remote client to backup the database across platforms. As long as you have access to the MySQL databases on the remote server, you can backup your data to wherever you have write access.
• There is no limit to the size of the database to be backed up as there is with phpMyAdmin.

Note: The instruction below was written for older version (MySQL Administrator).

Backing Up the Database

This assumes you have already installed MySQL Admin and set it up so that you can login to the MySQL Database Server either locally or remotely. Refer to the documentation that comes with the installation package of MySQL Admin for your platform for installation instructions.

ol liOpen the MySQL Admin client and login as you had previously set up to do./li liFrom the icon menu on the left hand side of the client window select Backup./li liIf you have not already created a Backup Project, do this now by clicking on the New Project button at the lower part of the window and type in a name for the Backup Project where prompted./li liSelect one or more databases that you want to Backup (in the MySQL Admin client these are called a Schema (pl. Schemata)). Add them to the Backup Content window on the right using the right-pointing arrow button./li liWhen you have selected the Schema(ta), you can save the Backup Project. Or you may simply choose to Backup Now using the button on the lower right of the window./li liA dialogue will come up asking you where to put the Backup. Enter the pathname or browse to the location using the dialogue./li liAssuming all is correct (and you have write permissions in the directory to which you are writing the Backup), the backup will complete shortly./li /ol

Restoring From a Backup

ol liOpen the MySQL Admin client and login as you had previously set up to do./li liFrom the icon menu on the left hand side of the client window select Restore./li liClick the Open Backup File button on the lower right of the window./li liType in or browse to the Schema(ta) backup file and select. Click Open./li liThe Target Schema(ta) will most likely be the Original Location, or you may choose an alternate location using the drop-down menu./li liClick the Start Restore button on the lower right of the window. The database restore will commence./li /ol

MySQL GUI Tools

In addition to MySQL Workbench, there are many GUI tools that let you backup (export) your database.

Using WordPress Database Backup Plugin

Austin Matzko maintains a WordPress plugin originally created by Skippy called WordPress Database Backup (WP-DB-Backup). It was bundled with WordPress 2.0 but is no longer included with WordPress 2.1.

Installation

1. Search WP-DB-Backup on Administration Plugins Panel Add New.
2. Activate the plugin.
3. The plugin will attempt to create a directory code/wp-content/backup-*//code inside your WordPress directory. You may need to make code/wp-content/code writable (at least temporarily) for it to create this directory.

Backing up

1. Navigate to Administration Tools Backup Panel
2. Select any tables, in addition to the core WordPress tables, that should be backed-up.
3. Select the Backup Options; the backup can be saved on the server, downloaded, or emailed.
4. Finally, click on the Backup button to actually perform the backup. You can also schedule regular backups.

Restoring the Data

The file created is a standard SQL file. If you want information about how to upload that file, look at Restoring Your Database From Backup.

Resources and Backup Plugins

• Backup at its elementary level
• WordPress Database Backup Plugin