Constant errors on backup

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #1103678
    Archie Mo
    Participant

    Hi

    I have a premium version of the plugin.

    For last couple months every backup gets this error.

    “Websitename” : Backup Report Backup made by UpdraftPlus 2.16.53.25 – https://updraftplus.com” target=”_blank Backup of: UpdraftPlus 2.16.53.25 – https://updraftplus.com” target=”_blank Latest status: The backup apparently succeeded (with warnings) and is now complete Backup began: 2021-04-20 12:31 Contains: Database only (files were not part of this particular schedule) Errors / warnings: 0 errors, 1 warnings Warnings Your website is visited infrequently and UpdraftPlus is not getting the resources it hoped for; please read this page: https://updraftplus.com/faqs/why-am-i-getting-warnings-about-my-site-not-having-enough-visitors/ Note that warning messages are advisory – the backup process does not stop for them. Instead, they provide information that you might find useful, or that may indicate the source of a problem if the backup did not succeed. Time taken: 0 hours, 54 minutes, 20 seconds Uploaded to: Google Drive Database (files: 1) backup_2021-04-20-1231_bbff9841e9ed-db.gz Size: 47 MB, SHA1 checksum: b49eef302d90e41fb520fd9130580c75f02ce613, SHA256 checksum: 74e8733bfe5af8cc0a4314faa6af20b78612620e7d9a50dbe7a1ef4b6cd97b6a The log file has been attached to this email.

    Thing is, my website gets around 100-150 unique visits a day, so lack of traffic and website visitors shouldn’t really be an issue here.

    Please advice

    #1103679
    Archie Mo
    Participant
    This reply has been marked as moderator-only.
    #1103780
    Bryle Crodua
    Moderator

    Hi,

    Please could you send us a copy of the latest full backup log?

    This can be found in the UpdraftPlus Existing Backups tab.
    The contents will be too long to post here directly, but you can use an online service such as Dropbox or Pastebin, and post the link here.

    Regards,
    Bryle

    #1121156
    Archie Mo
    Participant

    Hello

    Sorry for the late reply.

    Here are the log files.

    https://www.dropbox.com/s/yvfwrwd8q5tjnwo/log.3d2f27209db3%20-%20Database%20Backup%20Only.txt?dl=0
    https://www.dropbox.com/s/8yccp56r6qtil7u/log.778e84faa9cd%20-%20whole%20website%20backup%20log.txt?dl=0

    I have 2 backups setup on website, one is for Database only and another is for the whole website.
    Links for both backup log files are provided above.

    Take a look please. and Thank you! : )))

    #1122297
    Bryle Crodua
    Moderator

    Hi,

    Thank you!

    The recent logs you shared no longer shows the infrequent visit warning message. However, I see another warning message that can be addressed too.
    “0003.083 (0) [Warning] Table scb_postmeta has very many rows (535615) – we hope your web hosting company gives you enough resources to dump out that table in the backup If not, you will need to either remove data from this table, or contact your hosting company to request more resources.”

    Please try and optimize the database to lessen the number of rows. There are a lot of free database optimisation plugin and you can try one of ours – WP Optimize.

    Thanks,
    Bryle

    #1123640
    Archie Mo
    Participant

    Hi

    Thanks for the response.

    Is it safe to clear that whole table? I mean delete all the data in that table ?
    535615 rows sound a lot, but what should be considered as relatively normal amount of rows? : )))
    BTW, this is a woocommerce website, if it matters at all.

    #1123973
    Bryle Crodua
    Moderator

    Hi,

    No, you don’t want to clear the whole table as you will lose data on your website. The best thing to do is to clean your database using optmisation plugin on wordpress.org – make sure you backup your databse before doing that. If not you can ask your host to increase your server resources as stated in the warning message.

    Thanks,
    Bryle

Viewing 7 posts - 1 through 7 (of 7 total)
  • The topic ‘Constant errors on backup’ is closed to new replies.