WP-DBManager – WordPress plugin Free download

Click to Download

WP-DBManager

Description

Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.

General Usage

Activate WP-DBManager Plugin
The script will automatically create a folder called backup-db in the wp-content folder if that folder is writable. If it is not created, please create the folder and ensure that the folder is writable
Open Folder: wp-content/backup-db
If you are on Apache, move the htaccess.txt file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/.htaccess if it is not there already
If you are on IIS, move the Web.config.txt file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/Web.config if it is not there already
Move index.php file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/index.php if it is not there already
Go to WP-Admin -> Database -> DB Options to configure the database options

Build Status

Development

https://github.com/lesterchan/wp-dbmanager

Translations

http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/

Credits

Plugin icon by Freepik from Flaticon

Donations

I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks, I will really appreciate it. If not feel free to use it without any obligations.

Disclaimer

Note that this plugin passes your datababase password via –password in the command line of mysqldump. This is convenient but as a trade off, it is insecure.
On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. However, there is still a brief interval during which the value is visible. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps. Source: End-User Guidelines for Password Security
If this is a concern to you, I recommend another database backup plugin called WP-DB-Backup
To know about the difference between WP-DBManager and WP-DB-backup, checkout What is the difference between WP-DBManager and WP-DB-Backup? in the FAQ section.

Screenshots

Admin – Backup DB
Admin – Empty/Drop Tables In DB
Admin – DB Information
Admin – Manage DB
Admin – Optimize DB
Admin – DB Options
Admin – DB Options
Admin – Repair DB
Admin – Run Query in DB

FAQ

My database is not backed up / My backup file is 0Kb

Ensure that your host allows you to access mysqldump. You can try to narrow the problem by Debugging via SSH:

In wp-dbmanager.php
Find check_backup_files(); on line 246
Add below it echo $command;
Go to WP-Admin -> Database -> Backup
Click Backup
It should print some debugging statements
Copy that line than run it in SSH
If you need help on SSH contact your host or google for more info

What is the difference between WP-DBManager and WP-DB-Backup?

WP-DBManager uses mysqldump application to generate the backup and mysql application to restore them via shell.
WP-DB-Backup uses PHP to generate the backup. In some cases WP-DB-Backup will work better for you because it requires less permissions. Not all host allows you to access mysqldump/mysql directly via shell.
WP-DBManager allows you to have automatic optimizing and repairing of database on top of backing up of database.

Why do I get the message “Warning: Your backup folder MIGHT be visible to the public!”?

Ensure that you have renamed htaccess.txt to .htaccess and placed it in your backup folder (defaults to wp-content/backup-db/)
If you are 100% sure you have did that and have verfied that the folder no longer is accessible to the public by visiting the URL http://yousite.com/wp-content/backup-db/, you can safely disable the notice by going to WP-Admin -> Database -> DB Options and set Hide Admin Notices to Yes.

Reviews

Leave a Reply

Your email address will not be published. Required fields are marked *