pl4g4

WP-Database-Optimizer helps you to optimize your database by performing some actions for example optimizing tables, deleting revisions and data that can slow that your database. Also 
you can perform backups.
WP Database Optimizer Tools es un plugin el cual ayuda a mejorar el rendimiento de nuestra base de datos, esto es de mucha ayuda cuando sabemos que tenemos muchas visitas y necesitamos aligerar el sitio para un mejor funcionamiento.
Con WP Database Optimizer Tools se puede hacer
<pre><code>Limpiar las revisiones de post
Limpiar los autodraft
Limpiar spam
Limpiar comentarios no aprovados
Limpiar la trash de wordpress
Optimizar las tablas en la base de datos
Reparar las tablas en la base de datos
Se puede hacer un backup de la base de datos ( mas adelante pondra opcion para enviar por email el backup)
</code></pre>
<h3>Usage</h3>
<ol>
<li>Click the DB optmizer menu in your WordPress admin area.</li>
<li>Select any option to perform to your database</li>
<li>
To backup your database select DB Backup, select the tables you want to backup and download the SQL file.
*** SECURITY WARNING *** 
Your database backup contains sensitive information, 
and should not be left on the server for any extended 
period of time. The “Save to server” delivery method is provided 
as a convenience only. I will not accept any responsibility 
if other people obtain your backup file. 
*** SECURITY WARNING ***
</li>
</ol>
<h3>Past Contributors</h3>
None

WP-Database-Optimizer-Tools

WP-Database-Optimizer helps you to optimize your database by performing some actions for example optimizing tables, deleting revisions and data that c …

Peter Lawrenson

ryo0inoue

Simple Table Manager enables editing table records and exporting them to CSV files through a minimal database interface from your dashboard.
<ul>
<li>Simply CRUD table contents on your wp-admin screen</li>
<li>Search and sort table records</li>
<li>No knowledge of MySQL or PHP required</li>
<li>Export table records to a CSV file</li>
<li>Does not allow users to create tables or change the structure of the table</li>
</ul>
Simple Table Manager is a tool suited for the initial development phase of a website. It is ideal when you want to ask someone else with no database expertise to keep track of table records on your website. This was the motivation for developing this plugin.
Note that to comply with wordpress.org plugin security guidelines, edited and added record fields are filtered through wp_kses_post() to prevent sql injection attacks. In some cases, wanted tags may be filtered out leading to field corruption.

Simple Table Manager

As advertised, this plugin is great for a non-techy admin to create and edit data, and I recommended the plugin for this purpose.
I used phpMyAdmin to setup the table and then used the plugin to create the initial set of records. There are no display facilities with the plugin so I a used a bit of custom code. Only 2 lines are needed to fetch the data into a php function:
global $wpdb;
$results = $wpdb->get_results( 'SELECT * FROM wp_mytable', ARRAY_N );
The plugin will allow access to only one table at a time, but its easy to switch between tables.
Thanks for sharing.



Great for non-techy admin to maintain data.

Enables viewing and editing table records and exporting them to CSV files through a minimal database interface from your dashboard.

WP-Database-Optimizer-Tools vs Simple Table Manager