Bug #17479 DB corrupted after a failed restart by configuration wizzard
Submitted: 16 Feb 2006 16:08 Modified: 16 Feb 2006 16:30
Reporter: [ name withheld ] Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0 OS:Windows (Windows XP Por)
Assigned to: CPU Architecture:Any

[16 Feb 2006 16:08] [ name withheld ] 
Description:
After a successful install, configuration and test with two tables and 5 records in each, I wanted to reconfigure the erver using the wizzard. I added the TCP/IP capability.
At the end of the winzzard, it tryed to restart the server, but an error occured. (I don't remember).
I went in the Windows Services Window and I was unable to stop mySQL.
Afeter a restart, I was unable to restart MYSql server.
It says that the DB is corrupted.

I deleted the dir of my DB and the data files ibdata1. MYSql Server starts, but I can't create tables:
ERROR 1005 (HY000): Can't create table '.\test\myTable.frm' (errno: 150)

I must reinstall all MySQL Server.

How to repeat:
Unable to repeat.

Suggested fix:
I'm afraid, no idea.
[16 Feb 2006 16:30] MySQL Verification Team 
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

http://bugs.mysql.com/bug.php?id=17477