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

[Chuck Tetlow]

If you're doing a complete move from BQ to BX - all databases and all users, use this:

BQ = mysqldump --opt --flush-logs --all-databases -u root -p > /home/cmu/alldatabases.dump

Then copy it across to the new BX server.  Set a MySQL root user password (same password as BQ box is easiest) in the BX GUI.  Then use:
cat /path/alldatabases.dump | mysql -u root -p

I used those exact two commands just a couple weeks ago to move everything from one server to the other.  Not a single problem with the MySQL databases.  And there were at LOT!  Most of the sites on that box were running Joomla and it had over 93 databases on it.

Only other thing to do besides that was cmuExport/cmuImport.  That was easy.

The one problem you might run into - the Joomla configuration file stores the absolute path in the configuration file for its logs and tmp directory.  It won't prevent Joomla and the sites from working, but they won't log correctly.  I wound up having to vi 62 configuration files to correct the absolute path (since the CMU utility doesn't preserve the /home/.sites/#/site# from the old server to the new).

Good luck.

Chuck

---------- Original Message -----------
From: <weggingt at eggington.net> 
To: BlueOnyx General Mailing List <blueonyx at blueonyx.it> 
Sent: Sat, 13 Mar 2010 19:17:37 -0700 
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.   :-( 
> _______________________________________________ 
> Blueonyx mailing list 
> Blueonyx at blueonyx.it 
> http://www.blueonyx.it/mailman/listinfo/blueonyx 
------- End of Original Message -------
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20100313/793499df/attachment.html>