Fails to backup my database

[thinsoldier]

Doesn't matter if I choose just database or both database and all files.

The zip files contain /wp-content/upgrade/dreamobject-db-backup.sql which is always an empty file.

[Ipstenu]

How big is your database?

[thinsoldier]

If I do an export from phpmyadmin to a single .sql file it's 869kb

[Ipstenu]

When you turn on the error logging, does anything show up?

Also are you on DreamHost or another host?

[thinsoldier]

I turned the logging on. The word "error" doesn't occur in my log at all.

I'm running wordpress on a local webserver.

[Ipstenu]

You're running the plugin error log, right? Can you paste it's content's in here? :)

To clarify there's a debug log in the plugin to record what it's doing. That's what I'd like to see.

[thinsoldier]

contents of wp-content/plugins/dreamobjects/debug.txt

[2014/12/15 10:41:39] Scheduled ASAP backup in 60 seconds. [2014/12/15 10:42:44] Begining Backup. [2014/12/15 10:42:44] Upgrade folder missing. This will cause serious issues with WP in general, so we will create it for you. [2014/12/15 10:42:44] ZipArchive found and will be used for backups. [2014/12/15 10:42:44] Checking for backups to be deleted. [2014/12/15 10:42:45] Backup Complete. [2014/12/15 10:42:45] [2014/12/15 10:43:51] Scheduled daily backup. Next backup: 7:00 pm [2014/12/15 10:44:06] Scheduled ASAP backup in 60 seconds. [2014/12/15 10:45:08] Begining Backup. [2014/12/15 10:45:08] Upgrade folder missing. This will cause serious issues with WP in general, so we will create it for you. [2014/12/15 10:45:08] ZipArchive found and will be used for backups. [2014/12/15 10:45:08] SQL file created: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-db-backup.sql (). [2014/12/15 10:45:08] SQL added to backup list. [2014/12/15 10:45:08] Creating zip file using ZipArchive. [2014/12/15 10:45:08] NOTICE: If the log stops here, PHP failed to create a zip of your wp-content folder. Please consider cleaning out unused files (like plugins and themes), or increasing the server's PHP memory, RAM or CPU. [2014/12/15 10:45:08] Calculating zip file size ... [2014/12/15 10:45:08] Zip file generated: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-backups.zip (226 B ). [2014/12/15 10:45:08] New filename workblog.xamp/2014-12-15-224508.zip. [2014/12/15 10:45:08] Begining upload to DreamObjects servers. [2014/12/15 10:45:08] Filesize is under 100megs. This will be less spammy. [2014/12/15 10:45:09] Upload complete [2014/12/15 10:45:09] Deleting zip file: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-backups.zip ... [2014/12/15 10:45:09] Deleting SQL file: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-db-backup.sql ... [2014/12/15 10:45:09] Checking for backups to be deleted. [2014/12/15 10:45:09] Removed backup workblog.xamp/2014-09-15-205504.zip from DreamObjects, per user retention choice. [2014/12/15 10:45:09] Backup Complete. [2014/12/15 10:45:09] [2014/12/15 10:46:10] Scheduled daily backup. Next backup: 7:00 pm [2014/12/15 10:46:17] Scheduled ASAP backup in 60 seconds. [2014/12/15 10:47:26] Begining Backup. [2014/12/15 10:47:26] Upgrade folder missing. This will cause serious issues with WP in general, so we will create it for you. [2014/12/15 10:47:26] ZipArchive found and will be used for backups. [2014/12/15 10:47:26] Calculating backup size... [2014/12/15 10:47:26] 49 MB of diskspace will be processed. [2014/12/15 10:47:26] 2276 files added to backup list. [2014/12/15 10:47:26] wp-config.php added to backup list. [2014/12/15 10:47:26] Creating zip file using ZipArchive. [2014/12/15 10:47:26] NOTICE: If the log stops here, PHP failed to create a zip of your wp-content folder. Please consider cleaning out unused files (like plugins and themes), or increasing the server's PHP memory, RAM or CPU. [2014/12/15 10:47:28] Calculating zip file size ... [2014/12/15 10:47:28] Zip file generated: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-backups.zip (7 MB). [2014/12/15 10:47:28] New filename workblog.xamp/2014-12-15-224728.zip. [2014/12/15 10:47:28] Begining upload to DreamObjects servers. [2014/12/15 10:47:28] Filesize is under 100megs. This will be less spammy. [2014/12/15 10:48:13] Upload complete [2014/12/15 10:48:13] Deleting zip file: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-backups.zip ... [2014/12/15 10:48:13] Checking for backups to be deleted. [2014/12/15 10:48:14] Removed backup workblog.xamp/2014-09-17-164750.zip from DreamObjects, per user retention choice. [2014/12/15 10:48:14] Backup Complete. [2014/12/15 10:48:14] [2014/12/15 10:54:14] Scheduled daily backup. Next backup: 7:00 pm [2014/12/15 10:54:19] Scheduled ASAP backup in 60 seconds. [2014/12/15 10:55:20] Begining Backup. [2014/12/15 10:55:20] Upgrade folder missing. This will cause serious issues with WP in general, so we will create it for you. [2014/12/15 10:55:20] ZipArchive found and will be used for backups. [2014/12/15 10:55:20] Calculating backup size... [2014/12/15 10:55:20] 93 MB of diskspace will be processed. [2014/12/15 10:55:20] 2278 files added to backup list. [2014/12/15 10:55:20] wp-config.php added to backup list. [2014/12/15 10:55:20] SQL file created: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-db-backup.sql (). [2014/12/15 10:55:20] SQL added to backup list. [2014/12/15 10:55:20] Creating zip file using ZipArchive. [2014/12/15 10:55:20] NOTICE: If the log stops here, PHP failed to create a zip of your wp-content folder. Please consider cleaning out unused files (like plugins and themes), or increasing the server's PHP memory, RAM or CPU. [2014/12/15 10:55:22] Calculating zip file size ... [2014/12/15 10:55:22] Zip file generated: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-backups.zip (29 MB). [2014/12/15 10:55:22] New filename workblog.xamp/2014-12-15-225522.zip. [2014/12/15 10:55:22] Begining upload to DreamObjects servers. [2014/12/15 10:55:22] Filesize is under 100megs. This will be less spammy. [2014/12/15 10:58:46] Upload complete [2014/12/15 10:58:46] Deleting zip file: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-backups.zip ... [2014/12/15 10:58:46] Deleting SQL file: /Applications/XAMPP/xamppfiles/htdocs/twig/workblog/wp-content/upgrade/dreamobject-db-backup.sql ... [2014/12/15 10:58:46] Checking for backups to be deleted. [2014/12/15 10:58:46] Removed backup workblog.xamp/2014-09-17-170935.zip from DreamObjects, per user retention choice. [2014/12/15 10:58:46] Backup Complete. [2014/12/15 10:58:46]

[thinsoldier]

Also since I'm running locally I have php error reporting turned on and there are a lot of notices and warnings related to the dreamobjects plugin.

It's really only 3 but they occur multiple times per page sometimes.

Strict standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method DHDO::cron_schedules() should not be called statically in /wp-includes/plugin.php on line 214

Strict standards: Only variables should be passed by reference in /wp-content/plugins/dreamobjects/admin/backups.php on line 73

Notice: Undefined index: page in /wp-content/plugins/dreamobjects/lib/dhdo.php on line 81

[Ipstenu]

What version of mySQL and PHP are you using?

[thinsoldier]

PHP Version 5.5.19 mysql 5.6.21

[Ipstenu]

I have not yet tested on MySQL 5.6 so I'll get on that and see if there's something weird in it.

[thinsoldier]

I recently upgraded.

Previously I was using mysql 5.5.31 and php 5.4.19

It wasn't saving sql data with the older versions either.

[Ipstenu]

I ... want to say something's wrong with SQL on your end, since I can't reproduce that (tested on 5.4 and 5.5 here). I'm going to keep banging on it, but WP 4.1 just dropped, so this may wait till after Hanukkah :/

[thinsoldier]

I'm trying to get xdebug working so I can step through the code as it executes and hopefully see what's going wrong when it gets to the database related code.

[Ipstenu]

Sadly I've just not been able to reproduce it on any setup I built.

[Ipstenu]

I was never able to reproduce this :(