Hello.
Tools for MyISAM tables won't help you with InnoDB. See: http://dev.mysql.com/doc/mysql/en/gone-away.html iv <[EMAIL PROTECTED]> wrote: > hi > I've got a problem with a crushed innodb table (as i think) > > When I'm trying to make a backup, something like this appears: > mysqldump: Error 2013: Lost connection to MySQL server during query > when dumping table `adstats` at row 34342; > > trying to check table: > mysql> check table adstats extended; > ERROR 2013 (HY000): Lost connection to MySQL server during query > > repairing that: > mysql> repair table adstats; > phpads.adstats | repair | note | The handler for the table doesn't > support repair > the same is going on with "repair table ads_adstats USE_FRM" > > I have also tried mysqlchk and myisamchk with -r and -o options. It > didn't work, sinse that "adstats" is the innodb table.. > myisamchk: error: 'adstats.frm' is not a MyISAM-table > # mysqlcheck -r phpads adstats > note : The handler for the table doesn't support repair > > Any ideas how to deal with the problem? I have read through about a > hundred threads, but i haven't find a method of repairing innodb tables; > and only in one place I've found a problem similar to mine, but without > a solution > > Thanks in advance, > iv <iv at fnet dot pl> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
