Damien Saunders

<p>DBC Backup 2 can give you the confidence that your WordPress database is backed-up and securely stored on your server.</p>
<p>You select when and where your backup will be generated. The backup file is saved to directory on your web server which for many people is free storage and more reliable then saving to your home computer.</p>
<h4>Key Features</h4>
<ul>
<li>Secure – The file name includes some random characters which makes it impossible for someone to guess the backup name and download it.</li>
<li>Safe – the backup directory is protected with a .htaccess and an empty index.html file which means no-one can browse or download the file via the web</li>
<li>Storage – If your server has supports it, you can select between three different compression formats: none, Gzip and Bzip2. </li>
<li>Schedule – you can set hourly, daily, weekly or monthly backup</li>
<li>Manual backup – anytime you want to save a backup before updating WordPress or installing a plugin you can.</li>
</ul>
<h4>Additional Info</h4>
<p>The plugin will try to auto create the export directory.</p>
<p>This plugin creates it’s own sql file and does not use mysqldump like most other plugins.</p>
<p>During backup, a log is created that includes, the generation date, file, filesize, status and the duration of the generation.</p>
<p>The backup files are identical to what phpmyadmin would produce because DBC Backup is using the key procedures of phpmyadmin.</p>
<p>DBC Backup was built to be fast, flexible and as simple as possible.</p>
<h4>Checkout my other work</h4>
<h3>CHANGE YOUR WEBSITE NOT YOUR THEME == responsive visual grid layout with Isotope.js & visual animation. [Free to download](http://wordpress.damien.co/shop/isotope/?utm_source=WordPress&utm_medium=dbc-backup&utm_campaign=WordPress-Plugin&utm_keyword=readme)</h3>
<ul>
<li><a href="http://damien.co/blog?utm_source=WordPress&utm_medium=dbc-backup&utm_campaign=WordPress-Plugin&utm_keyword=readme" rel="nofollow ugc">Damien</a> – digital marketing strategy, technical development and digital marketing</li>
<li><a href="http://wordpress.damien.co/?utm_source=WordPress&utm_medium=dbc-backup&utm_campaign=WordPress-Plugin&utm_keyword=readme" rel="nofollow ugc">Ideas for WordPress</a></li>
<li><a href="http://wordpress.damien.co/plugins?utm_source=WordPress&utm_medium=dbc-backup&utm_campaign=WordPress-Plugin&utm_keyword=readme" rel="nofollow ugc">Plugins for WordPress</a></li>
</ul>


DBC Backup 2

DBC Backup 2 is a safe & simple way to schedule regular WordPress database backups using the wp-cron batch jobs.

it2911

<p>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.</p>
<p>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</p>
<p>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.</p>
<p>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.</p>
<h3>Contribute</h3>
<p>Contribute to this plugin on <a href="https://github.com/pingcap/wordpress-tidb-plugin" rel="nofollow ugc">github.com/pingcap/wordpress-tidb-plugin</a></p>


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.

DBC Backup 2 vs TiDB Compatibility