ABCode Database Exporter

Description

ABCode Database Exporter is a one-click database backup and export 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 — 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 — your database backup saves to your computer

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

Screenshots

Installation

  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)

FAQ

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.

Reviews

There are no reviews for this plugin.

Contributors & Developers

“ABCode Database Exporter” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

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)