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 wrote: > I was wondering why an upgrade was not an option. > > On Tue, Jul 27, 2010 at 9:10 AM, Bryan O'Neal > 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 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 >