WordPress keeps every single scrap of information that is fed into it in a MySQL database, whether that be posts, pages, comments, blogroll, the plugin settings everything. WordPress MySQL plugins are very useful for your website backhand and database. So, here in this post I have listed 20 must have MySQL plugins for WordPress that are used in your WP web blogs. If you are a developer and you have build the any WordPress plugin then please share with us via comments below. If you like this post, share it with your friends through email and social networks.
1. W3 Total Cache
Easy Web Performance Optimization (WPO) using caching: browser, page, object, database, minify and content delivery network support.
2. ELI’s SQL Admin Reports with Shortcode
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.
HyperDB is a very advanced database class that replaces a few of the WordPress built-in database functions.
4. Search and Replace
A simple search for find strings in your database and replace the string. You can search in ID, post-content, GUID, titel, excerpt, meta-data, comments.
5. myRepono WordPress Backup Plugin
myRepono is an online website backup service which enables you to securely backup your WordPress web site files and mySQL database tables using an online and web-based management system.
6. WordPress EZ Backup
WordPress EZ Backup is A administrators plugin to allow the easiest most feature rich method for creating backup archives of your entire site & database.
7. WP Migrate DB
WP Migrate DB exports your database as a MySQL data dump (much like phpMyAdmin), does a find and replace on URLs and file paths, then allows you to save it to your computer.
Display your host’s PHP, MYSQL & memcached (if installed) information on your WordPress dashboard.
9. MySQL Profiler
MySQL Profiler displays debugging information about SQL queries to admin WordPress users.
10. XData Toolkit
The XData Toolkit is an XML/XSLT transformation engine and Database Toolkit that allows one to retrieve data from multiple datasources such as MySQL databases, XML, RSS Feeds and REST-based Web Services.
11. WP Complete Backup
WP Backup Complete is an easy to use, complete backup solution for WordPress. The plugin offers the ability to backup the database as well as make a complete file system backup.
12. Convert WP Database to UTF-8
This plugin can convert your WordPress database (both tables and columns) to UTF-8 character set.
13. CodeTree Backup
The CodeTree Backup plugin is a simple utility that will backup your themes, plugins and uploads folder as well as a complete copy of the database.
14. WP MySQL Console
WP MySQL Console (WPMC) is a web based MySQL command shell. WPMC aims to be a web shell has same functionalites of real MySQL Shell.
15. Admin Flush W3TC Cache
Admin Flush W3TC Cache works with the W3 Total Cache plugin. It simply adds an “Empty All Caches” option to every Admin page.
16. GD Press Tools
GD Press Tools is a collection of various administration, seo, maintenance, backup and security related tools.
Adds subpages to the Dashboard menu with technical details about PHP, MySQL and other server details an administrator might need.
Presents the results of a database query in a table. The query can be saved as a view which can then be embedded in any post using a shortcode.
19. Edit Any Table
A WordPress plugin/Dashboard Widget that allows you to connect to any database and edit the contents.
20. WP Clean Up
WP Clean Up can help us to clean up the wordpress database by removing “revision” “draft” “auto draft” and so on.
While compiling this list, it’s always a possibility that I missed some other great resources. Feel free to share it with us.
– See more at: http://wpjournals.com/wordpress/mysql-wordpress-plugins/#sthash.381YzQbh.dpuf