On 6/25/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Good morning, all -
I've read for quite a while tonight, but still haven't been able to
figure out - can I upgrade directly from 3.23.58 to 5.0.22?
I've read that I'd have to do something like 3.23.58 > 4.0 > 4.1 >
5.0.22, but then also the 'mysql_upgrade' application which, as
documented, sounds like it can do magic things.
I strongly recommend you following this line. There were significant
changes between 3, 4, 4.1 and 5. I say that because I found many
problems, and 4 to 4.1 were a kinda messy upgrade. Folow:
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
And you should be fine (I didn't, hehe).
To be quite honest I'd like nothing more than to take a 'mysqldump' of
the database, and just re-import that, and run an app such as
'mysql_upgrade' against it and call it good.
Sorry, I don't think you can do that, the privileges table, for
instance, have changed a LOT, so, there's this fix_privileges script
on 4.1.
This will all be done on a pretty recent Linux distribution, CentOS 4.3.
Nothing out of the ordinary, but an upgrade such as this one is
definitely a bit out of my realm. I was able to do such an upgrade a
few weeks ago, but added stuff like permissions by hand - there were
only a few. However, for this particular instance, there's 250+ MySQL
users.
Anyone have any suggestions?
Upgrade to 4, then 4.1, then 5. Follow the above links, its quite fast
as you'll only be careful with things your particular system is
affected.
PS: BACKUP EVERYTHING!!! 2 copies are never too good!!!!
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
