oops, should have changed the subject
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Shih Ming-Wei
Sent: Thursday, May 06, 2004 17:25
To: DBMail mailinglist
Subject: RE: [Dbmail] SMTP Auth
Last week our mail server with innodb got corrupted,
neither the server nor did mysqld crash, so this
might be a mysql bug. Anyway mysqldummp won't dump
anything from messageblks and I found an other (slow)
way to get the data which aren't corrupted yet.
I recovered more 99% of the mails, lost like 1-2 hour mails instead of
17GB
put this line in the my.cnf
innodb_force_recovery=4
then use the following instruction (replace messageblks
with the table which is corrupted)
mysql> SELECT * INTO OUTFILE '/data/dump'
-> FIELDS TERMINATED BY ','
-> OPTIONALLY ENCLOSED BY '"'
-> LINES TERMINATED BY '\n'
-> FROM messageblks;
mysql> LOAD DATA INFILE '/data/dump' INTO TABLE messageblks
-> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
-> LINES TERMINATED BY '\n';
Hope this can help someone in the future
Ming-Wei
_______________________________________________
Dbmail mailing list
[email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
