NYCPHP Meetup

[Hans Zaunere]

--- ian forsyth <ian at plusfour.org> wrote:
> When upgrading to mysql 4 from 3.23.49.. do i have to recompile php?
> 
> I have checked out this link 
> http://www.mysql.com/doc/en/Upgrading-from-3.23.html..
> 
> I noticed some concerns on the mysql upgrade page about upgrading via
> 
> rpm under redhat 7.2. Would it be better to just unistall the rpm,
> then 
> compile, and install from the source?

There are some known problems with the compiler included in RH. 
(http://www.mysql.com/downloads/mysql-4.0.html).  And for production
level servers on Linux I always use MySQL's supplied binary (although
I've compiled a 3.x server on FreeBSD and have had no problems - then
again I did the same on a RH 6.2 server and had no problems, but Linux
[RH 7.x] makes me nervous).

> 
> Also we are using full text searching.. to do so with 4, and use
> boolean 
> searches would I have to rebuild all the tables, even if all our
> curent 
> table types are MyISAM..?

As noted in the 4.0 upgrade link, new fulltext indexes are used, so
you'll need to rebuild them.  Unless it's a huge DB, I always feel
better recreating/importing the whole tables - you never know what tiny
differences there are in the new handler code.

> We figure its a good idea to install mysql  max, are there any
> concerns going from 3.23.49 to 4.0.3 max?

I've heard/seen 4 to be pretty good, but I'm always paranoid about a
major version increase like that, so backup, backup and rebuild. :)

Hans 'Paranoid' Z.



__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com