my host wont upgrade to mysql 5 what to do? Is there some law or guide line that I can use against my host to upgrade to newer technology?

I sent them an email and this is what I got back :

Hi Barry

MySQL 4.1.7 is the version on our server and unfortunately I have
roadmap as to when this will be upgraded.

Our engineers have mentioned that the new release will cause issues with
some sites on our shared hosting. If you really need mysql 5, we would
advise a virtual server where you have full control of your hosting.

change hosts or get a dedicated server

Hello,

The only thing you really can do is either find another shared host that has MySQL 5 installed or find a VPS/dedicated provider.

Good luck!
Jack

Here's a few things that can happen on "upgrades"
http://www.webmaster-talk.com/php-fo...p-upgrade.html
http://www.webmaster-talk.com/php-fo...functions.html

And here's why host are reluctant to upgrade.
http://www.webmaster-talk.com/web-ho...5-3-hosts.html

You must be joking...Does your existing website uses older version than 5? Then I guess you should try to change web hosting company which would have decent version of MySQL.

Originally Posted by audiomad

my host wont upgrade to mysql 5 what to do? Is there some law or guide line that I can use against my host to upgrade to newer technology?

I sent them an email and this is what I got back :

Hi Audiomad.

If everything else suits your needs with your current hosting provider then you can ask if they have the other shared server(s) - with MySQL 5. Maybe they can transfer your account to the server with MySQL 5.

We're currently running 5.0.89 and haven't experienced any problems.

We have used 5.0.89 too and all works well.

I agree with someone who recommended moving to the new web hosting provider. That would be the best step if your own web host do not want to do that or refuse to do that.

I suppose I will have to move to a new host it seems to be to much work for my hosting provider to upgrade.

Is there some law or guide line that I can use against my host to upgrade to newer technology?

No, there isn't. You bought a service with certain specifications. It could be considered "bad" if they decided to upgrade without any sort of notification. It can't be considered "bad" if they decide they will stick to the service as it is.

Their suggestion for a VPS sounds more of a way of retaining you as a customer and upsell at the same time. You just need to find a different host, there's no reason to increase your costs.

If you are no longer untested in the configuration which web hosting provider provided for you you can shift to another web host easily.

Your web host might have several servers and they may move your account to the server where needed Mysql is installed. In other case you will need to move to the new provider.

Originally Posted by WebhostGIANT-Rob

Your web host might have several servers and they may move your account to the server where needed Mysql is installed. In other case you will need to move to the new provider.

Good Idea unless web hosting has only one VPS account in the pocket