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

[Ken Marcus - Precision Web Hosting, Inc]

----- Original Message ----- 
From: <weggingt at eggington.net>
To: <jeffrey at px2co.net>; "BlueOnyx General Mailing List" 
<blueonyx at blueonyx.it>
Sent: Thursday, March 11, 2010 10:29 PM
Subject: [BlueOnyx:03982] migration mySQL problems :-(


>I was having a lot of problems with my bluequartz server so I decided to
> upgrade to blueonyx by migrating over to a new machine.  I used the
> raqbackup and restore procedure but it didn't work so great the first 
> time.
> Some of the backup files were corrupt or something so I re-ran the backup
> on the old bluequartz server, deleted all the virtual sites on blueonyx 
> and
> did everything again only this time using the -n option for cmuImport.
> Everything worked great this time until I got to the /usr/bin/mysql -root
> -ppasswordofmysql <hostname.of.source.mysqldump.sql step.
>
> It just wont' let me copy over or replace what is there from the old/bad
> restore.   :-(
>
> So then I tried to go in through phpmyAdmin but it won't load in the
> blueOnyx interface!  It just remains white and I get the message saying
> "loading from www.servername.com".  So things have gotten messed up there.
> :-(
>
> Is there a way to MAKE it load?  Maybe nuke mysql and re-install it?  How
> would you guys recommend I get around this?
>


In your raqbackup on the old server try changing the line
$MYSQLDUMP --all-databases
to
$MYSQLDUMP --all-databases --add-drop-table

That should make it easier to restore.


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