[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