內容簡介
允許您優化資料庫、修復資料庫、備份資料庫、還原資料庫、刪除備份資料庫、刪除/清空資料表和運行選定查詢。支援自動備份、優化和修復資料庫的排程。
一般使用方式
啟用WP-DBManager外掛。
如果您有權限寫入，則腳本將自動在wp-content文件夾中創建一個名為backup-db的文件夾。如未創建，請創建該文件夾並確保它是可寫入的。
打開文件夾：wp-content/backup-db
如果您使用 Apache， 請將wp-content/plugins/wp-dbmanager文件夾中的htaccess.txt文件移至wp-content/backup-db/.htaccess。如果該文件已存在，則不需要移動
如果您使用 IIS，請將wp-content/plugins/wp-dbmanager文件夾中的Web.config.txt文件移至wp-content/backup-db/Web.config。如果該文件已存在，則不需要移動。
如果您使用 Apache 或 IIS，請將wp-content/plugins/wp-dbmanager文件夾中的index.php文件移至wp-content/backup-db/index.php。如果該文件已存在，則不需要移動。
前往WP-Admin>資料庫>DB選項以配置資料庫選項。
建構狀態
開發
https://github.com/lesterchan/wp-dbmanager
翻譯
http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/
鳴謝
Freepik的插件圖示來自Flaticon
捐贈
我大部分的空閒時間都用來創建、更新、維護和支援這些外掛，如果您真的喜歡我的外掛並可以幫助我，我會非常感激。如果您不需要，可以自由使用。
免責聲明
請注意，此外掛會通過mysqldump命令行中的–password傳遞資料庫密碼。這很方便，但是作為一種交換，這是不安全的。
在某些系統上，密碼會在其他使用者調用的系統狀態程式（例如ps）中變得可見。MySQL客戶端通常在初始化序列期間使用零覆蓋命令行密碼參數。但是，在某些系統上，此覆蓋策略是無效的，密碼仍然可見於ps。來源：用戶端密碼安全指南
如果您有擔憂，我建議您使用其他資料庫備份外掛，稱為WP-DB-Backup
欲知WP-DBManager和WP-DB-backup之間的區別，請查看FAQ部分中的"What is the difference between WP-DBManager and WP-DB-Backup?"
外掛標籤
開發者團隊
📦 歷史版本下載
原文外掛簡介
Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.
General Usage
Activate WP-DBManager Plugin
The script will automatically create a folder called backup-db in the wp-content folder if that folder is writable. If it is not created, please create the folder and ensure that the folder is writable
Open Folder: wp-content/backup-db
If you are on Apache, move the htaccess.txt file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/.htaccess if it is not there already
If you are on IIS, move the Web.config.txt file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/Web.config if it is not there already
Move index.php file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/index.php if it is not there already
Go to WP-Admin -> Database -> DB Options to configure the database options
Build Status
Development
https://github.com/lesterchan/wp-dbmanager
Translations
http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/
Credits
Plugin icon by Freepik from Flaticon
Donations
I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks, I will really appreciate it. If not feel free to use it without any obligations.
Disclaimer
Note that this plugin passes your datababase password via –password in the command line of mysqldump. This is convenient but as a trade off, it is insecure.
On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. However, there is still a brief interval during which the value is visible. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps. Source: End-User Guidelines for Password Security
If this is a concern to you, I recommend another database backup plugin called WP-DB-Backup
To know about the difference between WP-DBManager and WP-DB-backup, checkout What is the difference between WP-DBManager and WP-DB-Backup? in the FAQ section.
