UpdraftPlus Home › Forums › Paid support forum – UpdraftPlus backup plugin › Constant errors on backup
- This topic has 6 replies, 2 voices, and was last updated 2 years, 10 months ago by Bryle Crodua.
-
AuthorPosts
-
April 20, 2021 at 9:41 pm #1103678Archie MoParticipant
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
April 20, 2021 at 9:41 pm #1103679Archie MoParticipantThis reply has been marked as moderator-only.April 21, 2021 at 12:19 am #1103780Bryle CroduaModeratorHi,
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,
BryleMay 9, 2021 at 5:18 am #1121156Archie MoParticipantHello
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=0I 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! : )))
May 10, 2021 at 4:24 pm #1122297Bryle CroduaModeratorHi,
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,
BryleMay 12, 2021 at 1:54 am #1123640Archie MoParticipantHi
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.May 12, 2021 at 11:13 am #1123973Bryle CroduaModeratorHi,
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 -
AuthorPosts
- The topic ‘Constant errors on backup’ is closed to new replies.