Ah, this is SO good. Thank you, GamerZ!
Well, I spoke too soon. 🙁
When I run Backup DB, it completes without errors — but also without any data. It seems to be saving structure, however. The Database Backup Type is set to Full (Structure and Data).
Also, when I run Optimize DB, it errors out thusly…
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-cuppanews' at line 1]
OPTIMIZE TABLE -cuppanews
Last Action
Table(s) '-cuppanews' Failed To Be Optimized
My host is running MySQL 4.1.10.
Any thoughts?
hi hooopla, did you chmod the folder to 777? is $backup[‘path’] = ABSPATH.’wp-backup-db/’; ? Do you mind email me the html source code of the optimize page?
Hi! I’ve read through this thread, but I can’t find a solution to my problem. I get this error when I try to backup the db:
Warning: filesize(): Stat failed for /customers/jorgent.com/jorgent.com/httpd.www/ynwablogg/wp-backup-db/1120182960_-_jorgent_com.sql.gz (errno=2 – No such file or directory) in /customers/jorgent.com/jorgent.com/httpd.www/ynwablogg/wp-admin/database-manager.php on line 88
Warning: unlink(/customers/jorgent.com/jorgent.com/httpd.www/ynwablogg/wp-backup-db/1120182960_-_jorgent_com.sql.gz): No such file or directory in /customers/jorgent.com/jorgent.com/httpd.www/ynwablogg/wp-admin/database-manager.php on line 89
I have tried the different tips in this thread, but nothing works.. The folder is chmodded to 777.
I hope someone can help. Thanks in advance!
Or maybe someone knows about other db managers like this?
The download link doesn’t work…
I’ve got an odd problem here. For the most part this plugin works great. On my dev server, production server and most hosting providers I have used it on the plugin is flawless. However, As I am helping a few people add it to their WP installs I am running into a problem.
On sites hosted at Velcom (http://www.velcom.com/) I am getting the following error (the wp-backup-db folder is chmod’d to 777):
Warning: filesize(): Stat failed for /usr/www/user/domain.com/www/wp/wp-backup-db//1120842641_-_SiteManager.sql (errno=2 – No such file or directory) in /usr/www/user/domain.com/www/wp/wp-admin/database-manager.php on line 89
Warning: unlink(/usr/www/user/domain.com/www/wp/wp-backup-db//1120842641_-_SiteManager.sql): No such file or directory in /usr/www/user/domain.com/www/wp/wp-admin/database-manager.php on line 90
I’ve tried changing the code from:
$backup['path'] = ABSPATH . 'wp-backup-db/';
to:
$backup[‘path’] = ABSPATH . ‘wp-backup-db’;`
But that does not help either. Has anyone seen a solution to this?
akito: my site was down, now it is back up.
pelias, jorgent: what about $backup[‘path’] = ‘../wp-backup-db’;
GamerZ: I still get the error after making the change you suggested..
Warning: filesize(): Stat failed for ../wp-backup-db/1121272455_-_jorgent_com.sql (errno=2 – No such file or directory) in /customers/jorgent.com/jorgent.com/httpd.www/ynwablogg/wp-admin/database-manager.php on line 88
Warning: unlink(../wp-backup-db/1121272455_-_jorgent_com.sql): No such file or directory in /customers/jorgent.com/jorgent.com/httpd.www/ynwablogg/wp-admin/database-manager.php on line 89
And under “Last Action” I get this message: Database Failed To Backup On ‘Wednesday, 13th July 2005 @ 18:34’. Backup File Size Is 0KB
Gamerz – I’ve tried that as well. I am thinking there is some weird server config I am running into. Unless you have any other ideas?
I was able to fix the issue by creating a symbolic link to the /usr/local/mysql/bin/msyqldump file under /usr/bin/mysql and now it works…
What do you mean with “symbolic link”? I’m a newbie 😉
Seems if I say gzip it, this works great. Otherwise, it spits up all over the place like jorgent mentioned.
