Welcome to WebmasterWorld Guest from 54.226.47.198

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)

New User

5+ Year Member

joined:Mar 24, 2011
posts:2
votes: 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)

Senior Member

joined:Dec 29, 2003
posts:5428
votes: 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)

Senior Member from GB 

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

joined:Jan 30, 2002
posts:4843
votes: 2


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)

New User

5+ Year Member

joined:Mar 24, 2011
posts:2
votes: 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)

Administrator

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

joined:July 31, 2003
posts:12541
votes: 1


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

New User

10+ Year Member

joined:July 31, 2006
posts: 39
votes: 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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members