Backup help?

Hi James,

If Pastebin says it’s too big, then try pasting it in two parts. Or as many parts as it takes!

David

Mr. Anderson,

Thank you so much for your quick reply. I am currently trying to to backup again and it’s on ‘next resumption: 8’ right now. As soon as it gets done with all the resuming I’ll get the log file into Pastebin and get right back with you.

Thank you,
James.

Mr. Anderson,

Here is the latest log file. I had to paste it into Pastebin into 2 parts.
Part 1: https://pastebin.com/JqKK64LC

Part 2: https://pastebin.com/gvrNc6Ad

Any help at all would be extremely appreciated!!
Thanks,
James.

Hi James,

The links seem to be missing!

Edit: Well, they were when I looked earlier!

David

Mr Anderson,

That’s strange. They are showing up just fine for me. I’ll post them again.

Part 1: https://pastebin.com/JqKK64LC

Part 2: https://pastebin.com/gvrNc6Ad

Hope the links work this time.
James.

Hmmm. It’s dying whilst trying to dump out a table with 50,000 rows.

The log indicates that it would likely have tried to dump this out using /usr/bin/mysqldump. It’s possible that for some unknown reason this caused a crash.

If you open up wp-content/plugins/updraftplus/backup.php and search for “>10000” (somewhere near line 909), and change it to 100000 (i.e. add an extra 0), and start a fresh backup, then does that make a difference? (That’ll cause it to not try mysqldump, which means it’ll go slower, but what we’re doing here is testing the ‘crash’ hypothesis).

David

Mr. Anderson,

I added the zero and started a fresh backup. It seems like it done the same thing again. Here’s the new log file.

Part 1: https://pastebin.com/C7fdwQBr

Part 2: https://pastebin.com/KaEc8eXJ

Does this mean I need to go delete that zero back out? Or, any advice on the next step would be greatly appreciated.
James.

In that case, I think that the problem is that your web hosting company just doesn’t allow enough time to dump out that table. Your best bet may be to go into the settings for the WP Slimstats plugin, and clear out some of the historical data, because it seems to be storing more data than you get resources to create a backup of.

Yes, you should delete the zero – it seems it wasn’t a crash, just a lack of time.

David

Mr. Anderson,

Thank you very much for your assistance. I too figured it was something to do with that 50,000+ row table as it is a huge file compared to the rest within that plugins database. I have put in a support ticket with the SlimStat creator on how to go about deleting the records. I’ll try another backup as soon as these files are gone.

Thanks so much for your time and help,
James.

Hi James,

You’re welcome. Going from memory (I’ve seen this plugin before – though usually it’s at least 100,000 rows before things are a problem, so I guess your server is probably a bit more overloaded or less powerful than is normal) I think there’s a setting somewhere on its settings page to purge historical data automatically (e.g. at more than X months old), rather than keeping it forever.

David

Hi,

I’ll reply here, since it’s in topic with the thread. The option to purge your data, is designed to use filters, but not a date range. What you can do is to set the number of days to keep in the database, and wait until WP SlimStat performs its daily purge.

By the way, I just noticed that there’s a bug in the ‘purge by field’ setting, and that could be the reason why it’s not deleting your data right now. Please wait for 3.5.3 to be released (next week) and see if that helps.

Sorry for the inconvenience.

Camu

Or, I can send you a beta version of 3.5.3 that you can test ??

Camu,

Hi there!!
I just set the number of days to 20 for right now. As soon as the daily purge kicks in, I’ll reset it to a more appropriate number.

On the other hand, I would be happy to test out new beta version, as long you could walk me through the install, if it’s a manual one. I haven’t actually performed a manual install of anything yet and it would be a fine time to learn right quick!!

Just let me know what I need to do to get started.
Thanks,
James.

Contact us and we’ll walk you through the process.

https://support.getused.to.it

Cheers,
Camu