WPDB to Sql Plugin
Administrator role user can take dump of the mysql database by single click.
This plugin allows only admin role user to download/take SQL backup of database.
No other role user allow to take a back due to security concern.
this will work like a charm!
I’ll try to keep update this idea and make more enhancement but for that I need your support, so please like,share and support my plugin for further details.
Installation
- Upload
wpdb-sql.php to the /wp-content/plugins/ directory - Activate the plugin through the ‘Plugins’ menu in WordPress
- you can go to setting page menu and click on “Export WPDB2SQL” link.
OR
- Download and save the wpdb-sql plugin to your hard disk.
- Login to your WordPress and go to the Add Plugins page.
- Click Upload Plugin button to upload the zip.
- Click Install Now to install and activate the plugin.
Screenshots

Just hover on setting page menu and click on sub menu labeled with "Export WPDB2SQL".;

Click on download button and our SQL file ready to download.
FAQ
How can this plugin work and to whom this plugin helpful. This plugin is helpful to the administrator role users who want to download database from their website for backup purpose. and won’t need to store backup file on your server so it will also reduce your server space by taking and storing backup on server at any time.
Changelog
1.0
1.1
1.2
- Testing and upgrading the code and also implies two different mode to take a backup of the DB.
1.3
- Testing with the various wordpress version for compatibility