OT: SCO Openserver 6 + MySQL

[Walter Vaughan]

Tyler wrote:

> Just a quick off topic question...does anyone know the best way to
> upgrade to MySQL v5 on Openserver 6?

http://dev.mysql.com/downloads/mysql/5.0.html#sco

Best way would be install Ubuntu/OpenSUSE/CentOS with mySQL5, dump the data from 
your mySQL4 box, and use that to import into your new 5 box.

You have to dump the data regardless going from 4 -> 5

You understand what I mean by dump is that you create an export of all your 
data. phpmyAdmin has a utility, as does webmin, and a few more commercial 
products that have lite editions for free that have the tools. You can also do 
it from the command line.

<flame mode on>
If you want a *real* database, and you are needing the functionality of mySQL5, 
then you *really* should be looking at postgreSQL. mySQL is a <toasty_flame 
mode> toy </mode> that acts like it can handle transactions. mySQL is excelent 
for read only and web page services, but I lost the faith after seeing first 
hand how you cannot trust your data in a transanctional environment.
YMMV
</flame mode off>

--
Walter