I can't believe any host is still using mysql 3

Wow -- learn something new everyday.

I would be concerned about hosts that do this since they may not be patching the server software to the latest versions and you might have a whole bunch of security holes just waiting to be exploited.

IMHO -- UBBThreads needs to take advantage of features the majority of users will benefit from -- If this loses users who are using mySQL 3 maybe they need to stay with an old version of the forum for the old version of mySQL.

No offense meant to anyone just an interesting topic

a lot of hosts do it, some list them as legacy servers and leave it for users that don't know any better; gives them a way to charge you a maintenance/upgrade/migration fee when you complain...

I think you miss-understood my point though...

I have no problem, and in fact would love to upgrade to 4 or maybe even 5... But with core3 i can't.. I would have to upgrade my whole server OS to core4 or 5 at least to run sql 4 minimum.

My server runs a lot more sites than just this one, and i have seen server upgrades screw up a lot of tihngs in the past, so I am a bit gun shy of doing this just for the sake of running sql4 for this one site.

Why would you have to upgrade to core4 or core5? An upgrade in MySQL or any other system service don't require an entire server ugprade; just because the yum repository for your cpanel or distro doens't have a precompiled binary doesn't mean you can't upgrade the services...

True enough I suppose. Been down that road before though. I guess I get a bit cosy with yum because it handles all the dependancies etc very easily. Its a larger exercise doing it all by hand for sure. (And risking things breaking for a slightly but not fully familiar user of linux like myself.)

True, YUM does do a good job of auto-upgrading things; but if you'll notice its often many versions behind (for instance, I use YUM to upgrade my PHP4 install, the latest in the CENTOS repo is 4.3.9 wheras the latest in the 4.0 tree is 4.4.4)

An interesting thought I had, I'm not sure if YUM is capable of upgrading "major revisions" (as in from 4.x to 5.x); I say this meerely because I have several services installed that have version conventions like this however it doesn't upgrade them (such as PHP or even MySQL); likely theres an option somewhere, that or it'll just treat it as a new service (which would be bad)

I've been doing a lot of reading on this upgrade.. It seems there are some things I need to do to convert my DB's... ISAMS etc etc etc...

Kind of off topic, but if i back up all my db's then set up ver4 or ver5 then set up new DB's and restore the backed up data into those new DB's would that work as well?

Again sorry, i know this isnt a mysql support site

Same question here, Is it safe to update to a new Mysql version for a complete box?

Clicky Click May help ?

I've had no problems in upgrading MySQL; however you may with some systems that use a control panel such as Ensim, Plesk, or CPanel, in which you should check their site for how to upgrade.