[mythtv-users] Running optimize_mythdb.pl before mythfilldatabase

[Yeechang Lee]

Michael T. Dean <mtdean at thirdcontact.com> says:
> That's not optimize_mythdb.pl destroying data, that's MythTV trying
> to write data to a corrupt database--which meant the data was being
> destroyed on write (by MySQL, MyISAM, user-error for operating a
> database with corrupt tables, ... something that's not
> optimize_mythdb.pl).  Then, you eventually figured out it was
> corrupt and ran optimize_mythdb.pl and it fixed the tables.

I've been running optimize_mythdb.pl daily for months, and also run it
at bootup. The seektables for the recordings didn't get destroyed
until a) I had to hard reboot and b) the optimize_mythdb.pl run during
booting eliminated the corrupted databases, not before.



  However, the data 
> that was inserted into any corrupt tables /while/ they were corrupt was 
> already destroyed.
> 
> Mike
> 

-- 
Yeechang Lee <ylee at pobox.com> | +1 650 776 7763 | San Francisco CA US