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.
YugaTech.com is the largest and longest-running technology site in the Philippines. Originally established in October 2002, the site was transformed into a full-fledged technology platform in 2005.
How to transfer, withdraw money from PayPal to GCash
Prices of Starlink satellite in the Philippines
Install Google GBox to Huawei smartphones
Pag-IBIG MP2 online application
How to check PhilHealth contributions online
How to find your SIM card serial number
Globe, PLDT, Converge, Sky: Unli fiber internet plans compared
10 biggest games in the Google Play Store
LTO periodic medical exam for 10-year licenses
Netflix codes to unlock hidden TV shows, movies
Apple, Asus, Cherry Mobile, Huawei, LG, Nokia, Oppo, Samsung, Sony, Vivo, Xiaomi, Lenovo, Infinix Mobile, Pocophone, Honor, iPhone, OnePlus, Tecno, Realme, HTC, Gionee, Kata, IQ00, Redmi, Razer, CloudFone, Motorola, Panasonic, TCL, Wiko
Best Android smartphones between PHP 20,000 - 25,000
Smartphones under PHP 10,000 in the Philippines
Smartphones under PHP 12K Philippines
Best smartphones for kids under PHP 7,000
Smartphones under PHP 15,000 in the Philippines
Best Android smartphones between PHP 15,000 - 20,000
Smartphones under PHP 20,000 in the Philippines
Most affordable 5G phones in the Philippines under PHP 20K
5G smartphones in the Philippines under PHP 16K
Smartphone pricelist Philippines 2024
Smartphone pricelist Philippines 2023
Smartphone pricelist Philippines 2022
Smartphone pricelist Philippines 2021
Smartphone pricelist Philippines 2020
kzap says:
So what failed? the cpanel backup? no weekly backups?
Manuel Viloria says:
Hi Abe… Is this scenario (missing tables in DB) also possible with WordPress, assuming also a 2GB cpanel backup?
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?
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.
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.
kzap says:
thats scary then if cPanel is not backing up all the tables….
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.
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.
vern says:
Backups from the console or if you don’t have access to it, using phpmyadmin work best.
mell ditangco says:
hey yuga that is scary stuff! i installed a backup plugin too, but i could not make it work!
yikes!
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.
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.
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…
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.
Bangis says:
Maybe this software can help:
http://www.cpsitesaver.com
Its a backup tool for cPanel.