copy mysql dbs from crashed disc

[thompom]

hi,

my laptop hd will no longer boot - so reinstalled on a fresh disk and now need to import 20+ dbs from old disc to new one.

can copy the data folder off old disc and it shows all db names in mysql server but there are no tables

can this be done?

thanks

 

[DonQuichote]

It can be done, and it is all in the manual, but you have to search for it. For instance for InnoDB:

http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html

As an alternative rescue path, you could try to download and burn the system rescue CD at

http://www.sysresccd.org/

(or "burn" it to a memory stick) and boot from that. You may be able to boot through to your laptop, or else be able to retrieve the complete data directory of the MySQL installation on it.

Good luck!


+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[thompom]

hi,
stopped the mysql service, then copied the whole mysql folder and restarted the service - 'seems' ok

thanks for your ideas tho

 

[DonQuichote]

If the new MySQL installation is newer than the old one, it might run OK but not support new features. In that case, the "mysql" needs to be updated with a script. See the upgrading section in the manual.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)