Welcome to WebmasterWorld Guest from 54.161.64.174

Forum Moderators: LifeinAsia & httpwebwitch

Message Too Old, No Replies

Hosting Company SQL Upgrade Corrupts Sites

SQL Upgrade Corrupts Sites

     
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.
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
8:10 pm on Mar 24, 2011 (gmt 0)

WebmasterWorld Administrator brotherhood_of_lan is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



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.
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.
10:57 am on Mar 25, 2011 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Did anybody run the MySQL upgrade [dev.mysql.com]?
9:09 pm on Apr 6, 2011 (gmt 0)

5+ Year Member



"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.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month