how can i update mysql 4.0 to mysql 5?

[pentium10]

On a Red Hat 9 OS, i have mysql 4.0 and i want upgrade to mysql 5.0 but i do not want to lose the mysql settings and the databases.

How can I do this?
I must change anything after upgrade in php or apache conf files?

Any help would be appreciate, i am newbie to linux conf. please answer with full shell commands.

[scm]

Have you been to the MySQL site and looked at their docs? http://dev.mysql.com/doc/mysql/en/up...-from-4-1.html might be a good place to start.

[pentium10]

I read that but no clear shell commands find out.
I deleted the old version and installed the 5, but now the phpinfo() function says that i am using mysql4.0, and the phpmyadmin says that i am using mysql5.........

What about this?

[KidCloudWala]

Greetings,

It means that your PHP is not being compiled with the MySQL 5.0 being installed and it still has the entry for the MySQL 4.0. Just upgrade the php-mysql thing as well and everything will be in sync.

Regards

[pentium10]

I installed php after mysql5 was installed but still reports mysql4 just on phpinfo();, because in myadmin says that is mysql5

How can i upgrade php-mysql thing?

Another question......
I have untar-t mysql5 but now do not work > service mysql start

How can I fix this?
What should i add and where?

[KidCloudWala]

Greetings,

First of all can u tell me that earlier you installed the mysql did u installed it using the tarball or thru the rpm.

Also, juts by untarring the mysql wwont make it work u need to build mysql all over again. In oreder to make it work properly.

Regards

[pentium10]

i do not used the rpm
just untar in /usr/local/mysql
after that ./bin/safe_mysqld &

[KidCloudWala]

Greetings,

When you run safe_mysqld you are running mysqld in the safe mode. Please refer to the following link to install and build mysql.
http://www.linuxguruz.com/z.php?id=31

This link will help you to install mysql, php and apache.

Also, read this again: http://dev.mysql.com/doc/mysql/en/up...-from-4-1.html

As it states that the 5.0 is still in the testing phase moreover can u tell what are you trying to acheive!!!!

Regards

[pentium10]

i installed stuff this way, but the: service mysql start doesn't works....

I need mysql5 for my new project where i need those new feature...

[KidCloudWala]

Greetings,

Can u please paste me the error message you are getting when you ar etrying to start the MySQL service.

Regards