Using dumps are almost always the way to go, upgrading the datafiles
themselves is something you should avoid unless you are into heavy
wizardry and/or pain.
Dan Trainor wrote:
Martin Jespersen wrote:
Dan has a very good point, be mindfull of the changed password
algorithm, that actually was a bit of a bother to me since i have tons
of users defined in my grant tables.
Dan Buettner wrote:
Dan, I wouldn't bother with the intermediate steps (4.0, 4.1) . Waste
of time (fine products, but you say you want to go to 5.0). I'd go
direct to 5.0, using mysqldump'd data as Martin did. If you're
all-MyISAM then it might also work to simply upgrade your binaries and
keep your data files, though you'll want to watch for the fix
permissions script and also be mindful of the password changes that
came about with 4.1.
Dan
On 7/13/06, Martin Jespersen <[EMAIL PROTECTED]> wrote:
I recently upgraded from 3.23.58 -> 4.1.20 without any hickups.
I simply dumped my databases with mysqldump on the 3.23.58 installation
and imported them again from inside the mysql client by using the
"source" command.
Dan Trainor wrote:
> Hi -
>
> I know we've rolled this around the list a few times, but I was
> wondering if there's been any real development on the subject
lately. I
> know half of you are saying "Forget it... go with a newer version and
> get over it", and I'd really really like to, but i have a lot of data
> store under 3.23.x.
>
> The documentation says that you must follow 3 -> 4.0 -> 4.1 -> 5.0
...
> ..., and that's just what I'm about to do.
>
> I guess what I'm looking for here is some advice from people who have
> done it. If there's not an all-in-one silly stupid way to upgrade
the
> data in this manner (i.e. with one fell swoop of some handy dandy
> application), would someone on an RPM-based system simply upgrade
RPMs
> in sequential order as indicated, and hope that the data follows? Is
> this probably one of the more successful ways of doing this?
>
> I'm still exploring my options, but I think that's what I'm going
to end
> up going with here - one step at a time.
>
> If you guys wouldn't mind terribly talking about this for a few more
> posts, I (and hopefully others) would greatly appreciate it.
>
> Thanks for the time
> -dant
>
--
Hi -
Well, I've been trying a few things with this, however I can't quite
seem to get to the point where this would be any easier.
The problem is, I only have data files. I don't have a MySQL dump, and
don't see myself being able to grab a dump anytime soon. So I guess
what I'm faced with now is bringing up a 3.23.58 server anyway, if only
for the purpose of a massive MySQL dump.
How's that sound?
Thanks!
-dant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
