Title: ABCode Database Exporter
Author: Ash Brentnall | ABCode
Published: <strong>2026 年 7 月 30 日</strong>
Last modified: 2026 年 8 月 5 日

---

搜索插件

![](https://ps.w.org/abcode-database-exporter/assets/banner-772x250.png?rev=3635220)

![](https://ps.w.org/abcode-database-exporter/assets/icon-256x256.png?rev=3635220)

# ABCode Database Exporter

 作者：[Ash Brentnall | ABCode](https://profiles.wordpress.org/ashbrentnall/)

[下载](https://downloads.wordpress.org/plugin/abcode-database-exporter.1.0.1.zip)

 * [详情](https://cn.wordpress.org/plugins/abcode-database-exporter/#description)
 * [评价](https://cn.wordpress.org/plugins/abcode-database-exporter/#reviews)
 *  [安装](https://cn.wordpress.org/plugins/abcode-database-exporter/#installation)
 * [开发进展](https://cn.wordpress.org/plugins/abcode-database-exporter/#developers)

 [支持](https://wordpress.org/support/plugin/abcode-database-exporter/)

## 描述

**ABCode Database Exporter** is a one-click database export and backup tool for 
WordPress. Export your entire WordPress database, or just the tables you select,
as a .sql file straight from your admin dashboard. No phpMyAdmin, no SSH, no hosting
control panel, no technical knowledge required.

Just open the tool, pick the tables you need, and hit export. Your SQL backup downloads
automatically, ready to import anywhere with phpMyAdmin, WP-CLI, MySQL Workbench,
or Adminer.

#### Why ABCode Database Exporter?

Most database export plugins are bloated, confusing, or require paid upgrades for
basic features. ABCode Database Exporter is different:

 * **Zero configuration:** install, activate, export. That’s it.
 * **No settings page:** there’s nothing to configure. It just works.
 * **Free forever:** no premium tier, no feature locks, no upsells.
 * **Lightweight:** a single PHP file with zero external dependencies.
 * **Fast:** chunked AJAX exports handle databases of any size without timeouts.

#### Features

 * **Full database export:** export all tables (or just the ones you select) as 
   a single .sql file
 * **Individual table export:** download any single table as .sql or .csv
 * **Gzip compression:** optionally compress exports as .sql.gz for smaller downloads
 * **Schema copy:** copy any table’s CREATE TABLE statement to your clipboard with
   one click
 * **Table search & filter:** quickly find tables in large databases
 * **Select / deselect tables:** choose exactly which tables to include in your 
   export
 * **Progress tracking:** a real-time progress bar shows which table is being exported
 * **Binary-safe:** BLOB and BINARY columns are dumped as hex literals so they re-
   import intact
 * **phpMyAdmin compatible:** exports use the same SQL format as phpMyAdmin, so 
   you can import them anywhere
 * **Last export timestamp:** see when you last ran an export at a glance
 * **Auto-cleanup:** temporary files are automatically deleted after one hour
 * **Secure:** nonce verification, capability checks, per-user export sessions, 
   and protected temp directories
 * **Translation ready:** fully internationalised with 5 languages included (Spanish,
   French, German, Italian, Portuguese)

#### Who is this for?

 * **Site owners** who want a quick database backup before updating WordPress, themes,
   or plugins
 * **Developers** who need to pull a database from a staging or production site
 * **Freelancers** who want to hand clients a simple backup tool
 * **Anyone** who finds phpMyAdmin intimidating or doesn’t have hosting panel access

#### How it works

 1. Go to **Tools  Database Exporter**
 2. Select the tables you want to export (all are selected by default)
 3. Click **Export** and watch the real-time progress bar
 4. Choose your download format: **.sql** or **.sql.gz**
 5. Click **Download** and your database backup saves to your computer

That’s it. No configuration, no accounts, no API keys.

## 屏幕截图

[⌊The main export screen showing database stats, table search, and one-click table
selection⌉⌊The main export screen showing database stats, table search, and one-
click table selection⌉[

The main export screen showing database stats, table search, and one-click table
selection

[⌊Export in progress with real-time progress bar⌉⌊Export in progress with real-time
progress bar⌉[

Export in progress with real-time progress bar

[⌊Individual table actions: export as SQL, download as CSV, or copy the schema⌉⌊
Individual table actions: export as SQL, download as CSV, or copy the schema⌉[

Individual table actions: export as SQL, download as CSV, or copy the schema

[⌊Plugin action link on the Plugins screen for quick access⌉⌊Plugin action link 
on the Plugins screen for quick access⌉[

Plugin action link on the Plugins screen for quick access

## 安装

 1. Upload the `abcode-database-exporter` folder to `/wp-content/plugins/`
 2. Activate the plugin through the **Plugins** menu in WordPress
 3. Go to **Tools  Database Exporter** (or click **Export Database** on the Plugins
    screen)

## 常见问题

### Does this plugin require any configuration?

No. Install it, activate it, and it’s ready to use. There are no settings to configure.

### Can I export individual tables?

Yes. Each table has its own SQL, CSV, and Schema buttons. You can also select specific
tables for a combined export.

### What format are the exports in?

Standard SQL format, fully compatible with phpMyAdmin, MySQL Workbench, Adminer,
and any MySQL import tool. You can also export individual tables as CSV.

### Can I compress the export file?

Yes. Select the .sql.gz format before exporting to get a gzip-compressed file. This
requires the PHP gzip extension (available on most hosts).

### Will this work with large databases?

Yes. The export runs table-by-table via AJAX requests, so it won’t hit PHP timeout
or memory limits, even on shared hosting with strict resource caps.

### Is this plugin secure?

Yes. All AJAX requests use WordPress nonce verification, only administrators can
access the tool, each export is bound to the user who created it, temporary files
are stored in a protected directory with random, unguessable filenames, and all 
files are automatically cleaned up after one hour.

### Does it work on multisite?

Yes, but only Network Administrators can run exports. A WordPress multisite installation
shares one database across every site in the network, so restricting the tool to
super admins prevents a single-site administrator from downloading other sites’ 
data.

### Does it work with custom database tables?

Yes. It exports every table in the WordPress database, including those created by
other plugins or custom code.

### Can I use this for site migration?

This plugin exports the database only. For a full migration (files + database), 
pair it with a file manager or FTP. The exported .sql file can be imported on the
destination server via phpMyAdmin, WP-CLI, or any MySQL import tool.

### Where does the exported file go?

It downloads directly to your computer via your browser, the same as any other file
download. Temporary files on the server are automatically deleted.

## 评价

此插件暂无评价。

## 贡献者及开发者

「ABCode Database Exporter」是开源软件。 以下人员对此插件做出了贡献。

贡献者

 *   [ Ash Brentnall | ABCode ](https://profiles.wordpress.org/ashbrentnall/)
 *   [ ABCode ](https://profiles.wordpress.org/abcodeuk/)

「ABCode Database Exporter」插件已被翻译至 1 种本地化语言。 感谢[所有译者](https://translate.wordpress.org/projects/wp-plugins/abcode-database-exporter/contributors)
为本插件所做的贡献。

[帮助将「ABCode Database Exporter」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/abcode-database-exporter)

### 对开发感兴趣吗?

您可以[浏览代码](https://plugins.trac.wordpress.org/browser/abcode-database-exporter/)，
查看[SVN仓库](https://plugins.svn.wordpress.org/abcode-database-exporter/)，或通过
[RSS](https://plugins.trac.wordpress.org/log/abcode-database-exporter/?limit=100&mode=stop_on_copy&format=rss)
订阅[开发日志](https://plugins.trac.wordpress.org/log/abcode-database-exporter/)。

## 更新日志

#### 1.0.1

 * Housekeeping release. No change to how the plugin works.
 * Removed the manual translation loading call. WordPress has resolved language 
   packs automatically since 4.6, and Plugin Check flags the call as discouraged.
 * Tidied punctuation in the code comments.

#### 1.0.0

 * Initial release
 * Full database export with table selection
 * Individual table export as SQL or CSV
 * Schema copy to clipboard
 * Gzip compression support (.sql.gz)
 * Table search and filter
 * Real-time export progress tracking
 * phpMyAdmin-compatible SQL output
 * Binary-safe dumps for BLOB and BINARY columns
 * Auto-cleanup of temporary files
 * Translations: Spanish, French, German, Italian, Portuguese (Brazil)

## 额外信息

 *  版本 **1.0.1**
 *  最后更新：**5 天前**
 *  活跃安装数量 **不到10**
 *  WordPress 版本 ** 5.0 或更高版本 **
 *  已测试的最高版本为 **7.0.3**
 *  PHP 版本 ** 7.4 或更高版本 **
 *  语言
 * [English (US)](https://wordpress.org/plugins/abcode-database-exporter/) 和 [Spanish (Spain)](https://es.wordpress.org/plugins/abcode-database-exporter/).
 *  [翻译成简体中文](https://translate.wordpress.org/projects/wp-plugins/abcode-database-exporter)
 * 标签
 * [backup](https://cn.wordpress.org/plugins/tags/backup/)[database](https://cn.wordpress.org/plugins/tags/database/)
   [database backup](https://cn.wordpress.org/plugins/tags/database-backup/)[database export](https://cn.wordpress.org/plugins/tags/database-export/)
   [export](https://cn.wordpress.org/plugins/tags/export/)
 *  [高级视图](https://cn.wordpress.org/plugins/abcode-database-exporter/advanced/)

## 评级

尚未提交反馈。

[Your review](https://wordpress.org/support/plugin/abcode-database-exporter/reviews/#new-post)

[查看全部评论](https://wordpress.org/support/plugin/abcode-database-exporter/reviews/)

## 贡献者

 *   [ Ash Brentnall | ABCode ](https://profiles.wordpress.org/ashbrentnall/)
 *   [ ABCode ](https://profiles.wordpress.org/abcodeuk/)

## 支持

有话要说吗？是否需要帮助？

 [查看支持论坛](https://wordpress.org/support/plugin/abcode-database-exporter/)

## 捐助

您愿意支持这个插件的发展吗?

 [ 捐助此插件 ](https://abcode.co.uk)