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.

Guaven Labs

<p>The plugin can create beautiful charts based on your SQL queries, then you can use those charts in any part of your website.<br />
You can use both native wp and non-wp mysql tables in your queries.</p>
<h3>Pie chart, Donut chart, Line chart, Bar chart, Column chart, Area chart</h3>
<h4>How to use</h4>
<ol>
<li>
<p>Give any name to your report.</p>
</li>
<li>
<p>Use our preinstalled chart or create new one yourself: choose desired chart type, type sql query,<br />
enter field names, labels and then press to Publish/Update</p>
</li>
<li>
<p>You can use multiple SQL queries too. Just split them by ; sign. You can also add shortcode argument to SQL query. For example if you<br />
type “select * from wp_posts where ID>{arg1}” then it you can pass arg1 value to the query with  [gvn_schart_2 id=”2″ arg1=”11″] shortcode.</p>
</li>
<li>
<p>After update/save you will see needed shortcode below there. You can use that shortcode anywhere in your website: in pages, posts, widgets etc.</p>
</li>
<li>
<p>Just check “Show table-view data below the graph” in order to get table-list view below each chart.</p>
</li>
<li>
<p>Using “Dynamic Filters” you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart.</p>
</li>
</ol>
<h4>Dynamic filters</h4>
<p>Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc.</p>
<ul>
<li>variable_name – any single name you want.</li>
<li>default_value – default value when no any variable chosen by a user</li>
<li>variable_label – Label which would be visible at a form above the chart</li>
<li>variable_type – number, text or date</li>
<li>~ is a separator between variable elements.</li>
<li>| is a separator between variables</li>
</ul>
<p>For example if to put</p>
<p>limit_tag~10~Count~number | post_date_tag~2010-07-05 17:25:18~Date Published~date,</p>
<p>then you can use this SQL code</p>
<p>select * from wp_posts where post_date<{post_date_tag} limit {limit_tag}</p>
<p>in SQL CODE field.<br />
{post_date_tag} and {limit_tag} would be replaced with dynamic variables.</p>
<p>So, the plugin will automatically recognize it and put corresponding selectboxes above the chart.</p>
<h4>Website</h4>
<p><a href="https://guaven.com/my-sql-charts/" rel="nofollow ugc">https://guaven.com/my-sql-charts/</a></p>
<h4>Documentation</h4>
<p><a href="https://guaven.com/my-sql-charts/#docs" rel="nofollow ugc">https://guaven.com/my-sql-charts/#docs</a></p>
<h4>Bug Submission and Forum Support</h4>
<p><a href="https://guaven.com/contact/solution-request/" rel="nofollow ugc">Contact Page</a></p>
<h4>Please Vote if you liked our plugin</h4>
<p>Your votes really helps us. Thanks.</p>
<h3>Available Filters</h3>
<p>apply_filters( ‘guaven_sqlcharts_table_empty_cell’);</p>
<p>apply_filters(‘guaven_sqlcharts_pre_print_vars’);</p>
<p>apply_filters( ‘guaven_sqlcharts_final_output’);</p>
<p>apply_filters(‘guaven_sqlcharts_rendered_sql’);</p>


SQL Chart Builder

Unfortunately, this plugin is only useful for very specific use-cases, because it supports ONLY two database fields (i.e. X and Y axis, which almost never makes sense for the supported pie chart type but anyway). The external MySQL connector works well, so that part is great, but the shortcode doesn't output the charts and the "preview" doesn't honor the width and height settings. So, this could have been great, with just a little more love and attention. Ah well.

I had such high hopes :(

Turn Your SQL Queries to Beautiful Dynamic Charts- Pie, Line, Area, Donut, Bar Charts with date/input filters.

DBC Backup 2 vs SQL Chart Builder