Re: Migrating from MySQL 5.0.41 to 5.1.44

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@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@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@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss