Re: mysql 4.0.18 crashing on startup

2005-03-04 Thread Baba Buehler
Heikki Tuuri wrote: Baba, an undo log seems to be corrupt. He should restart mysqld with: innodb_force_recovery=4 dump all tables, and recreate the whole InnoDB installation. This was roughly my assessment and recommended procedure as well. The customer decided to restore the system from a full b

Re: mysql 4.0.18 crashing on startup

2005-03-03 Thread Heikki Tuuri
Baba, an undo log seems to be corrupt. He should restart mysqld with: innodb_force_recovery=4 dump all tables, and recreate the whole InnoDB installation. Did the .err log contain any hint what could be behind the corruption? Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and ro