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

[weggingt at eggington.net]

>>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.

Will that restore phpMyAdmin?  I'd really like to get that up and running
so I can delete all the old databases before I try and restore again.  Its
just not coming up.  White screen. . . no life.   :-(