<p>Just place some SQL on in the box and save it as a report. You can save multiple reports and they will be listed on the Admin Menu so you can quickly run them again anytime with just one click. You can place your reports on the User’s Dashboard based on Roles. You can also put a report on a Page or Post using a shortcode like [SQLREPORT name=”My Report” style=”padding: 6px;” /]</p>
<p>There is also an shortcode for the wpdb::get_var function that you can use to display a single value from your database. For example, this will display the number of users on your site:<br />
[sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar]<br />
Note: because of a known exploit in the WordPress shortcode functionality it is required that an admin user create an SQL Report with the exact query that will be used in the sqlgetvar shotcode, otherwise any subscriber could white their own shortcode query.</p>
<p>If you want to include an “Export to CSV” button on your page or post then use the additional shortcode [SQLEXPORTCSV] once on any page or post that contains a report you want visitors to be able to download. Thanks to @loristictok and @rob66bnu for posting the suggestion with the JavaScript that I used to make this new Shortcode.<br />
Note: Adding this shortcode to the just one time will insert the “Export to CSV” button at the top of every HTML Table on the page.</p>
<h4>Automatic Database Backups</h4>
<p>Your database can be automatically saved and archived every hour and/or every day, and backups can be emailed to the address you specify. You can also restore the data to your WP DB or an external DB, which makes copying your database to another server and easy task.</p>


EZ SQL Reports Shortcode Widget and DB Backup

Create and save SQL Reports in your WP Admin and place them on pages and posts with a shortcode. Keep your database safe with automatic backups.

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.

EZ SQL Reports Shortcode Widget and DB Backup vs DBC Backup 2