Nilnandan wrote:
> Hello all,
>
> I have one server which has mysql 5.0.27 installed. There is one table named
> table1.
> that table has 122000 records..It has 114 fields and 22 indexes.
>
> Now this table always been corrupt. I have try to found the solution but i
> couldn't.
> Pls help me ASAP. I have used CHECK and REPAIR option I have given here the
> output.....
>
> 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Table 'table1' is marked as
> crashed and should be repaired
> 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Sort aborted
> >
How big is the index file? the data file?
Has either reached the file size limit of your filesystem,
or the default maximum MyISAM size?
--
Gerald L. Clark
Supplier Systems Corporation
