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.
Maybe this software can help:
http://www.cpsitesaver.com
Its a backup tool for cPanel.
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.
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…
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.
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.
hey yuga that is scary stuff! i installed a backup plugin too, but i could not make it work!
yikes!
Backups from the console or if you don’t have access to it, using phpmyadmin work best.
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.
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.
thats scary then if cPanel is not backing up all the tables….
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.
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.
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?
Hi Abe… Is this scenario (missing tables in DB) also possible with WordPress, assuming also a 2GB cpanel backup?
So what failed? the cpanel backup? no weekly backups?