Take Complete Control of Your WordPress Database

Manage your database effortlessly without touching phpMyAdmin or writing a single SQL query. WP Database Manager & Backup Pro gives you a powerful, beautifully designed admin dashboard that displays everything about your database in real time — including table sizes, row counts, engine types, and database growth trends over time.

Whether you're a developer managing multiple client websites or a site owner looking for peace of mind, this plugin provides all the tools you need to monitor, clean, optimize, and back up your database with just one click — directly inside the familiar WordPress admin panel.

No coding required. No external services. No monthly fees. Simply install, activate, and take full control of your database instantly.

Database Overview

• Live dashboard showing total database size, table count, largest table, most records, MySQL/MariaDB version, and WordPress version.
• Full table list with rows, data size, index size, total size, and a visual size bar showing each table's share of the total.
• Largest and Most Rows badges automatically highlight important tables.
• Engine type shown per table (InnoDB, MyISAM, etc.).
• Live table search instantly filters 100+ tables by name with a single keystroke.

Export & Backup

• One-click full database export as a .sql file that downloads directly to your browser.
• Export selected tables only and choose exactly which tables to include in the export.
• Scheduled automatic backups with daily or weekly backup options powered by WP-Cron.
• Backup files securely stored in wp-content/uploads/dbi-backups/ with .htaccess protection.
• Optional email delivery sends every backup as an attachment.
• Backup history includes file size, date, download, and delete options for every backup file.
• Automatically keeps the latest 10 backups while pruning older files to save disk space.
• Uses mysqldump when available (including XAMPP compatibility) and falls back to a pure PHP export method.

Optimize & Repair

• Optimize any single table with one click to reclaim wasted space after bulk deletes.
• Repair any single table to fix corrupted table issues after crashes.
• Bulk Optimize All and Repair All actions available for full-site maintenance.
• Success and error notices displayed after every action.

Orphaned Tables Detector

• Automatically detects database tables left behind by uninstalled plugins.
• Displays a dedicated list of orphaned tables with a safe drop option.
• Helps keep your database lean and reduces unnecessary storage usage.

Truncate / Drop Table

• Safely truncate any table to delete all rows while keeping the table structure intact.
• Permanently drop any table from the admin panel with a double-confirm safety prompt.
• Dropdown-based table selection helps prevent accidental actions.

Size History Chart

• Daily database size automatically logged using WP-Cron.
• Beautiful Chart.js line graph displays database growth over the last 30 days.
• Raw size history logs include date-by-date KB values.
• Helps identify sudden database growth spikes caused by runaway plugins or excessive logs.

WordPress Dashboard Widget

• Compact summary widget displayed directly on the main WordPress dashboard.
• Shows total database size, table count, largest table, most rows, MySQL version, and database name at a glance.
• Includes a direct link to the full DB Info panel for deeper management and monitoring.

• - WordPress 5.0 or higher

• - PHP 7.4 or higher
• - MySQL 5.6+ or MariaDB 10.1+
• - Administrator access (`manage_options` capability)
• - WP-Cron enabled (required for scheduled backups and size history logging)
• - `shell_exec` enabled (optional — used for `mysqldump`; plugin falls back to PHP export if unavailable)

Installation

1. Download the plugin .zip file.
2. In your WordPress admin, go to Plugins → Add New → Upload Plugin.
3. Upload the zip file and click Install Now.
4. Click Activate Plugin.
5. A new DB Info item will appear in your WordPress admin sidebar.

Viewing Database Stats

1. Click DB Info in the sidebar.
2. The Overview tab loads instantly with live database stats and the full table list.
3. Use the search box to filter tables by name in real time.
4. Click the optimize (blue) or repair (green) icon on any row to run maintenance on that table.
5. Use Optimize All or Repair All buttons in the header to run bulk maintenance.

Exporting the Database

Full Export

Click the Export Full DB button in the header. Your browser will download a .sql file named db-export-{dbname}-{date}.sql.

Partial Export (Selected Tables)

1. Go to the Tools tab.
2. Check the tables you want to export.
3. Click Download Selected (.sql).

Re-importing a Backup

<code>mysql -u your_user -p your_database < db-export-yourdb-2026-05-21.sql
</code>

Or use phpMyAdmin → Import and select the .sql file.

Setting Up Scheduled Backups

1. Go to the Backup tab.
2. Toggle Enable Scheduled Backups on.
3. Choose Daily or Weekly.
4. Optionally enter an email address to receive each backup as an attachment.
5. Click Save Settings.
6. Click Run Backup Now to create your first backup immediately.

Backup files are listed below the settings form. Click the download icon to save a copy, or the trash icon to delete a backup file.

Checking for Orphaned Tables

1. Go to the Tools tab.
2. Scroll to the Orphaned Tables section.
3. Any tables not belonging to active WordPress core features or active plugins are listed.
4. Click the trash icon to drop an orphaned table and confirm the prompt.

Truncating or Dropping a Table

1. Go to the Tools tab.
2. Scroll to Truncate / Drop Table.
3. Select a table from the dropdown.
4. Choose Truncate (removes rows, keeps structure) or Drop (permanently deletes the table).
5. Click Execute Action and confirm the double-prompt.

⚠️ Warning: Truncate and Drop actions are irreversible. Always take a backup first.

Viewing Size History

1. Go to the Size History tab.
2. A line chart shows your database size over the last 30 days.
3. The chart populates daily — after the first 24 hours you will see your first data point.
4. The raw log table below the chart shows the exact KB value for each recorded day.