DB Backup generates .zip and .sql backup files

[Var]

So I have set up 2 weekly DB backup jobs (one on a Sunday and the other on a Wednesday) as I hoped to have twice weekly DB backup schedule.

I see the backup generates a zip file; however, the newly added Wednesday backup seems to have not zipped it and what I see that’s available for download is the .sql file.

I would like all backups to be in zip as it’s space-saving. The zip files are less than 100MB, while the .sql file is 2GB.

Let me know what I am missing here.

Thanks!

[AITpro Admin]

BPS DB Backup is supposed to zip all .sql files.  So most likely some kind of problem occurred that prevented the .sql file from being zipped.  Go ahead and delete the .sql file.  Let me know if the problem occurs again.  Note:  If your database is extremely large than you may want to consider getting a WP plugin that specializes in DB Backups.  BPS DB Backup is an additional feature in BPS, but BPS is primarily a website security plugin.

[Var]

Thanks for your speedy response. I realized there was a cron job problem due to a PHP fatal error, perhaps that could have caused this. Deleted it and I’ll check in the next backup.

I was actually trying to minimize plugin usage so I am glad BPS, although mainly for security, has this handy DB backup tool👍

[Author]

Posts