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.
Home Page: https://wordpress.org/plugins/wp-dbmanager/
🌏 I blogged about gadgets at lesterchan.net.
🥞 Currently working in Grab as a Engineering Manager, Full Stack.
⏪ Previously, I was the Head of Engineering in Tech in Asia.
🔌 During my free time (which I do not have much now), I am a WordPress Plugins Developer.
wp_clear_scheduled_hook( 'dbmanager_cron_backup' );
wp_clear_scheduled_hook( 'dbmanager_cron_optimize' );
wp_clear_scheduled_hook( 'dbmanager_cron_repair' );
If you want to reproduce the bug in your machine, this is my old password:
!·%/QETU
With this the file output is 0 B in SQL or 20 B in GZIP.
Hi,
I'm no longer able to make backups using the plugin. I installed the latest version to a new site on my server and backups are 0 bytes (or 20 bytes zipped). I tried on another site on the same server that was running 2.71 and that worked OK, but when I upgraded to 2.74 the same problem started.
On another site when I tried, I got a specific error about escapeshellarg() not being available. Is it possible some of the functions used since 2.71 are, for security reasons, not available in all PHP installations?
Thanks,
Will
I'm not sure if this problem is what broke wp-cron, or just only uncovered when trying to fix a broken wp-cron - but it seems wp-dbmanager doesn't handle folders it can't access very well.
Running wp cron event run --due-now to fix a broken cron got me endless loops of:
Warning: readdir() expects parameter 1 to be resource, bool given in /home/{...}/wp-content/plugins/wp-dbmanager/wp-dbmanager.php on line 392
I disabled wp-dbmanager and tried again, which gave me the alert that I couldn't write to specific folders. Turns out I was running as the wrong user, and with the right user all was good.
Looked at the code anyway, and see that the lines around 392 in wp-dbmanager don't check for the false returned by opendir if $folder doesn't exist or is banned by permissions.
I could do a PR to check it in place, but think the check should probably be at a higher level as is_emtpy_folder seems inappropriate for what should be 'is_writeable' or something.
I would like to see the ability to perform backups and control other aspects of this plugin from a RESTFUL API. This would assist automated systems in performing scheduled deployments and rollbacks.
I would love the ability to name backup files prior to backup or alternatively, and/or to rename them after backup to help me remember specific points that the backup represents.
This function is used when downloading a backup file to verify the file name. In my wp installation, another plugin overrides this function to add a unique string.
As a result, file download does not work.
You probably need to use this function to generate the file name when creating the backup.
Please do multisite support. Plugin menu in super admin network console
Notice: Undefined index: repair
wp-content/plugins/wp-dbmanager/wp-dbmanager.php 136
Notice: Undefined index: repair_period
wp-content/plugins/wp-dbmanager/wp-dbmanager.php 136
https://wordpress.org/support/topic/some-errors-in-wp-442?replies=1
I have wanted this for years. Today I decided to "Just Do It" (TM) and submitted a pull request #28 for your review. I am happy to make changes per suggestions and resubmit.
dbmanager won't delete old backup files.
Maximum Backup Files is set to 12, but they are never deleted.
Is there any logging of the attempts to delete? Perhaps there would be a clue there. I suspect a file system permissions issue, but all is green on the "Backup DB" page in wp-admin. "Excellent. You Are Good To Go."
Using version 2.77 with Wordpress 4.6.1, but I've had the same issue for many earlier versions too.
Any ideas?
I'm using WP 4 and the latest version of your plugin but can't get the dbbackup path to save. Any ideas?
From December 24 DBManager my every moment makes a copy of the database and sends it by e-mail, despite the existence of only one task in WP_Cron. The task set to 13:00 each day is done until 20:00. I can not locate the cause, the server logs there are no errors (eg. Timeout or something similar). WordPress v4.1. Please help.
I am new to wordpress and maybe my remark is irrelevant. Is the .htaccess with allow/deny compatible with Apache 2.4? I noticed in some other plugins we have smth like:
<IfModule !mod_authz_core.c>
Order Deny,Allow
Deny from all
< /IfModule>
Require all denied
< /RequireAll>
Indicates the creator of the table: either a plugin, a theme or WordPress itself.
glad i found this plugin, but i think the UI could be simplified quite a bit by adding a table column of checkboxes (not radios) to the 'Database' page with Empty, Drop, Repair and Optimize buttons at the bottom of the page
this would eliminate the need for the other 3 pages
Any time wp-dbmanager is active, the warning below shows:
Your backup folder MIGHT be visible to the public
To correct this issue, move the file from /home5/quicksi7/public_html/wp-content/plugins/wp-dbmanager/htaccess.txt to /home5/quicksi7/public_html/wp-content/backup-db/.htaccess
After a restore of my site, the warning appeared. I used an ftp program to make the instructed changes, but the warning will never go away unless I deactivate wp-dbmanager.
Any suggestions for how to get rid of the warning while wp-dbmanager is active?
Replace Line 199 with:
$paths['mysql'] = $install_path.'/bin/mysql.exe';
and Line 200 with:
$paths['mysqldump'] = $install_path.'/bin/mysqldump.exe';
https://wordpress.org/support/topic/problem-solved-on-xampp?replies=2
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.