Re: [Mrbs-general] Upgrade problems

[Mark B. <mar...@lt...>]

Dan Swan wrote:
> 
> I restored the mrbs tables from the previous nights backup but this
> has failed to improve the situation :-/  I get the feeling that
> whatever I have done has terminally wrecked that database!

I'm a bit mystified that your backups did not fix the problem.

> 
> So 2 questions:
> 
> 1) is there a 'quick fix'? I would prefer *not* to lose the data in
> the tables
> 2) failing that is there a way I can export the mrbs_room/area tables
> from one mysql database to another?

Something like this where the good database is GoodDB and the bad one
is BadDB

1. Dump the good data
  # mysqldump -u root -pYourPassword -h YourHost GoodDB mrbs_room > /tmp/sql.tmp
  # mysqldump -u root -pYourPassword -h YourHost GoodDB mrbs_area > /tmp/sql.tmp
2. Blow away the bad data
  # mysql -u root pYourPassword -h YourHost BadDB 
  mysql> drop table mrbs_room
  mysql> drop table mrbs_area
3. Import the new data
  # mysql  -u root -pYourPassword -h YourHost BadDB < /tmp/sql.tmp

By the way, you can back up an entire database using:

mysqldump -u root -pYourPassword -h YourHost GoodDB > /tmp/sql.tmp

-Mark





> 
> As you may have noticed my mySQL skills are somewhat limited :-)
> 
> cheers for your help,
> 
> Dan
> --
> Dr Dan Swan,
> Bioinformatician
> 
> for the Barts and the London Genome Centre
> 
> For more information about the Genome Centre and
> contact details see http://www.mds.qmw.ac.uk/gc/
> 
> _______________________________________________
> Mrbs-general mailing list
> Mrb...@li...
> http://lists.sourceforge.net/lists/listinfo/mrbs-general

-- 
Mark Belanger
LTX Corporation