Migrating from MySQL 5.0.41 to 5.1.44

[Eric Cope]

its complicated by the fact that is on my Mac and i use MAMP...
I''ll play around with mysql-upgrade...

Thanks,
Eric

On Tue, Jul 27, 2010 at 10:25 AM, Stephen <cryptworks at gmail.com> wrote:

> I was wondering why an upgrade was not an option.
>
> On Tue, Jul 27, 2010 at 9:10 AM, Bryan O'Neal
> <Bryan.ONeal at theonealandassociates.com> wrote:
> > It is possible to do this but is is not as easy as you may think it
> > will be. You will have to apply the insert query's from the dump one
> > at a time by hand and see what fails and make corrections. Even then I
> > would just back it all up and run mysql-upgrade.
> >
> > On Tue, Jul 27, 2010 at 9:06 AM, Alex Dean <alex at crackpot.org> wrote:
> >>
> >> On Jul 27, 2010, at 12:46 AM, Eric Cope wrote:
> >>
> >>> Hello all,
> >>> I am upgrading my MySQL test server from 5.0.41 to 5.1.44. Is there any
> >>> reason I can't just dump all databases in phpmyadmin including mysql
> and
> >>> information_schema and import them into the new database?  Copying the
> other
> >>> databases is easy, I just don't want to have to go and re-grant all the
> >>> different users to all the different databases.
> >>
> >> I don't think you can import information_schema.  IIRC, it's like the
> /proc
> >> filesystem, created by the system to give you a convenient way to access
> >> data.  I think you can just let the upgraded server create this data.
> >>
> >> For the 'mysql' database, new tables & columns may have been added in
> 5.1.
> >>  There were new things added in 4.0, 4.1 and 5.0, and you don't want to
> miss
> >> those.  But you can run a post-upgrade script which will check your
> 'mysql'
> >> database and create any missing priv columns.
> >>
> >> http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html
> >> http://dev.mysql.com/doc/refman/5.1/en/upgrading.html
> >>
> >> The docs are good.  Use 'em!
> >>
> >> alex
> >> ---------------------------------------------------
> >> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> >> To subscribe, unsubscribe, or to change your mail settings:
> >> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> >>
> > ---------------------------------------------------
> > PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> > To subscribe, unsubscribe, or to change your mail settings:
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> >
>
>
>
> --
> A mouse trap, placed on top of your alarm clock, will prevent you from
> rolling over and going back to sleep after you hit the snooze button.
>
> Stephen
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20100727/46e74da0/attachment.html>