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.<\/p>\n\n
WP-DBManager<\/code> Plugin<\/li>\n- The script will automatically create a folder called
backup-db<\/code> 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<\/li>\n- Open
Folder: wp-content\/backup-db<\/code><\/li>\n- If you are on Apache, move the
htaccess.txt<\/code> file from Folder: wp-content\/plugins\/wp-dbmanager<\/code> to Folder: wp-content\/backup-db\/.htaccess<\/code> if it is not there already<\/li>\n- If you are on IIS, move the
Web.config.txt<\/code> file from Folder: wp-content\/plugins\/wp-dbmanager<\/code> to Folder: wp-content\/backup-db\/Web.config<\/code> if it is not there already<\/li>\n- Move
index.php<\/code> file from Folder: wp-content\/plugins\/wp-dbmanager<\/code> to Folder: wp-content\/backup-db\/index.php<\/code> if it is not there already<\/li>\n- Go to
WP-Admin -> Database -> DB Options<\/code> to configure the database options<\/li>\n<\/ol>\n\nBuild Status<\/h3>\n\n
<\/a><\/p>\n\nDevelopment<\/h3>\n\n\n- https:\/\/github.com\/lesterchan\/wp-dbmanager<\/a><\/li>\n<\/ul>\n\n
Translations<\/h3>\n\n\n- http:\/\/dev.wp-plugins.org\/browser\/wp-dbmanager\/i18n\/<\/a><\/li>\n<\/ul>\n\n
Credits<\/h3>\n\n\n- Plugin icon by Freepik<\/a> from Flaticon<\/a><\/li>\n<\/ul>\n\n
Donations<\/h3>\n\n\n- 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.<\/li>\n<\/ul>\n\n
Disclaimer<\/h3>\n\n\n- 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.<\/li>\n
- 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<\/a><\/li>\n
- If this is a concern to you, I recommend another database backup plugin called WP-DB-Backup<\/a><\/li>\n
- To know about the difference between WP-DBManager and WP-DB-backup, checkout What is the difference between WP-DBManager and WP-DB-Backup?<\/strong> in the FAQ section<\/a>.<\/li>\n<\/ul>\n\n\n
\nMy database is not backed up \/ My backup file is 0Kb<\/h3><\/dt>\n\n- Ensure that your host allows you to access mysqldump. You can try to narrow the problem by Debugging via SSH:<\/li>\n<\/ul>\n\n
\n- In
wp-dbmanager.php<\/code><\/li>\n- Find
check_backup_files();<\/code> on line 246<\/li>\n- Add below it
echo $command;<\/code><\/li>\n- Go to
WP-Admin -> Database -> Backup<\/code><\/li>\n- Click
Backup<\/code><\/li>\n- It should print some debugging statements<\/li>\n
- Copy that line than run it in SSH<\/li>\n
- If you need help on SSH contact your host or google for more info<\/li>\n<\/ol><\/dd>\n
What is the difference between WP-DBManager and WP-DB-Backup?<\/h3><\/dt>\n\n- WP-DBManager uses
mysqldump<\/code> application to generate the backup and mysql<\/code> application to restore them via shell.<\/li>\n- 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.<\/li>\n
- WP-DBManager allows you to have automatic optimizing and repairing of database on top of backing up of database.<\/li>\n<\/ul><\/dd>\n
Why do I get the message \"Warning: Your backup folder MIGHT be visible to the public!\"?<\/h3><\/dt>\n\n- Ensure that you have renamed
htaccess.txt<\/code> to .htaccess<\/code> and placed it in your backup folder (defaults to wp-content\/backup-db\/<\/code>)<\/li>\n- 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\/<\/code>, you can safely disable the notice by going to WP-Admin -> Database -> DB Options<\/code> and set Hide Admin Notices<\/code> to Yes<\/code>.<\/li>\n<\/ul><\/dd>\n\n<\/dl>\n\n\nVersion 2.80.10<\/h3>\n\n\n- FIXED: Don't throw fatal error if unknown .sql files are inside the database backup folder.<\/li>\n<\/ul>\n\n
Version 2.80.9<\/h3>\n\n\n- FIXED: Handle folder permissions properly<\/li>\n<\/ul>\n\n
Version 2.80.8<\/h3>\n\n\n- FIXED: Miss out database-backup.php.<\/li>\n<\/ul>\n\n
Version 2.80.7<\/h3>\n\n\n- FIXED: Changed 'edit_files' capability to 'install_plugins' instead.<\/li>\n<\/ul>\n\n
Version 2.80.6<\/h3>\n\n\n- FIXED: Remove 'manage_database' and use 'edit_files' to check for capability instead.<\/li>\n<\/ul>\n\n
Version 2.80.5<\/h3>\n\n\n- FIXED: Changed utf8 to utf8mb4 for backing up<\/li>\n<\/ul>\n\n
Version 2.80.4<\/h3>\n\n\n- FIXED: Clear WP-DBManager cron jobs on uninstall<\/li>\n<\/ul>\n\n
Version 2.80.3<\/h3>\n\n\n- FIXED: Poly fill array_key_first() for PHP < 7.3<\/li>\n<\/ul>\n\n
Version 2.80.2<\/h3>\n\n\n- FIXED: Newer backup is being replaced instead of older backup<\/li>\n<\/ul>\n\n
Version 2.80.1<\/h3>\n\n\n- FIXED: 1970 date issues.<\/li>\n
- FIXED: Sorting order of backup files. <\/li>\n<\/ul>\n\n
Version 2.80<\/h3>\n\n