Advertisement:

Author Topic: Missing posts for ~ 2 months!!!  (Read 534 times)

Offline TheSnake

  • Semi-Newbie
  • *
  • Posts: 87
  • Gender: Male
    • The Better Alternative
Missing posts for ~ 2 months!!!
« on: November 02, 2019, 02:27:06 AM »
The forum stopped working. Post to the hosting. They asked do we want to move to another server. We said it's okay, if it necessary. Moved and NO POSTS for around 2 months! Started to ask them what's wrong, why they lost so much data?! They said they'll check the logs and... already many days nothing. The tickets are "on hold". My last backup is probably few months ago and it will not working. "Repair database" - done, but not working. Google cache -- cashed only a few posts, so not that useful. Any other ideas (except it's time to find a more responsible hosting)?

The history:

Hello! In the recent ~48 hours we got non-stop the 503 error: "503
Service Unavailable

I apologize for any delay you experienced. Would you like to change the server?

Hello! Of course, if it's necessary it's OK to change the server.
Best regards!

Hello!
We agreed to move to another server. Now it's working, but there is a lot of missing data (from the last 2 months). Is it something temporary?

AFTER THIS -- many more messages/tickets, mails and feedback messages, but nothing happened... So, I need to know is there a way a person alone, without the hosting help to do it?

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,739
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Missing posts for ~ 2 months!!!
« Reply #1 on: November 02, 2019, 02:40:19 AM »
Your host moved you to another server, in order to do that they would need to either use a backup that already existed or make a new one first. I find it odd, and suspicious, if the first thing they do is suggest changing servers... That's always a bit of a risk, and if something really is wrong when doing the transfer - even more so. Did they use an old backup, or did they perhaps make an incomplete backup of what was on the server at the time - or did the move just fail somehow, we can't really know. Sorry to say, this would very much be your hosts responsibility to explain.

Yet another good reminder of the importance of backups though.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,211
  • Gender: Male
    • i30 Owners Club
Re: Missing posts for ~ 2 months!!!
« Reply #2 on: November 02, 2019, 04:06:15 AM »
Quote
...
Yet another good reminder of the importance of backups though.

Absolutely, and more importantly make sure those backups are YOUR backups.

Take your own. Regularly.  A cron job on my host sends a DB backup every 4 hours to one of my home servers.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,739
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Missing posts for ~ 2 months!!!
« Reply #3 on: November 02, 2019, 04:33:34 AM »
I do Plesk snapshots once a day, those are in a format where I can just extract complete folder structures and databases with 7zip if I need to, and can then transfer them on any platform I wish. Haven't needed these, never ever, but still I think it's a very good practice and I keep doing it.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,982
    • StoryBB/StoryBB on GitHub
Re: Missing posts for ~ 2 months!!!
« Reply #4 on: November 02, 2019, 11:15:52 AM »
I do Plesk snapshots once a day, those are in a format where I can just extract complete folder structures and databases with 7zip if I need to, and can then transfer them on any platform I wish. Haven't needed these, never ever, but still I think it's a very good practice and I keep doing it.

I would periodically test that you can restore them. No one wants to rely on a backup only to discover it doesn’t work.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,739
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Missing posts for ~ 2 months!!!
« Reply #5 on: November 02, 2019, 11:27:45 AM »
I do Plesk snapshots once a day, those are in a format where I can just extract complete folder structures and databases with 7zip if I need to, and can then transfer them on any platform I wish. Haven't needed these, never ever, but still I think it's a very good practice and I keep doing it.

I would periodically test that you can restore them. No one wants to rely on a backup only to discover it doesn’t work.

I don't use the incrementals, and haven't seen any issues with any full backup I've extracted before - any specific reason for the warning? ( I mean, they are simply a compressed archive of the server contents. )
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,982
    • StoryBB/StoryBB on GitHub
Re: Missing posts for ~ 2 months!!!
« Reply #6 on: November 02, 2019, 12:11:11 PM »
I’ve had to recover too many times from “we have a backup” when in fact the backup was worthless. A backup is not a backup until you prove you can restore from it.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,739
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Missing posts for ~ 2 months!!!
« Reply #7 on: November 02, 2019, 12:22:27 PM »
Well, that's fair and true :)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline TheSnake

  • Semi-Newbie
  • *
  • Posts: 87
  • Gender: Male
    • The Better Alternative
Re: Missing posts for ~ 2 months!!!
« Reply #8 on: November 02, 2019, 02:13:29 PM »
They just stopped answering. We sent them a few more: tickets, emails and support messages. I do agree that in future we need a daily or hourly backup. No more trust...

Offline TheSnake

  • Semi-Newbie
  • *
  • Posts: 87
  • Gender: Male
    • The Better Alternative
Re: Missing posts for ~ 2 months!!!
« Reply #9 on: November 02, 2019, 02:14:28 PM »
And still, are there some source online (like full cache) where we can find all these missing posts of the last ~2 months? Any ideas?

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,187
  • Gender: Male
    • Macedonian electronics forum
Re: Missing posts for ~ 2 months!!!
« Reply #10 on: November 02, 2019, 02:54:58 PM »
Might be worth trying to find the old posts via archive.org (if archive.org indexed all of the boards and topics from your forum in the last 2 months, which is very unlikely), but you'd have to add those posts manually. They don't do database backups, their crawlers just crawl the site and take snapshost of threads, just like any other search engine crawler, that's it.
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline TheSnake

  • Semi-Newbie
  • *
  • Posts: 87
  • Gender: Male
    • The Better Alternative
Re: Missing posts for ~ 2 months!!!
« Reply #11 on: November 02, 2019, 03:53:52 PM »
Yes, but there aren't enough. Tried it already.

Offline delta5

  • Jr. Member
  • **
  • Posts: 300
    • @@kd8hmo on Twitter
    • FedUpWithLiberals.com
Re: Missing posts for ~ 2 months!!!
« Reply #12 on: November 04, 2019, 03:54:35 PM »
I'm paying a bit extra for automatic backups. Everyday it does a database backup AND complete backup of the entire forum. I learned my lesson on that, like arantor said.

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,187
  • Gender: Male
    • Macedonian electronics forum
Re: Missing posts for ~ 2 months!!!
« Reply #13 on: November 05, 2019, 11:30:03 AM »
This could easily be done with cron jobs, even if no automatic backup option is available on your host's control panel ;). If you have a cron jobs option in you CP, you can do it yourself, no need to pay extra ;).
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,676
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Missing posts for ~ 2 months!!!
« Reply #14 on: November 05, 2019, 04:11:50 PM »
I also suggest downloading a copy of your backups at least once a month to your pc as well.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,187
  • Gender: Male
    • Macedonian electronics forum
Re: Missing posts for ~ 2 months!!!
« Reply #15 on: November 06, 2019, 10:53:14 AM »
^^^ Agreed ;).
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."