homepage Welcome to WebmasterWorld Guest from 50.19.199.154
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / WebmasterWorld / Professional Webmaster Business Issues
Forum Library, Charter, Moderators: LifeinAsia & httpwebwitch

Professional Webmaster Business Issues Forum

    
Hosting Company SQL Upgrade Corrupts Sites
SQL Upgrade Corrupts Sites
design4life




msg:4287011
 7:22 pm on Mar 24, 2011 (gmt 0)

Hi all,

A little advice please. On my instruction I asked my host to updgrade my sql to the latest stable version so I could run certain new components. I run a dedicated server with around 60 client sites. I did not want to do it myself as I feel I didn't have the time or technical ability to manage any issues.

The result of the host upgrading mysql corrupted my joomla based clients websites. They reversed the process which didn't resolve the issue and then upgraded again to a lower version of sql which got about 80% of my sites back online.

I now have problems with at least 20% of my clients sites and I'm being persued by one client for loss of earnings and they are going to pull my contract.

The problem sites are just displaying errors and upon looking into the sql tables, many are empty and without data.

I didn't have backups of the sites so I'm having to manually rebuild each one.

The hosting company did not take a backup before the upgrade.

I've got a huge amount of work to try and get my clients sites back up. My phone is on meltdown with complaints

Question is...is my host liable in any way for corrupting the data?

Any help is much appreciated.

 

walkman




msg:4287024
 7:53 pm on Mar 24, 2011 (gmt 0)

Your host probably made you agree not to hold them liable. And threatening your host now is the worst you could do, IMO. Ask nicely for their help

brotherhood of LAN




msg:4287033
 8:10 pm on Mar 24, 2011 (gmt 0)

upon looking into the sql tables, many are empty and without data.


Have you tried a REPAIR TABLE query on them? They may be corrupt but they may also be repairable.

design4life




msg:4287036
 8:25 pm on Mar 24, 2011 (gmt 0)

Thank you for your replies.

Yes I believe the terms of the host sites state they cannot be liable for data loss. Just reading through them...

Thank you brotherhood of LAN. I have tried a REPAIR TABLE with no luck. Most of the tables I require are actually empty.

I've tried to be nice for two days. I think that's all I can do. They have been helpful in the circumstances.

I trusted the compnay to be able to update for me but at the end of the day it was stupid of me not to take regular backups.

Regards.

coopster




msg:4287284
 10:57 am on Mar 25, 2011 (gmt 0)

Did anybody run the MySQL upgrade [dev.mysql.com]?

d3vrandom




msg:4293407
 9:09 pm on Apr 6, 2011 (gmt 0)

"I trusted the compnay to be able to update for me but at the end of the day it was stupid of me not to take regular backups."

Yeah and stupid of your clients to not do the same with their own sites.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Professional Webmaster Business Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved