[BlueOnyx:04023] Re: migration mySQL problems :-(

[Ken Marcus - Precision Web Hosting, Inc]

----- Original Message ----- 
From: <weggingt at eggington.net>
To: "BlueOnyx General Mailing List" <blueonyx at blueonyx.it>
Sent: Saturday, March 13, 2010 6:17 PM
Subject: [BlueOnyx:04020] Re: migration mySQL problems :-(


> This is my forth time trying to migrate over from BQ to BO.  Each time it
> is the mySQL stuff that kills me.  creating a mysql account for "root"
> seems to cause major havoc but it is the way the instructions say to do it
> so. . . thats the way I try and do it.
>
> I think because mySQL on my old BQ server is much older than the one on BO
> it messes with all the tables and user permissions.  Doing the suggested
> scripts usually results in me getting locked out of phpMyAdmin and. . .
> once I'm locked out of that I'm hosed.  Have to start over again.
>
> I'm kind of at my wits end.   :-(
> _______________________________________________
>

Generally if you add the  --add-drop-table    then it won't get stuck as it 
is restoring.
And of course, the password after the restore will be the one from the old 
server.

----
Ken Marcus
Ecommerce Web Hosting by
Precision Web Hosting, Inc.
http://www.precisionweb.net