Hello,

Is there anyone who knows how to upgrade mysql3.23 to 4.0 with php installed ?

thanks.

Any control panels or anything? :)

any idea ?

in a nutshell , install mysql4 and run the permissions fixing scripts .

that's pretty much all i did . but the permission fixing scripts gave global 'create temporary tables' privleges to all the users , so i had to manually revoke the privlege from everyone .

I'm not sure if my memory serves me correctly, but use wget to get the rpm.

Then type: rpm -u ./MySQL-full-4.xx.xx.i386.rpm or something like that :)

got it done.
just for your reference.

rpm -Uvh MySQL-server-4.0.16-0.i386.rpm
rpm -Uvh MySQL-client-4.0.16-0.i386.rpm
rpm -Uvh MySQL-shared-compat-4.0.16-0.i386.rpm //this package also provide 3.23 interface for php 4.2.2,

so if you stay at php 4.2.2, this is ok for now. if you wanna upgrade to 4.34. you need to compile php with mysql's devel package.

cheers