Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Upgrading Mysql!! Pls Help

Status
Not open for further replies.

Bernini

Programmer
Oct 26, 2004
98
MT
Hi all

I have installed FC3, ahvinf PHP 4.3.9 and Mysql 3.23.58! Now i would like to upgrade mysql to version 5? what are the procedures i should take in doing so; so it could work with the current php setup and apache 2 setup!

Tahnks in advance
B
 
Get the new rpms and do 'rpm -U MySQL-*.rpm', at least that's what I did to get to 4.1.10
 
Or download the source, unpack it and do a

./configure --prefix=/usr/local/mysql5
make
make install

Then you can have MySQL 3.23 and MySQL 5 co-existing. To move your data across you would back it up from MySQL3 and restore it into MySQL5. Should be seamless but the syntax might be different.

Once issue I have found is that FC2 (and RHEL3) both decided to stick MySQL files all over the disk. That is why for my production systems I used the method above. I had more control over where things went.
 
Thanks Castor66...installed mysql5 now!

So, how can i make php use mysql5 client rather than the mysql3.23?

Thanks
B
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top