Re: Migrating from MySQL 5.0.41 to 5.1.44

I was wondering why an upgrade was not an option.

On Tue, Jul 27, 2010 at 9:10 AM, Bryan O'Neal
<Bryan.ONeal@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@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
>



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