Title: Database Export Genie
Author: mansoormunib
Published: 2026 年 10 月 19 日
Last modified: 2026 年 10 月 21 日
---
搜尋外掛
# Database Export Genie
由 [mansoormunib](https://profiles.wordpress.org/mansoormunib/) 開發
[下載](https://downloads.wordpress.org/plugin/database-export-genie.3.0.1.zip)
* [詳細資料](https://tw.wordpress.org/plugins/database-export-genie/#description)
* [使用者評論](https://tw.wordpress.org/plugins/database-export-genie/#reviews)
* [安裝方式](https://tw.wordpress.org/plugins/database-export-genie/#installation)
* [開發資訊](https://tw.wordpress.org/plugins/database-export-genie/#developers)
[技術支援](https://wordpress.org/support/plugin/database-export-genie/)
## 外掛說明
* One page, one button, a list of your backups.
* Runs in the background: leave the page or close the tab and the backup keeps
going.
* Works on shared hosting: no mysqldump, no exec(), handles short timeouts and
low memory limits.
* Checks disk space before starting, and stops cleanly if the disk fills.
* Every backup is verified before it’s shown as ready: the zip is re-read and every
compressed chunk is checked against the SQL that was written.
* Download or delete backups at any time. Delete the whole backup folder in one
click.
* Standard .sql inside. Restore with phpMyAdmin, Adminer, the mysql command or
WP-CLI. No paywall, no Pro version.
* Works with MySQL, MariaDB, Percona, Amazon Aurora, SQLite (WordPress Playground/
SQLite Database Integration) and HyperDB / LudicrousDB setups.
* Multisite: back up the whole network, or one site (optionally with its users,
optionally renamed for a standalone install).
* No emails, no upsells, no tracking. The only outbound request is to your own
site (to keep the backup running in the background).
**Advanced options** (hidden behind one checkbox): a custom backup name, and a table
picker so you can export a few tables, or just one.
#### What’s included
Every table that starts with your WordPress table prefix. Nothing inside those tables
is skipped, including transients and options that start with an underscore. The
one exception is this plugin’s own progress data (`dbmg_*` rows in the options table),
which would be meaningless after a restore. Tables from other applications that
share the database are listed under “Other tables” in Advanced options and are only
exported if you tick them.
#### WP-CLI
* `wp dbmg create [--description=] [--tables=] [--site=] [--include-
users] [--convert-prefix] [--run]`
* `wp dbmg run` — finish the running backup in this process (useful on hosts that
block background requests, or from a system cron).
* `wp dbmg status`, `wp dbmg list`, `wp dbmg delete ...`, `wp dbmg cancel`
### Future ideas
Not planned for now, listed here so they don’t creep in: restore from the dashboard,
file backups, schedules, cloud destinations, email notifications.
### Credits
The SQL export engine follows the design of WP Migrate Lite’s table exporter (GPLv2
or later): keyset pagination over primary and compound keys, hex-encoded binary
columns and multi-row INSERT buffering. This plugin is not affiliated with or endorsed
by its authors.
The genie icon is based on the genie from Noto Emoji, copyright Google LLC, used
under the Apache License 2.0 (head and turban redrawn) (https://www.apache.org/licenses/
LICENSE-2.0, source: https://github.com/googlefonts/noto-emoji).
## 螢幕擷圖
[⌊The backup list: one button, one table.⌉⌊The backup list: one button, one table
.⌉[
The backup list: one button, one table.
[⌊A backup in progress, with a progress bar for every table.⌉⌊A backup in progress,
with a progress bar for every table.⌉[
A backup in progress, with a progress bar for every table.
[⌊Create a backup: disk-space check and the optional table picker.⌉⌊Create a backup:
disk-space check and the optional table picker.⌉[
Create a backup: disk-space check and the optional table picker.
## 安裝方式
1. Upload the `database-export-genie` folder to `/wp-content/plugins/`, or install
it from the Plugins screen.
2. Activate it (Network Activate on multisite).
3. Go to **Tools Database Backups** (multisite: **Network Admin Settings Database
Backups**) and click **Create backup**.
## 常見問題集
### Who can create, download and delete backups?
Only users with the Administrator role (on multisite: Super Admins). Other roles
never see the page, even if a role editor gave them the “manage_options” capability,
because a database backup contains every password hash and secret key on the site.
WP-CLI commands work for anyone with shell access to the server.
### How do I restore a backup?
Unzip it. Inside you’ll find `database.sql` (or `database.part-001.sql`, `database.
part-002.sql`, … for large sites) and `IMPORT-README.txt`, which explains each option:
* phpMyAdmin or Adminer: Import choose the file (import parts in numeric order).
* Command line: `mysql -u USER -p DBNAME < database.sql`
* WP-CLI: `wp db import database.sql`
Multiple parts can be joined first: `cat database.part-*.sql > database.sql` (Windows:`
copy /b database.part-*.sql database.sql`). Moving to a new domain? Run a serialized-
safe search-replace after importing, for example `wp search-replace 'https://old.
example' 'https://new.example' --all-tables`.
### Where are backups stored? Can anyone download them?
In `wp-content/dbmg-backups-/` (or the uploads folder if wp-content isn’t
writable). Only administrators can download a backup, through wp-admin with a login
and a per-link security check; the zip’s own URL is never shown. The folder is blocked
from the web in several independent ways, and each one fails closed:
* `.htaccess` denies every request on Apache 2.2 and 2.4 and LiteSpeed, plus a
rewrite rule for OpenLiteSpeed. If the host doesn’t allow a directive, Apache
answers 500 for the folder, which still serves nothing.
* `web.config` blocks every file on IIS (request filtering).
* An empty `index.html` stops folder listings on any server.
* Backup files are owner-only (0600). Where the web server runs as a different
user than PHP (most control panels and managed Nginx hosts), it can’t read them
even without a rule.
* The folder name and every file name contain long random tokens (more than 150
bits together).
The plugin checks all of this from the outside: it puts a test `.zip`, `.sql` and`.
json` file in the folder and requests them over HTTP. If any of them comes back,
the Storage section and Tools Site Health show a warning with the exact fix for
your server.
The safest setup stores backups outside the web root. Add this to `wp-config.php`(
the plugin suggests a path when it finds one):
```
define( 'DBMG_BACKUP_DIR', '/home/you/private/db-backups' );
```
### I use Nginx. What should I add?
Nginx ignores `.htaccess`. Add this to your server block and reload Nginx (the plugin
shows the same snippet with your real path if it finds the folder public):
```
location ^~ /wp-content/dbmg-backups- { deny all; }
```
Use `^~` as shown, not a regular-expression location: Nginx uses the first regex
location that matches, so an earlier rule such as `location ~* \.(zip|gz)$` would
win over a regex deny.
If you use the `dbmg_download_xsendfile` filter (X-Accel-Redirect / X-Sendfile),
the web server itself reads the zip, so also return a mode it can read from the `
dbmg_file_mode` filter, for example `0640`.
### Does the backup really keep running if I close the tab?
Yes, on most servers: the backup runs in short server-side steps that start each
other. If your host blocks that, WP-Cron takes over; if WP-Cron is also disabled,
the backup advances whenever any WordPress admin page is open (the plugin tells
you before you start). You can always finish it with `wp dbmg run`.
### Is the backup a point-in-time snapshot?
Small sites (under about 20 MB of SQL on MySQL/MariaDB) are exported inside a single
consistent snapshot when the whole export finishes in one step, which is the usual
case. Larger backups are exported in chunks while the site stays live, so rows written
during the backup may or may not be included — the same trade-off every PHP-based
backup plugin makes. `backup-info.json` inside the zip says which kind you got.
For a frozen copy of a busy store, put the site in maintenance mode first.
### My host has a 30 second time limit and 64 MB of memory. Will it work?
That’s what it’s built for. Each step uses at most 40% of `max_execution_time` (
never more than 20 seconds), stops at 70% of the memory limit, and resizes its batches
automatically. If a step is killed anyway, the next one resumes from the last saved
point and throws away any half-written data.
### What happens when I uninstall the plugin?
All of its settings are removed. Your backups are kept, unless you ticked “Also
delete all backups when the plugin is uninstalled” in the Storage section — deleting
someone’s only backup silently would be worse than leaving files behind. If you
install the plugin again later, it finds the backups it left behind and lists them
again. Deactivating the plugin cancels a running backup and keeps finished ones.
### Which databases are not supported?
PostgreSQL (PG4WP), SQL Server and other non-MySQL servers. The page tells you if
it detects one.
## 使用者評論
這個外掛目前沒有任何使用者評論。
## 參與者及開發者
以下人員參與了開源軟體〈Database Export Genie〉的開發相關工作。
參與者
* [ mansoormunib ](https://profiles.wordpress.org/mansoormunib/)
[將〈Database Export Genie〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/database-export-genie)
### 對開發相關資訊感興趣？
任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/database-export-genie/)、
查看 [SVN 存放庫](https://plugins.svn.wordpress.org/database-export-genie/)，或透過
[RSS](https://plugins.trac.wordpress.org/log/database-export-genie/?limit=100&mode=stop_on_copy&format=rss)
訂閱[開發記錄](https://plugins.trac.wordpress.org/log/database-export-genie/)。
## 變更記錄
#### 3.0.1
* New plugin directory banner and icon. No code changes.
#### 3.0.0
* First release.
## 中繼資料
* 版本 **3.0.1**
* 最後更新 **1 週前**
* 啟用安裝數 **少於 10 次**
* WordPress 版本需求 ** 6.2 或更新版本 **
* 已測試相容的 WordPress 版本 **7.1.3**
* PHP 版本需求 ** 7.4 或更新版本 **
* 語言
* [English (US)](https://wordpress.org/plugins/database-export-genie/)
* 標籤:
* [backup](https://tw.wordpress.org/plugins/tags/backup/)[database backup](https://tw.wordpress.org/plugins/tags/database-backup/)
[Export database](https://tw.wordpress.org/plugins/tags/export-database/)[sql](https://tw.wordpress.org/plugins/tags/sql/)
[zip](https://tw.wordpress.org/plugins/tags/zip/)
* [進階檢視](https://tw.wordpress.org/plugins/database-export-genie/advanced/)
## 評分
這個項目尚無任何評論記錄。
[撰寫評分](https://wordpress.org/support/plugin/database-export-genie/reviews/#new-post)
[查看全部使用者評論](https://wordpress.org/support/plugin/database-export-genie/reviews/)
## 參與者
* [ mansoormunib ](https://profiles.wordpress.org/mansoormunib/)
## 技術支援
使用者可在技術支援論壇提出意見反應或使用問題。
[檢視技術支援論壇](https://wordpress.org/support/plugin/database-export-genie/)