Yes I am observing the same conditions:
Automatic Backing Up Of DB: Next backup date: April 1, 2013 @ 12:07 pm
Every Gzip
E-mail backup to: (Leave blank to disable this feature)
WP-DBManager can automatically backup your database after a certain period.
Automatic Optimizing Of DB: Next optimize date: April 1, 2013 @ 12:07 pm
Every 60 minutes gzip yes
This was set up at noon on 1 april 2013
I’m also interested in this.
are you using some sort of caching plugin?
W3TC – are you aware of some incompatibility with W3TC?
Thread Starter
BeeCee
(@csigncsign)
no, I for myself use NO caching plugin. I have de-activated ALL other plugins for testing this, but it makes no difference.
@utnalove: yes do a search on this forum or Google on W3TC with scheduled backup
@csigncsign: Try this debug http://forums.lesterchan.net/index.php/topic,4549.0.html
@lester: I have turned off W3TV and then I’ve changed the scheduling options to 1 hour. And 1,5 hours passed and no backup.
Then I changed it to every 5 minutes…. but nothing. The timer goes “Next backup date: 14 kwietnia 2013 @ 18:31”, then appeared “Next backup date: 14 kwietnia 2013 @ 18:36”, then Next backup date: 14 kwietnia 2013 @ 18:41.
But I am not receiving any mail. Only if I send it manually. And W3TC was off. Now I am turning it on again.
Thread Starter
BeeCee
(@csigncsign)
thanks, Lester, but this doesn’t help me anything 🙁
@utnalove: try the debugging method here http://forums.lesterchan.net/index.php/topic,4549.0.html, what is the output?
@csigncsign: if it doesn’t work, I am afraid you have to try other plugins.
Hi I have done that. The command is (I have hidden sensitive data WITH XXX):
/usr/bin/mysqldump --host="localhost" --user="XXX" --password="XXX" --add-drop-table --skip-lock-tables XXX | gzip > /home/MYHOME/public_html/wp-content/backup-db/1366119946_-_XXX_XXX1.sql.gz
And this is the output. It takes a while, and gives no error. It sucessfully runs the command.
[email protected] [~]# /usr/bin/mysqldump --host="localhost" --user="XXX" --password="XXX" --add-drop-table --skip-lock-tables XXX | gzip > /home/MYHOME/public_html/wp-content/backup-db/1366119946_-_XXX_XXX1.sql.gz
[email protected] [~]#
Other info you’d like to have:
Checking Backup Status
Checking Backup Folder (/home/glamouri/public_html/wp-content/backup-db) ...
Backup folder exists
Backup folder is writable
Checking MYSQL Dump Path (/path/mysqldump) ...
MYSQL dump path exists.
Checking MYSQL Path (/path/mysql) ...
MYSQL path exists.
Checking PHP Functions (passthru(), system() and exec()) ...
passthru() enabled.
system() enabled.
exec() enabled.
Excellent. You Are Good To Go.
Thread Starter
BeeCee
(@csigncsign)
I had the same command output as utnalove.
utnalove: could you check if the file exists on /home/MYHOME/public_html/wp-content/backup-db/1366119946_-_XXX_XXX1.sql.gz ?
Hi, yes. I confirm that the files are being well generated: http://img405.imageshack.us/img405/4792/backups.png