Jump to content
  • entries
    948
  • comments
    5,905
  • views
    944,888

Alles Gute


Josh

3,266 views

The Leadwerks.com server started acting up earlier today, and I had no idea why. Database errors were occurring, and I had not made any changes to the site. I called our server site in Chicago. First they restored the full site from a backup from 2 A.M. yesterday morning. The matter was still not solved, though. A couple hours later, they determined that an automatic CPanel upgrade had caused PHP extensions to be loaded multiple times. This was fixed, and now we are back to normal. If you've been around a while, you know I have a big fear of data loss but it appears our procedures were able to solve the problem on our dedicated server. You get what you pay for. B)

11 Comments


Recommended Comments

Furbolg

Posted

Good to hear that but its also bad.

I have though you are releasing the Leadwerks3D Homepage + option to preorder the Upgrade :P

Canardia

Posted

It seems the backup still failed a bit, since not all new posts were restored.

I wonder why you need to even touch or restore the database, as the PHP code should be completely seperate from the SQLite3 database.

Also a professional restore should be never done per whole database, but rather write a PHP script which checks for individual records in the actual and backup and only fixes the differences.

Josh

Posted

It probably wasn't necessary to use the backup, since the problem was caused by the automatic CPanel upgrade, but that was just the first thing they tried. The backup is from yesterday morning around 2 A.M.

Pixel Perfect

Posted

All's well that ends well ... I can cope with losing a few hours worth of posts. These things happen from time to time.

Canardia

Posted

Why didn't they try on a test server first? You should never do anything in production, before you know what the problem is.

Eagle

Posted

Good to Hear Josh, that's pretty scary! :P

Josh

Posted

This actually makes me feel safer now because it proves our backup procedures work, which wasn't the case with our old host.

Canardia

Posted

Except when the guys restore a backup over a newer version which has not been backed up yet :P

Before I would restore a backup, I would take a backup of the current version first.

Josh

Posted

That's a good idea.

Scott Richmond

Posted

I have to agree with Metatron - Whilst it was a good news story in the end, thats a pretty bad way of troubleshooting and recovering from the issue.

I would be worried as to why the backup wasn't made before the cPanel upgrade - Everyone knows you do a backup before any update or upgrade.

Rekindled Phoenix

Posted

Shocked to see the PHP Config screen, as I was here with the recent data loss after the migration to the new site. I'm glad everything is resolved! Yaay for backups!

Guest
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...