[Plugin: WordPress Backup to Dropbox] v_1.3 A fatal error occured: Error writing to sql dump file.

FYI….. additional info

PHP.ini info

max execution time of 500
memory limit of 128MB
safe mode off

The WP SQL dump seems to copy to Dropbox. But times-out at some point. We can’t determine which file throws the above error.

Gday Mate,

I just pushed a small change that attempts to umask the php process with elevated privileges, if you setup allows it, to get around this issue.

Can you please delete and re-install the plugin to get this change and let me know how it goes.

Cheers,
Mikey

Hi Mike,
Following your recommendations: delete and reinstall. FYI… If we start the backup manually, the backup process completes without issue. If the nightly scheduled backup is when we get hiccups and unnerving backup error messages.
Hopefully good news tomorrow morning in the back log.

Here is last night’s log….
00:25:12 : A fatal error occured: Error writing to sql dump file.
00:16:51 : Creating SQL backup of your WordPress plugins.
00:16:25 : Creating SQL backup of your WordPress core.
00:15:51 : There has been no backup activity for a long time. Attempting to resume the backup.
00:09:50 : Approximately 4% complete. View uploaded files?
00:09:14 : Approximately 4% complete. View uploaded files?
00:08:26 : Approximately 4% complete. View uploaded files?
00:08:20 : Approximately 4% complete. View uploaded files?
00:08:14 : Approximately 4% complete. View uploaded files?
00:08:08 : Approximately 4% complete. View uploaded files?
00:08:02 : Approximately 3% complete. View uploaded files?
00:07:56 : Approximately 3% complete. View uploaded files?
00:07:43 : Approximately 3% complete. View uploaded files?
00:07:34 : Approximately 2% complete. View uploaded files?
00:07:12 : Backing up WordPress path at (/nfs/c09/h02/mnt/136951/domains/backcountryaccess.com/html/).
00:06:43 : There has been no backup activity for a long time. Attempting to resume the backup.
00:01:15 : Creating SQL backup of your WordPress plugins.
00:00:51 : Creating SQL backup of your WordPress core.

Evidentially, umasking does not work for you.

The plugin cannot write to the backup directory due to permissions. Please ensure the directory is writeable.

/wp-content/backups/ folder permission set to 777 yesterday. Backup log this morning….

00:09:24 : A fatal error occured: Error writing to sql dump file.
00:00:33 : Creating SQL backup of your WordPress plugins.
00:00:08 : Creating SQL backup of your WordPress core.
00:00:03 : Backup started on Monday October 22, 2012.

What’s left to check?

Righto, I found a potential error where it could incorrectly raise that error when writing an empty string to the DB dump file.

I have just pushed a fix for it in version 1.3 so can you please delete and re-install the plugin to get the update.

If this does not fix the issue then It could be due to lack of disk space.

Cheers,
Mikey