[Plugin: Backup] SQL file not backing up

Do you have anything in your PHP error_log?

Nope, no relevant PHP error messages.

All good now!

There was a subfolder somewhere inside wp-content/themes without read access for everyone.
That seems to have bothered Backup.

After chmodding that particular folder, everything backs up fine now.

Awesome!

Glad you managed to solve the problem.