久久精品水蜜桃av综合天堂,久久精品丝袜高跟鞋,精品国产肉丝袜久久,国产一区二区三区色噜噜,黑人video粗暴亚裔

WordPress: Backing Up Your Database：修訂間差異

來自站長(zhǎng)百科
跳轉(zhuǎn)至： 導(dǎo)航、? 搜索
（新頁(yè)面: '''It is strongly recommended that you backup your database at regular intervals and before an upgrade.''' [[WordPress:Restoring Your Database From Backup|Restoring your database from ba...）
?
無(wú)編輯摘要
?
（未顯示3個(gè)用戶的4個(gè)中間版本）
第1行： 第1行：
'''It is strongly recommended that you backup your database at regular intervals and before an upgrade.'''
<span style="border:1px solid #000; text-align:center; float:right; padding:6px;"><strong>導(dǎo)航:</strong> [[WordPress:WordPress文檔|上一級(jí)]] | [[WordPress]] | {{Template:WordPress導(dǎo)航}}</span>
<div style="clear:both;"></div>
'''強(qiáng)烈建議定時(shí)備份，每次更新前也做一次備份。.'''


[[WordPress:Restoring Your Database From Backup|Restoring your database from backup]] is then possible if something goes wrong.
[[WordPress:Restoring Your Database From Backup|從你的備份中恢復(fù)數(shù)據(jù)庫(kù)]]可以在你遇到問題時(shí)使用。


== Using phpMyAdmin ==
== 使用 phpMyAdmin ==


[[WordPress:phpMyAdmin]] is the name of the program used to manipulate your database. ?
[[WordPress:phpMyAdmin| phpMyAdmin]]是一個(gè)用來操作你的數(shù)據(jù)庫(kù)的程序. ?


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.
下邊的信息已經(jīng)通過使用phpMyAdmin versions 2.5.3, 2.5.7-pl1，和2.6.1-pl3運(yùn)行在Unix系統(tǒng)上的測(cè)試。


=== Backup Process with phpMyAdmin ===
=== 使用phpMyAdmin的備份過程 ===
<ol>[[WordPress:Image:podz_backup_1.jpg|thumb|Image#1]]
<ol>[[WordPress:Image:podz_backup_1.jpg|thumb|Image#1]]
<li>Log into phpMyAdmin on your server</li>
<li>在你的服務(wù)器上登陸phpMyAdmin </li>
[[WordPress:Image:podz_backup_2.jpg|thumb|Image#2]]
[[WordPress:Image:podz_backup_2.jpg|thumb|Image#2]]


<li>From the main login screen, select 'Databases' (Image#1)</li>
?
<li>從主登陸界面選擇 'Databases' (Image#1)</li>
[[WordPress:Image:podz_backup_3.jpg|thumb|Image#3]]
[[WordPress:Image:podz_backup_3.jpg|thumb|Image#3]]


<li>Now click the name of your database - or your WordPress database if you have several databases. (Image#2)</li>
<li>現(xiàn)在點(diǎn)你的數(shù)據(jù)庫(kù)的名字 – 或者你的 WordPress數(shù)據(jù)庫(kù)，如果你有好幾個(gè)數(shù)據(jù)庫(kù)的話. (Image#2)</li>
[[WordPress:Image:podz_backup_4.jpg|thumb|Image#4]]
[[WordPress:Image:podz_backup_4.jpg|thumb|Image#4]]


<li>The next screen will show you all the tables inside your WordPress database.<br />
<li>下一個(gè)界面將顯示你的 WordPress 數(shù)據(jù)庫(kù)中所有的表格.<br />
Ignore those, and click the 'Export' tab on the top set of tabs. (Image#3)</li>
忽略這些，在頂部標(biāo)簽中點(diǎn)擊'Export' 標(biāo)簽. (Image#3)</li>


<li>Look at the left box at the top of the Export section. All the tables in the database you selected are in that box.(Image#4)</li>
<li>查看Export部分的頂部左邊框. 所有你選擇的數(shù)據(jù)庫(kù)中的表格都在這個(gè)方框中.(Image#4)</li>
[[WordPress:Image:podz_backup_5.jpg|thumb|Image#5]]
[[WordPress:Image:podz_backup_5.jpg|thumb|Image#5]]
<ul>
<ul>
<li>If 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>
<li>如果你有別的使用數(shù)據(jù)庫(kù)的程序,那么選擇那些符合 wordpress安裝的表格 . 它們以 "wp_" 或者是 'table_prefix' 開頭，你在你的 'wp-config.php' 文件中詳細(xì)指定過的.</li>


<li>If you only have your WordPress blog installed, in the left column, click 'Select All'.</li>
<li>如果你只安裝了 WordPress blog, 在左邊欄中點(diǎn)擊 'Select All'.</li>
</ul>
</ul>


<li>Ensure that the SQL button is selected too. (Image#5)</li>
<li>確保SQL 按鈕被選中. (Image#5)</li>
<ul>
<ul>
<li>The SQL section</li>
<li> SQL 部分</li>


<li>Tick the following boxes: Structure, 'Add DROP TABLE', 'Add AUTO_INCREMENT' and 'Enclose table and field names with backquotes'</li></ul>
<li>勾選一下方框: Structure, 'Add DROP TABLE', 'Add AUTO_INCREMENT' 和 'Enclose table and field names with backquotes'</li></ul>


<li>The DATA section</li>
<li> DATA部分</li>
<ul>[[WordPress:Image:podz_backup_6.gif|thumb|Image#6]]
<ul>[[WordPress:Image:podz_backup_6.gif|thumb|Image#6]]


<li>Leave the boxes inside this section unticked, but make sure to keep the checkbox next to the "DATA" heading checked.</li>
<li>這部分之內(nèi)的方框不要勾選，但是要確定在保持"DATA"旁邊的復(fù)選框是選中狀態(tài).</li>
</ul>
</ul>


<li>Tick the 'Save as file' option, and leave the template name alone.<br />
<li>勾選 'Save as file' 操作, 留下一個(gè)模板名字.<br />
For now, select 'None' for compression.</li>
現(xiàn)在壓縮選中 'None'.</li>


<li>Now click 'Go' and you should be prompted for a file to download. Save the file to your computer. (Image#6)<br />
<li>現(xiàn)在點(diǎn)擊 'Go' ，你應(yīng)該被提示說有個(gè)文件下載，保存這個(gè)文件到你的電腦上. (Image#6)<br />
Depending on the database size, this may take a few moments.</li>
根據(jù)數(shù)據(jù)庫(kù)的大小，這會(huì)花去你幾分鐘的時(shí)間.</li>


<li>Once that download is complete, check the 'zipped' option, click 'Go', and download the next file.<br />
<li>下載完成后，查看'zipped' 操作, 點(diǎn)擊 'Go', 下載另外一個(gè)文件.<br />
If you wanted, you could download a backup in each of the compression formats. Your choice.</li>
如果你想的話，你可以下載每個(gè)文件的壓縮格式的備份。你的選擇.</li>


<li>You have now backed up your database.</li>
<li>現(xiàn)在，你的數(shù)據(jù)庫(kù)已經(jīng)備份完畢.</li>




'''Remember''' - you have NOT backed up the files and folders - such as images - but all your posts and comments are now safe.</li>
'''記住''' – 你沒有備份文件和文件夾 – 如圖片- 但是所有你的文章和評(píng)論現(xiàn)在已經(jīng)是安全的了.</li>
</ol>
</ol>


== Using Straight MySQL Commands ==
== 直接使用 MySQL 命令==


phpMyAdmin can not handle large databases so using straight MySQL code will help.
phpMyAdmin 不能掌控大的數(shù)據(jù)庫(kù)所以用直接 MySQL 代碼會(huì)有所幫助 will help.


1. Change your directory to the directory you want to dump things to:
1. 把目錄改成你想儲(chǔ)存臨時(shí)數(shù)據(jù)的地方:


<pre>user@linux:~> cd files/blog</pre>
<pre>user@linux:~> cd files/blog</pre>


2. Use <code>mysqldump</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: <code>man mysqldump</code>.):
2. 使用 <code>mysqldump</code> 來儲(chǔ)存所有的數(shù)據(jù)庫(kù)表格. 想儲(chǔ)存某個(gè)特定的數(shù)據(jù)庫(kù)表格,在通過<code>(tablename tablename tablename)</code>顯示出來的地方給它們命名, 忽略<code>( )</code> 中的圓括號(hào). (想獲得幫助信息, 嘗試: <code>man mysqldump</code>.):


<pre>user@linux:~/files/blog> mysqldump --add-drop-table -h mysqlhostserver
<pre>user@linux:~/files/blog> mysqldump --add-drop-table -h mysqlhostserver
第83行： 第86行：
</pre>
</pre>


The <code>bzip2 -c</code> after the | (pipe) means the backup is compressed on the fly, and the <code>&gt; blog.bak.sql.bz2</code> sends the <code>bzip</code> output to a file named <code>blog.bak.sql.bz2</code>. It does in one line the same thing that these two commands do:
| (pipe)之后的<code>bzip2 -c</code>語(yǔ)句意思是備份已經(jīng)被壓縮, <code>&gt; blog.bak.sql.bz2</code>發(fā)送<code>bzip</code>到一個(gè)名字叫做的文件中。 <code>blog.bak.sql.bz2</code>. 和下面兩個(gè)命令做的是同樣的事情：
<pre>
<pre>
mysqldump --add-drop-table -h db01.example.net -u dbocodex -p dbwp > blog.bak.sql
mysqldump --add-drop-table -h db01.example.net -u dbocodex -p dbwp > blog.bak.sql
第89行： 第92行：
</pre>
</pre>


== Using MySQL Administrator ==
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 [http://dev.mysql.com/doc/mysql/en/mysqladmin.html '''mysqladmin'''] or
[http://dev.mysql.com/doc/mysql/en/mysql.html '''mysql'''], but MySQL Administrator 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.
== 使用 MySQL 管理員 ==
MySQL 管理員是一個(gè)執(zhí)行管理的程序。
操作, 如設(shè)置你的MySQL 服務(wù)器, 監(jiān)測(cè)它的狀態(tài)和表現(xiàn), 開始或者是停止, 管理用戶和連接，執(zhí)行備份，儲(chǔ)存?zhèn)浞莸鹊纫幌盗衅渌芾砣蝿?wù)。你可以使用命令行界面執(zhí)行這些任務(wù)中的大多數(shù)。如由[http://dev.mysql.com/doc/mysql/en/mysqladmin.html '''mysqladmin'''] 或者
[http://dev.mysql.com/doc/mysql/en/mysql.html '''mysql''']提供的, 但是MySQL 管理員在下面這些方面更具有優(yōu)勢(shì)：


*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.
*它提供了更好的對(duì)你的MySQL服務(wù)器的界面，可靠性和安全性至關(guān)緊要的設(shè)置總覽。


MySQL Administrator is designed to work with MySQL servers versions 4.0 and above.
*它顯示性能指示器是圖形化的，這更容易決定和調(diào)整服務(wù)器設(shè)置。


=== Getting MySQL Admin ===
* Linux, Windows and MacOS X都可以使用, 允許遠(yuǎn)程客戶端備份數(shù)據(jù)庫(kù)交叉平臺(tái). 只要你進(jìn)入了遠(yuǎn)程MySQL 數(shù)據(jù)庫(kù), 你就可以備份你的數(shù)據(jù)到任何具有寫入權(quán)限的地方。


MySQL Admin may be downloaded from [http://dev.mysql.com/downloads/administrator/1.0.html the MySQL.Com site]. Installation binaries and documentation may also be found there.
*對(duì)備份數(shù)據(jù)庫(kù)的大小沒有限制，因?yàn)橛衟hpMyAdmin.


=== Backing Up the Database ===
MySQL Administrator 是為MySQL servers 版本 4.0 及以上設(shè)計(jì)使用的。
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.


1. Open the MySQL Admin client and login as you had previously set up to do.
=== 使用MySQL 管理 ===


2. From the icon menu on the left hand side of the client window select Backup.
MySQL 管理可以從[http://dev.mysql.com/downloads/administrator/1.0.html the MySQL.Com site]下載. 安裝文件也可以從這里找到.


3. If 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.
=== 備份數(shù)據(jù)庫(kù) ===
這里假設(shè)你已經(jīng)安裝了MySQL Admin 并設(shè)置好，這樣你就可以本地或者遠(yuǎn)程登陸MySQL Database Server. 查閱安裝說明中的MySQL Admin安裝包文件。


4. Select 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.
1. 打開MySQL Admin 客戶端登陸.


5. When 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.
2. 從程序窗口左邊的圖像菜單中選擇Backup.


6. A dialogue will come up asking you where to put the Backup. Enter the pathname or browse to the location using the dialogue.
3. 如果你沒有創(chuàng)建一個(gè)Backup 項(xiàng)目, 現(xiàn)在點(diǎn)擊窗口下部的 "New Project" 按鈕，為Backup Project輸入一個(gè)名字.


7. Assuming all is correct (and you have write permissions in the directory to which you are writing the Backup), the backup will complete shortly.
4. 選擇一個(gè)或者更多你想備份的數(shù)據(jù)庫(kù)(在MySQL Admin 程序中，這些叫做 "Schema" (pl. "Schemata")). 使用指向右邊的箭頭把它們加入到右邊的Backup Content 窗口 。


=== Restoring From a Backup ===
5. 當(dāng)你選擇了Schema(ta), 你可以保存?zhèn)浞蓓?xiàng)目. 或者你可以簡(jiǎn)單的選擇右下方的Backup Now 按鈕.


1. Open the MySQL Admin client and login as you had previously set up to do.
6. 一個(gè)對(duì)話框?qū)?huì)產(chǎn)生，詢問你要把備份保存在什么地方。輸入路徑名字或者通過瀏覽保存。


2. From the icon menu on the left hand side of the client window select Restore.
7. 假設(shè)所有步驟都正確 (并且你在寫備份的目錄擁有寫入權(quán)限), 備份會(huì)很快完成.


3. Click the "Open Backup File" button on the lower right of the window.
=== 從備份中恢復(fù) ===


4. Type in or browse to the Schema(ta) backup file and select. Click "Open".
1. 打開MySQL Admin 程序登陸.


5. The Target Schema(ta) will most likely be the "Original Location", or you may choose an alternate location using the drop-down menu.
2. 從圖形界面的程序窗口左手邊選擇 Restore.


6. Click the "Start Restore" button on the lower right of the window. The database restore will commence.
3. 點(diǎn)擊右下方的"Open Backup File" 按鈕。


== Using WordPress Database Backup Plugin ==
4. 輸入或者瀏覽至 Schema(ta) 備份文件，選擇，點(diǎn)擊"Open".
[http://www.ilfilosofo.com/ Austin Matzko] maintains a [[WordPress:Plugins|WordPress plugin]] originally created by [http://www.skippy.net Skippy] called [http://www.ilfilosofo.com/blog/wp-db-backup WordPress Database Backup]. It was bundled with WordPress 2.0 but is no longer included with WordPress 2.1.


===Install the Plugin===
5. 目標(biāo) Schema(ta) 通常會(huì)在"Original Location", 或者你可以使用下拉菜單選擇一個(gè)替代位置.
# If you do download the plugin, follow the directions in the ''wp-db-backup.txt'' file to install the plugin correctly.


=== Activate the Plugin ===
6. 點(diǎn)擊右窗口下方 "Start Restore" 按鈕。 數(shù)據(jù)庫(kù)恢復(fù)開始
# Make sure the <tt>wp-content</tt> folder is [[WordPress:Changing_File_Permissions|writeable]] by your server (change its CHMOD)
# Go to your? [[WordPress:Administration_Panels|Administration]] > [[WordPress:Administration_Panels#Plugins|Plugins]] > [[WordPress:Managing_Plugins|Plugins Panel]] and activate the plug-in


===Backing up===
== 使用WordPress 數(shù)據(jù)庫(kù)備份插件 ==
# Navigate to [[WordPress:Administration_Panels|Administration]] > [[WordPress:Administration_Panels#Backup|Manage]] > [[WordPress:Manage_Backup_SubPanel|Backup Panel]]
[http://www.ilfilosofo.com/ Austin Matzko] 維持了一個(gè) [[WordPress:Plugins|WordPress 插件]] ，最初是[http://www.skippy.net Skippy]創(chuàng)建的，叫做 called [http://www.ilfilosofo.com/blog/wp-db-backup WordPress 數(shù)據(jù)庫(kù)備份]. 它與WordPress 2.0綁定，但是現(xiàn)在不包括在WordPress 2.1中了。
# Select any tables, in addition to the core WordPress tables, that should be backed-up.? Select the Backup Options; the backup can be saved on the server, downloaded, or emailed.? Finally, click on the Backup button to actually perform the backup.? If you have installed the [http://www.skippy.net/blog/category/wordpress/plugins/wp-cron/ WP-Cron plugin], you can schedule daily backups.
===安裝插件===
# 如果你下載了這個(gè)插件，按照''wp-db-backup.txt'' 文件中的說明正確安裝插件.
=== 激活插件 ===
# 確定<tt>wp-content</tt> 文件夾是通過你的服務(wù)器 [[WordPress:Changing_File_Permissions|可寫入的]] (更改 CHMOD)
# 進(jìn)入[[WordPress:Administration_Panels|Administration]] > [[WordPress:Administration_Panels#Plugins|Plugins]] > [[WordPress:Managing_Plugins|Plugins Panel]] 激活插件。


=== Restoring the Data===
===備份===
The file created is a standard SQL file. If you want information about how to upload that file, look at [[WordPress:Restoring Your Database From Backup]].
# 進(jìn)入[[WordPress:Administration_Panels|Administration]] > [[WordPress:Administration_Panels#Backup|Manage]] > [[WordPress:Manage_Backup_SubPanel|Backup Panel]]
# 選擇任何表格, 除了核心WordPress表格, 都應(yīng)該被備份.? 選擇備份Backup操作; 備份會(huì)被保存到服務(wù)器上，下載或者被郵寄. 最后, 點(diǎn)擊Backup按鈕來執(zhí)行備份。如果你安裝了[http://www.skippy.net/blog/category/wordpress/plugins/wp-cron/ WP-Cron 插件], 你可以設(shè)置每日備份.


== Using CocoaMySQL ==
=== 恢復(fù)數(shù)據(jù)===
創(chuàng)建的文件是標(biāo)準(zhǔn)的 SQL 文件. 如果你想知道如何上傳文件，參見[[WordPress:Restoring Your Database From Backup|從備份中恢復(fù)數(shù)據(jù)]].
== 使用 CocoaMySQL ==


[http://cocoamysql.sourceforge.net CocoaMySQL] is a free MySQL client for Mac OS X.
[http://cocoamysql.sourceforge.net CocoaMySQL]是一個(gè)免費(fèi)的基于Mac OS X的 MySQL 客戶端.


Open your database from CocoaMySQL and choose <strong>File → Export → MySQL file…</strong>, and check these options:
從CocoaMySQL 打開你的數(shù)據(jù)庫(kù)選擇<strong>File → Export → MySQL file…</strong>, 查看如下操作:


* Add drop table
* Add drop table
第175行： 第171行：
[[WordPress:Image:cocoamysql_export_dialog.png]]
[[WordPress:Image:cocoamysql_export_dialog.png]]


== Resources and Backup Plugins ==
== 資源和備份插件 ==


* [[WordPress:Backup WPMU|Backup at its elementary level]]
* [[WordPress:Backup WPMU|初級(jí)備份]]
* [http://www.clearpointsystems.com/wp04/?page_id=18 How to backup and restore a WordPress database]
* [http://www.clearpointsystems.com/wp04/?page_id=18 如何備份和恢復(fù)WordPress 數(shù)據(jù)庫(kù)]
* [[WordPress:Plugins/BackUpWordPress]] for automated backups.
* [[WordPress:Plugins/BackUpWordPress|插件/ BackUpWordPress]] 自動(dòng)備份.
* [http://www.ilfilosofo.com/blog/wp-db-backup WordPress Database Backup Plugin]
* [http://www.ilfilosofo.com/blog/wp-db-backup WordPress 數(shù)據(jù)庫(kù)備份插件]
* [http://www.quickonlinetips.com/archives/2007/06/reduce-database-backup-size-delete-akismet-blocked-spam/ Reduce Database Backup Size: Delete Akismet Spam]
* [http://www.quickonlinetips.com/archives/2007/06/reduce-database-backup-size-delete-akismet-blocked-spam/ Reduce 數(shù)據(jù)庫(kù)備份大小: 刪除 Akismet Spam]

2008年5月27日 (二) 10:49的最新版本

導(dǎo)航: 上一級(jí) | WordPress | 首頁(yè) | WordPress中文論壇 | WordPress主機(jī) | CMS程序 | 論壇程序 | ECShop | ShopNC | PowerEasy

強(qiáng)烈建議定時(shí)備份，每次更新前也做一次備份。.

從你的備份中恢復(fù)數(shù)據(jù)庫(kù)可以在你遇到問題時(shí)使用。

使用 phpMyAdmin[ ]

phpMyAdmin是一個(gè)用來操作你的數(shù)據(jù)庫(kù)的程序.

下邊的信息已經(jīng)通過使用phpMyAdmin versions 2.5.3, 2.5.7-pl1，和2.6.1-pl3運(yùn)行在Unix系統(tǒng)上的測(cè)試。

使用phpMyAdmin的備份過程[ ]

    thumb|Image#1
  1. 在你的服務(wù)器上登陸phpMyAdmin
    2. thumb|Image#2
  2. 從主登陸界面選擇 'Databases' (Image#1)
    3. thumb|Image#3
  3. 現(xiàn)在點(diǎn)你的數(shù)據(jù)庫(kù)的名字 – 或者你的 WordPress數(shù)據(jù)庫(kù)，如果你有好幾個(gè)數(shù)據(jù)庫(kù)的話. (Image#2)
    4. thumb|Image#4
  4. 下一個(gè)界面將顯示你的 WordPress 數(shù)據(jù)庫(kù)中所有的表格.
    忽略這些，在頂部標(biāo)簽中點(diǎn)擊'Export' 標(biāo)簽. (Image#3)
  5. 查看Export部分的頂部左邊框. 所有你選擇的數(shù)據(jù)庫(kù)中的表格都在這個(gè)方框中.(Image#4)
    6. thumb|Image#5
    • 如果你有別的使用數(shù)據(jù)庫(kù)的程序,那么選擇那些符合 wordpress安裝的表格 . 它們以 "wp_" 或者是 'table_prefix' 開頭，你在你的 'wp-config.php' 文件中詳細(xì)指定過的.
    • 如果你只安裝了 WordPress blog, 在左邊欄中點(diǎn)擊 'Select All'.
  6. 確保SQL 按鈕被選中. (Image#5)
    • SQL 部分
    • 勾選一下方框: Structure, 'Add DROP TABLE', 'Add AUTO_INCREMENT' 和 'Enclose table and field names with backquotes'
  7. DATA部分
      8. thumb|Image#6
    • 這部分之內(nèi)的方框不要勾選，但是要確定在保持"DATA"旁邊的復(fù)選框是選中狀態(tài).
  8. 勾選 'Save as file' 操作, 留下一個(gè)模板名字.
    現(xiàn)在壓縮選中 'None'.
  9. 現(xiàn)在點(diǎn)擊 'Go' ，你應(yīng)該被提示說有個(gè)文件下載，保存這個(gè)文件到你的電腦上. (Image#6)
    根據(jù)數(shù)據(jù)庫(kù)的大小，這會(huì)花去你幾分鐘的時(shí)間.
  10. 下載完成后，查看'zipped' 操作, 點(diǎn)擊 'Go', 下載另外一個(gè)文件.
    如果你想的話，你可以下載每個(gè)文件的壓縮格式的備份。你的選擇.
  11. 現(xiàn)在，你的數(shù)據(jù)庫(kù)已經(jīng)備份完畢.
    12. 記住 – 你沒有備份文件和文件夾 – 如圖片- 但是所有你的文章和評(píng)論現(xiàn)在已經(jīng)是安全的了.

直接使用 MySQL 命令[ ]

phpMyAdmin 不能掌控大的數(shù)據(jù)庫(kù)所以用直接 MySQL 代碼會(huì)有所幫助 will help.

1. 把目錄改成你想儲(chǔ)存臨時(shí)數(shù)據(jù)的地方: 

user@linux:~> cd files/blog

2. 使用 mysqldump 來儲(chǔ)存所有的數(shù)據(jù)庫(kù)表格. 想儲(chǔ)存某個(gè)特定的數(shù)據(jù)庫(kù)表格,在通過(tablename tablename tablename)顯示出來的地方給它們命名, 忽略( ) 中的圓括號(hào). (想獲得幫助信息, 嘗試: man mysqldump.): 

user@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>
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>

| (pipe)之后的bzip2 -c語(yǔ)句意思是備份已經(jīng)被壓縮, > blog.bak.sql.bz2發(fā)送bzip到一個(gè)名字叫做的文件中。 blog.bak.sql.bz2. 和下面兩個(gè)命令做的是同樣的事情： 

mysqldump --add-drop-table -h db01.example.net -u dbocodex -p dbwp > blog.bak.sql
bzip2 blog.bak.sql


使用 MySQL 管理員[ ]

MySQL 管理員是一個(gè)執(zhí)行管理的程序。 操作, 如設(shè)置你的MySQL 服務(wù)器, 監(jiān)測(cè)它的狀態(tài)和表現(xiàn), 開始或者是停止, 管理用戶和連接，執(zhí)行備份，儲(chǔ)存?zhèn)浞莸鹊纫幌盗衅渌芾砣蝿?wù)。你可以使用命令行界面執(zhí)行這些任務(wù)中的大多數(shù)。如由mysqladmin 或者 mysql提供的, 但是MySQL 管理員在下面這些方面更具有優(yōu)勢(shì)：

  • 圖形用戶界面讓它更容易使用
  • 它提供了更好的對(duì)你的MySQL服務(wù)器的界面，可靠性和安全性至關(guān)緊要的設(shè)置總覽。
  • 它顯示性能指示器是圖形化的，這更容易決定和調(diào)整服務(wù)器設(shè)置。
  • Linux, Windows and MacOS X都可以使用, 允許遠(yuǎn)程客戶端備份數(shù)據(jù)庫(kù)交叉平臺(tái). 只要你進(jìn)入了遠(yuǎn)程MySQL 數(shù)據(jù)庫(kù), 你就可以備份你的數(shù)據(jù)到任何具有寫入權(quán)限的地方。
  • 對(duì)備份數(shù)據(jù)庫(kù)的大小沒有限制，因?yàn)橛衟hpMyAdmin.

MySQL Administrator 是為MySQL servers 版本 4.0 及以上設(shè)計(jì)使用的。

使用MySQL 管理[ ]

MySQL 管理可以從the MySQL.Com site下載. 安裝文件也可以從這里找到.

備份數(shù)據(jù)庫(kù)[ ]

這里假設(shè)你已經(jīng)安裝了MySQL Admin 并設(shè)置好，這樣你就可以本地或者遠(yuǎn)程登陸MySQL Database Server. 查閱安裝說明中的MySQL Admin安裝包文件。

1. 打開MySQL Admin 客戶端登陸.

2. 從程序窗口左邊的圖像菜單中選擇Backup.

3. 如果你沒有創(chuàng)建一個(gè)Backup 項(xiàng)目, 現(xiàn)在點(diǎn)擊窗口下部的 "New Project" 按鈕，為Backup Project輸入一個(gè)名字.

4. 選擇一個(gè)或者更多你想備份的數(shù)據(jù)庫(kù)(在MySQL Admin 程序中，這些叫做 "Schema" (pl. "Schemata")). 使用指向右邊的箭頭把它們加入到右邊的Backup Content 窗口 。

5. 當(dāng)你選擇了Schema(ta), 你可以保存?zhèn)浞蓓?xiàng)目. 或者你可以簡(jiǎn)單的選擇右下方的Backup Now 按鈕.

6. 一個(gè)對(duì)話框?qū)?huì)產(chǎn)生，詢問你要把備份保存在什么地方。輸入路徑名字或者通過瀏覽保存。

7. 假設(shè)所有步驟都正確 (并且你在寫備份的目錄擁有寫入權(quán)限), 備份會(huì)很快完成.

從備份中恢復(fù)[ ]

1. 打開MySQL Admin 程序登陸.

2. 從圖形界面的程序窗口左手邊選擇 Restore.

3. 點(diǎn)擊右下方的"Open Backup File" 按鈕。

4. 輸入或者瀏覽至 Schema(ta) 備份文件，選擇，點(diǎn)擊"Open".

5. 目標(biāo) Schema(ta) 通常會(huì)在"Original Location", 或者你可以使用下拉菜單選擇一個(gè)替代位置.

6. 點(diǎn)擊右窗口下方 "Start Restore" 按鈕。 數(shù)據(jù)庫(kù)恢復(fù)開始

使用WordPress 數(shù)據(jù)庫(kù)備份插件[ ]

Austin Matzko 維持了一個(gè) WordPress 插件 ，最初是Skippy創(chuàng)建的，叫做 called WordPress 數(shù)據(jù)庫(kù)備份. 它與WordPress 2.0綁定，但是現(xiàn)在不包括在WordPress 2.1中了。

安裝插件[ ]

  1. 如果你下載了這個(gè)插件，按照wp-db-backup.txt 文件中的說明正確安裝插件.

激活插件[ ]

  1. 確定wp-content 文件夾是通過你的服務(wù)器 可寫入的 (更改 CHMOD)
  2. 進(jìn)入Administration > Plugins > Plugins Panel 激活插件。

備份[ ]

  1. 進(jìn)入Administration > Manage > Backup Panel
  2. 選擇任何表格, 除了核心WordPress表格, 都應(yīng)該被備份. 選擇備份Backup操作; 備份會(huì)被保存到服務(wù)器上，下載或者被郵寄. 最后, 點(diǎn)擊Backup按鈕來執(zhí)行備份。如果你安裝了WP-Cron 插件, 你可以設(shè)置每日備份.

恢復(fù)數(shù)據(jù)[ ]

創(chuàng)建的文件是標(biāo)準(zhǔn)的 SQL 文件. 如果你想知道如何上傳文件，參見從備份中恢復(fù)數(shù)據(jù).

使用 CocoaMySQL[ ]

CocoaMySQL是一個(gè)免費(fèi)的基于Mac OS X的 MySQL 客戶端.

從CocoaMySQL 打開你的數(shù)據(jù)庫(kù)選擇File → Export → MySQL file…, 查看如下操作:

  • Add drop table
  • Add create table
  • Add table content

WordPress:Image:cocoamysql_export_dialog.png

資源和備份插件[ ]