[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Mysql database dump quit working



On Wed, 2014-04-23 at 22:13 +0100, Steve wrote: 
> > I have a mediawiki site running on Mysql db; I just started getting this
> > message on my automated backup;
> > 
> > mysqldump: Got error: 144: Table './mywiki/searchindex' is marked as
> > crashed and last (automatic?) repair failed when using LOCK TABLES
> 
>   The table is marked as crashed, and an automatic attempt to repair
>  failed.
> 
>   Use the MySQL command-line client to repair the table manually:
> 
>     mysql --user=root --pass
>      > USE mediawiki ;    - Or whatever your DB is called
>      > REPAIR TABLE `searchindex`;
> 
>   If that fails you should restore your backup.  
> 
> > Any ideas?
> 
>   Wasn't the message clear?  If not you might wish to submit a bug
>  report to the MySQL people to suggest alternative wording which
>  makes the problem more explicit.
> 
> Steve
Hey Thanks: 
That did the trick
john


Reply to: