List:General Discussion« Previous MessageNext Message »
From:Dehua Yang Date:October 19 2012 6:42am
Subject:Re: Table crashed error
View as plain text  
MyISAM storage tables  also have this kind of problem.

I have try serval solutions for this problem , but can't work  very well.

If your application isn't very import , you can let your application auto
repair this problem.
Just like this :
When your application catch this error information , run check table xxx.

The other solution is : Using InnoDB storage table.



On Fri, Oct 19, 2012 at 2:30 PM, Akshay Suryavanshi <
akshay.suryavanshi50@stripped> wrote:

> Hi,
>
> This table can be repaired using Repair table <table_name>; in mysql.
>
> This should fix the corrupted index file, or if mysql is shutdown, you can
> run myisamchk, also if its a myisam table.
>
> Hope this helps.
>
> Regards,
> Akshay S
>
> On Fri, Oct 19, 2012 at 11:52 AM, a bv <vbavbalist@stripped> wrote:
>
> > Hi on a log management server from the web interface i get the below
> > error . What can be the reason and how can i repair it ?
> >
> > Regards
> >
> >
> > Mysql_error: Table ./x/y ' is marked as crashed and should be repaired
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql
> >
> >
>



-- 
Gtalk : meflyingfish@stripped
Skype name : meflyingfish
Twitter: http://twitter.com/whitepoplar

Thread
Table crashed errora bv19 Oct
  • Re: Table crashed errorNitin Mehta19 Oct
  • Re: Table crashed errorAkshay Suryavanshi19 Oct
    • Re: Table crashed errorDehua Yang19 Oct
      • Re: Table crashed errorReindl Harald19 Oct
        • Re: Table crashed errorDehua Yang19 Oct