fbpx

When Backups Fail

Been up almost all night and all day, with but a couple of hours of rest. If you’ve noticed that Connie’s blog are gone, it’s because we’ve spent all hours fixing the whole database from last night.

Expression Engine recently released a free core upgrade and it was used on her blog. Unfortunately, the upgrade didn’t went well so we resorted to reloading the latest daily backup. That didn’t worked as well. We already had the help of one of the guys from EE (the main developer & CEO himself) but it turns out some of the tables in the DB were missing.

It’s a little tricky when you’re dealing with almost 2GB of cPanel backup and it runs on Expression Engine (something I don’t really like and understand as a blog CMS). I had to resort to using an old backup from another server but that was 3 months ago (this is the 4th copy of the redundant backups).

That should do for the meantime untIl we find a solution to this problem.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 984 other subscribers
Avatar for Abe Olandres

Abe is the founder and Editor-in-Chief of YugaTech with over 20 years of experience in the technology industry. He is one of the pioneers of blogging in the country and considered by many as the Father of Tech Blogging in the Philippines. He is also a technology consultant, a tech columnist with several national publications, resource speaker and mentor/advisor to several start-up companies.

18 Responses

  1. Avatar for Bangis Bangis says:

    Maybe this software can help:

    http://www.cpsitesaver.com

    Its a backup tool for cPanel.

  2. Avatar for luv2ride luv2ride says:

    Can I assume by this article you were able to recover some of your data but not all? Did you actually make the conversion to wordpress and import all the data you had left from EE? If so would you care to share how you did the import and conversion. I would love to get all my EE data imported to WordPress.

  3. Avatar for demonhale demonhale says:

    by anychance a weblog be backed-raw by copying the files on your public folder then restoring it later, and all the way downloading a db backup on your cpanel and restoring it too?

    If that isnt the case, well better use a flatfile instead…

  4. Avatar for Abe Olandres Abe Olandres says:

    I sent out a bug report (if indeed it is) to cPanel developers. Also I have reverted back the PHP version to 4.3.x from 4.4.x as EE was not compatible with it. Found that out when I upgraded PHP where PinoyBlog was installed a week back.

    Ahhh… I need sleep. The last 48 hours was a nightmare.

  5. Avatar for gabriel gabriel says:

    man what a nightmare that must be. ms. connie must be all nerves right now.

    From your description it seems that something happened between the time of the working backup to present that usually requires some update to the db and/or the sql file. If nothing of the sort happened, then that means someone goofed and just changed the schema without telling anyone, hence making backups useless.

    btw its certainly not the first cpanel horror story i’ve heard. anyway good luck.

  6. Avatar for mell ditangco mell ditangco says:

    hey yuga that is scary stuff! i installed a backup plugin too, but i could not make it work!
    yikes!

  7. Avatar for vern vern says:

    Backups from the console or if you don’t have access to it, using phpmyadmin work best.

  8. Avatar for Manuel Viloria Manuel Viloria says:

    Thanks for the info, Abe. Looks like I shouldn’t throw out those old static html blogging packages. It’s easier to make back-ups of those given cPanel quirkiness.

  9. Avatar for Abe Olandres Abe Olandres says:

    Yay, yes. We’re only upgrading to the latest stable version of cPanel, no less, so this could be a major bug or something if it’s true.

  10. Avatar for kzap kzap says:

    thats scary then if cPanel is not backing up all the tables….

  11. Avatar for Abe Olandres Abe Olandres says:

    The compressed backup is just actually 300MB but the total files of the restored account is abour 1.8GB. The total mySQL data is just in the region of 250MB.

    My theory is that cPanel may not be completing the backups or something.

    @ Manuel

    Could happen to any web app with that figure.

  12. Avatar for Abe Olandres Abe Olandres says:

    She did an EE backup last night. It didn’t went thru smotthly so she asked that I restore to the lastest daily backup. When I did, it wouldn’t work as well. We asked help from EE support and they found out that some of the tables in the EE db were missing.

    I then tried the weekly backup (done 5 days ago). Didn’t work. I tried the monthly – didn’t work as well. There wree all missing the tables, esp. the blog entry table. I checked the individual mySQL files and tried restoring them from SSH but a 170+ MB DB only came out 90+ after restore. I opened the mysql file and check on the entries and it was missing the blog entry tables.

    Last August, before we moved the acocunt to a dedicated server, I left an old cPanel backup. That one came out fine.

  13. Avatar for Manuel Viloria Manuel Viloria says:

    Wait… the latest daily backup did not work, but the 3 month old backup did?

    Does that mean the issue is with the data backup integrity and not with EE?

  14. Avatar for Manuel Viloria Manuel Viloria says:

    Hi Abe… Is this scenario (missing tables in DB) also possible with WordPress, assuming also a 2GB cpanel backup?

  15. Avatar for kzap kzap says:

    So what failed? the cpanel backup? no weekly backups?

Leave a Reply
JOIN OUR TELEGRAM DISCUSSION

Your email address will not be published. Required fields are marked *