InnoDB restore from crash machine.

My OS crash today and i had to reinstall mysql server. I am using Windows 2003 (quite old  😉
There are a few things happen when i reinstall the mysql , and it happens at the “instance” configuration step.

1. Canot find my-template.ini ,

=> Fix: copy my-template.ini to bin/ directory

2. Can not start service

It’s because the mysql path in Services is not correct : C:\Program Files\MySQL\MySQL Cluster 5.5\bin\bin\mysqld” –defaults-file=”H:\Program Files\MySQL\MySQL Cluster 5.5\bin\my.ini”  MySQL

=> open registry , go to HKLM \ System\Current Control Set1\ Services

Locate mysql , and update the path

=> Try to restart , if you still can not start it , delete 2 files ib_logfile0 and ib_logfile1

3. I moved all my folders in my old “data” mysql to new location, but only MyIsam table is OK, all Innodb table is disappear.

I copy ibdata1 from my old sql server to new server – and it fixed.

(Remember to check the old my.ini  , check this parameter “innodb_data_home_dir=”H:/MySQL Datafiles/”

– If you change this parameter in the new my.ini , make sure that you copy the  “ibdata1” in your old “innodb_data_home_dir” to your new “innodb_data_home_dir”

PS: MyISam table is easy to recover , just copy the folder and it will work everywhere , InnoDB is on the other end,  it’snot easy to recover.

Leave a Reply

Your email address will not be published. Required fields are marked *