Only one day's worth of database backups retained

  • Wes Modes

    (@wmodes)


    11 years, 1 month ago

    I am using BackupWordPress Version 2.2.1. Regardless of what you put for “Number of backups to store on this server”, it appears that backupwordpress is NOT storing more than a day’s worth of database backups. Am I crazy?

    I ran out of disk space on my system disk (my bad). After I resized the volume I was un-surprised to see that the database had been corrupted. I thought: “Not a problem because backupwordpress has been saving my database and files for the last 10 days!”

    However, looking in the backup directory, I was in for an unpleasant surprise. Apparently backupwordpress does save x days worth of files all zipped up nicely, but only 1 DAY’S DATABASE BACKUP. Ack.

    Here’s the backup directory:

    [root@spoon-portfolio 2397ec2b4b-backups]# ls
database_wordpress.sql
index.html
pclzip-512f05186d1f5.tmp
portfolio-thespoon-com-backup-complete-2013-02-17-23-06-11.zip
portfolio-thespoon-com-backup-complete-2013-02-18-23-00-55.zip
portfolio-thespoon-com-backup-complete-2013-02-19-23-05-01.zip
portfolio-thespoon-com-backup-complete-2013-02-20-23-06-59.zip
portfolio-thespoon-com-backup-complete-2013-02-21-23-32-12.zip
portfolio-thespoon-com-backup-complete-2013-02-22-23-24-42.zip
portfolio-thespoon-com-backup-complete-2013-02-23-23-24-17.zip
portfolio-thespoon-com-backup-complete-2013-02-24-23-05-34.zip
portfolio-thespoon-com-backup-complete-2013-02-25-23-32-07.zip
portfolio-thespoon-com-backup-complete-2013-02-26-23-14-48.zip
portfolio-thespoon-com-backup-complete-2013-02-27-23-14-55.zip

    I thought I must have backupwordpress misconfigured, but no.

    I double checked in settings->backup and it said “Backup my 554 MB database and files daily at 11:00 pm, store only the last 10 backups on this server.”

    I double checked settings->backup->add_schedule and verified that under backup “Both Database & Files” was selected.

    And then just to make sure that the plugin hadn’t stored the sql files somewhere else, I searched in the zip files and the entire wp-content directory and did not find any other *.sql backup files.

    I was terrified that my single database backup had been corrupted by the abruptly full disk. But I was lucky. If that one day db backup had been corrupted, I would have no further backups to go back to.

    Can someone verify what I am reporting?

    Wes

    http://wordpress.org/extend/plugins/backupwordpress/

Viewing 1 replies (of 1 total)
  • Thread Starter Wes Modes

    (@wmodes)

    11 years, 1 month ago

    For now, I’m setting up a not-so-sophisticated cron job that does this:

    cd /var/www/thespoon/wp-content/*-backups;cp -p database_wordpress.sql database_wordpress.sql.`date +%Y%m%d`

    At least until I understand what is happening with backupwordpress.

Viewing 1 replies (of 1 total)
  • The topic ‘Only one day's worth of database backups retained’ is closed to new replies.