Inoddb Database - table corrupt?

hello
im using a inoddb database, when i try to dump the database this error is
the result
--
mysqldump: Error 2013: Lost connection to MySQL server during query when
dumping
table `Attachments` at row: 166498
--

any ideas how i can fix it? i can edit and change the values in the row but
it does not fix the failure.

"richard" <fakeandspam@gmail.com> wrote in
news:b79fc$45f52e6d$506cda6b$11851@news.chello.at:

> hello
> im using a inoddb database, when i try to dump the database this error
> is the result
> --
> mysqldump: Error 2013: Lost connection to MySQL server during query
> when dumping
> table `Attachments` at row: 166498
> --
>
> any ideas how i can fix it? i can edit and change the values in the
> row but it does not fix the failure.

just a shot, but try increasing the max_packet_size in the configuration
file

hello
thx for your answer, i set it to max_allowed_packet=300M but the same
failure is coming again, is there a way to "check" how big the size should
be?

>
>> hello
>> im using a inoddb database, when i try to dump the database this error
>> is the result
>> --
>> mysqldump: Error 2013: Lost connection to MySQL server during query
>> when dumping
>> table `Attachments` at row: 166498
>> --
>>
>> any ideas how i can fix it? i can edit and change the values in the
>> row but it does not fix the failure.
>
> just a shot, but try increasing the max_packet_size in the configuration
> file

"richard" <fakeandspam@gmail.com> wrote in
news:d543f$45f67061$506cda6b$8830@news.chello.at:

> hello
> thx for your answer, i set it to max_allowed_packet=300M but the same
> failure is coming again, is there a way to "check" how big the size
> should be?

300M is more than enough, so that's not the problem. Google a bit about
"losing MySQL connection" in the middle of a dump.... the error message
says more about the server set-up than it does about the data being
corrupted (so far there is no reason to think it is corrupt).

"richard" <fakeandspam@gmail.com> wrote:

> im using a inoddb database, when i try to dump the database this error is
> the result
> --
> mysqldump: Error 2013: Lost connection to MySQL server during query when
> dumping
> table `Attachments` at row: 166498
> --

Error 2013 is a crashed MySQL server. Have a look at the mysqld error
log for a hint what went wrong.


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/