[mythtv-users] Corrupted database file

IvanK. chepati at yahoo.com
Mon Aug 23 12:55:45 EDT 2004


Jay,

this is a quick way to check your table's integrity.  This is what you'd get 
for a good table.

mysql> CHECK TABLE settings;
+----------------------+-------+----------+----------+
| Table                | Op    | Msg_type | Msg_text |
+----------------------+-------+----------+----------+
| mythconverg.settings | check | status   | OK       |
+----------------------+-------+----------+----------+
1 row in set (0.01 sec)

mysql> 

I can't show you what a corrupted table would should, but it will not have OK 
in Msg_text.

I do CHECK TABLE after REPAIR TABLE, just to make sure the table did get 
fixed.

IvanK.

On Monday 23 August 2004 12:45 pm, Jay R. Ashworth wrote:
> On Mon, Aug 23, 2004 at 12:28:08PM -0400, IvanK. wrote:
> > After that do CHECK TABLE <table>;
>
> can you expand on this?
> -- j


More information about the mythtv-users mailing list