Jigar Kahar

Database Backup Manager is a professional WordPress plugin that gives administrators full control over database backups — all from the comfort of the WordPress admin panel.
<h4>Core Features</h4>
<ul>
<li>Dashboard — at-a-glance database statistics: total tables, database size, last backup date and type.</li>
<li>Full Database Backup — export your entire database as SQL or ZIP with a single click.</li>
<li>Selected Tables Backup — check individual tables from a searchable, sortable list and export only what you need.</li>
<li>SQL & ZIP Export — choose between a plain <code>.sql</code> file or a compressed <code>.zip</code> archive.</li>
<li>Backup History — every backup is logged with filename, date, type, format and file size. Re-download or delete from the History screen.</li>
<li>Scheduled Backups — use the built-in WordPress Cron integration to schedule automatic full backups: daily, weekly, or monthly.</li>
<li>Backup Retention — automatically prune old backups to stay within a configurable limit.</li>
<li>Security first — nonce verification, <code>manage_options</code> capability checks, input sanitisation, output escaping, and a protected backup directory on every request.</li>
</ul>
<h4>Planned Features (v2.1+)</h4>
<ul>
<li>Cloud storage integration (Google Drive, Dropbox, OneDrive)</li>
<li>One-click restore from SQL or ZIP backup</li>
<li>Email notifications for successful / failed backups</li>
</ul>

Database Backup Manager


⭐ One Click Database Downloader — Excellent!Super easy to use and works flawlessly. With just one click, it lets you download your database instantly — no hosting panel or manual export needed. A very handy tool for developers and site admins. Highly recommended!


One Click Database Downloader

A secure, lightweight WordPress database backup manager with full or selective table backups, SQL/ZIP export, backup history, and scheduled backups.

it2911

TiDB is a high-performance database that is compatible with the MySQL protocol. Since MySQL has deprecated the SQL_CALC_FOUND_ROWS function, TiDB also has no intention of offering the SQL_CALC_FOUND_ROWS function. This leads to an error in WordPress when using TiDB, indicating that SQL_CALC_FOUND_ROWS is not supported, and submissions cannot be displayed correctly.
WordPress is also currently working on this issue, but it seems that more time is needed. #47280 Remove usage of deprecated MySQL SQL_CALC_FOUND_ROWS from WP_Query
This plugin solves the issue of TiDB not providing the SQL_CALC_FOUND_ROWS function. Once this plugin is activated, parts of WP_Query that use SQL_CALC_FOUND_ROWS will be replaced with the COUNT(*) function.
This plugin is entirely based on the method mentioned by @akramipro in the article, and this solution works perfectly and addresses the issue. I’ve turned this method into a plugin so that those using TiDB can easily resolve this problem. Many thanks to @akramipro for the excellent work, and I hope the official WordPress team can address this issue sooner.
<h3>Contribute</h3>
Contribute to this plugin on <a href="https://github.com/pingcap/wordpress-tidb-plugin" rel="nofollow ugc">github.com/pingcap/wordpress-tidb-plugin</a>

TiDB Compatibility


This plugin is a must-have if you are running TiDB as the database instead of MySQL/MariaDB.


Must have for TiDB users

This plugin is an official tool provided by PingCAP, designed to solve compatibility issues between TiDB and WordPress.

Database Backup Manager vs TiDB Compatibility