retrieving table data from MySQL

Hi

I have MySQL Server 5.0 on my machine and I am trying to retrieve data
stored in a table. However if I try doing a mysqldump on the database where
the table is stored then the MySQL server crashes. The table has around 10
fields in the table. So I am able to execute the following commands
successfully:

show columns from table x; (assuming table name is x)
select field1 from x;
select field2 from x;
select field3 from x;
select field4 from x;
select field10 from x;

However the following commands cause the server to crash:

select * from x;
select field5 from x;
select field6 from x;
select field7 from x;
select field8 from x;
select field9 from x;

So basically I have been able to retrieve the schema for the table and the
entries for the fields (field1,field2,field3,field4,field10) but I am not
able to retrieve the data in the other fields. Therefore my question is:

Is there a way that I can backup/dump data in this table? A look at the logs
revealed the following error:

InnoDB: Error in pages 609 and 610 of index PRIMARY of table mt/mt_entry
InnoDB: records in the wrong order on adjacent pages

Presumably data has been entered in the wrong format due to poor design of
the database schema. But is there a workaround to this? Any help/hints would
be highly appreciated. Thanks

Navodit wrote:
> Hi
>
> I have MySQL Server 5.0 on my machine and I am trying to retrieve data
> stored in a table. However if I try doing a mysqldump on the database where
> the table is stored then the MySQL server crashes. The table has around 10
> fields in the table. So I am able to execute the following commands
> successfully:
>
> show columns from table x; (assuming table name is x)
> select field1 from x;
> select field2 from x;
> select field3 from x;
> select field4 from x;
> select field10 from x;
>
> However the following commands cause the server to crash:
>
> select * from x;
> select field5 from x;
> select field6 from x;
> select field7 from x;
> select field8 from x;
> select field9 from x;
>
> So basically I have been able to retrieve the schema for the table and the
> entries for the fields (field1,field2,field3,field4,field10) but I am not
> able to retrieve the data in the other fields. Therefore my question is:
>
> Is there a way that I can backup/dump data in this table? A look at the logs
> revealed the following error:
>
> InnoDB: Error in pages 609 and 610 of index PRIMARY of table mt/mt_entry
> InnoDB: records in the wrong order on adjacent pages
>
> Presumably data has been entered in the wrong format due to poor design of
> the database schema. But is there a workaround to this? Any help/hints would
> be highly appreciated. Thanks
>
>

Actually, this looks more like the file itself has been corrupted. Even
entering data in the wrong format won't give this error.

I don't know of any way to recover from this type of problem other than
to restore from backup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:TbudnexSB7PsQ3vYnZ2dnUVZ_tTinZ2d@comcast.com. ..
> Navodit wrote:
>> Hi
>>
>> I have MySQL Server 5.0 on my machine and I am trying to retrieve data
>> stored in a table. However if I try doing a mysqldump on the database
>> where the table is stored then the MySQL server crashes. The table has
>> around 10 fields in the table. So I am able to execute the following
>> commands successfully:
>>
>> show columns from table x; (assuming table name is x)
>> select field1 from x;
>> select field2 from x;
>> select field3 from x;
>> select field4 from x;
>> select field10 from x;
>>
>> However the following commands cause the server to crash:
>>
>> select * from x;
>> select field5 from x;
>> select field6 from x;
>> select field7 from x;
>> select field8 from x;
>> select field9 from x;
>>
>> So basically I have been able to retrieve the schema for the table and
>> the entries for the fields (field1,field2,field3,field4,field10) but I am
>> not able to retrieve the data in the other fields. Therefore my question
>> is:
>>
>> Is there a way that I can backup/dump data in this table? A look at the
>> logs revealed the following error:
>>
>> InnoDB: Error in pages 609 and 610 of index PRIMARY of table mt/mt_entry
>> InnoDB: records in the wrong order on adjacent pages
>>
>> Presumably data has been entered in the wrong format due to poor design
>> of the database schema. But is there a workaround to this? Any help/hints
>> would be highly appreciated. Thanks
>>
>>
>
> Actually, this looks more like the file itself has been corrupted. Even
> entering data in the wrong format won't give this error.
>
> I don't know of any way to recover from this type of problem other than to
> restore from backup.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================

Can you please elaborate on how to "restore from backup"? I am not sure how
to go about that since I am not able to take backup via mysqldump. Is there
another way to take the backup?

Navodit wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:TbudnexSB7PsQ3vYnZ2dnUVZ_tTinZ2d@comcast.com. ..
>> Navodit wrote:
>>> Hi
>>>
>>> I have MySQL Server 5.0 on my machine and I am trying to retrieve data
>>> stored in a table. However if I try doing a mysqldump on the database
>>> where the table is stored then the MySQL server crashes. The table has
>>> around 10 fields in the table. So I am able to execute the following
>>> commands successfully:
>>>
>>> show columns from table x; (assuming table name is x)
>>> select field1 from x;
>>> select field2 from x;
>>> select field3 from x;
>>> select field4 from x;
>>> select field10 from x;
>>>
>>> However the following commands cause the server to crash:
>>>
>>> select * from x;
>>> select field5 from x;
>>> select field6 from x;
>>> select field7 from x;
>>> select field8 from x;
>>> select field9 from x;
>>>
>>> So basically I have been able to retrieve the schema for the table and
>>> the entries for the fields (field1,field2,field3,field4,field10) but I am
>>> not able to retrieve the data in the other fields. Therefore my question
>>> is:
>>>
>>> Is there a way that I can backup/dump data in this table? A look at the
>>> logs revealed the following error:
>>>
>>> InnoDB: Error in pages 609 and 610 of index PRIMARY of table mt/mt_entry
>>> InnoDB: records in the wrong order on adjacent pages
>>>
>>> Presumably data has been entered in the wrong format due to poor design
>>> of the database schema. But is there a workaround to this? Any help/hints
>>> would be highly appreciated. Thanks
>>>
>>>
>> Actually, this looks more like the file itself has been corrupted. Even
>> entering data in the wrong format won't give this error.
>>
>> I don't know of any way to recover from this type of problem other than to
>> restore from backup.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstucklex@attglobal.net
>> ==================
>
> Can you please elaborate on how to "restore from backup"? I am not sure how
> to go about that since I am not able to take backup via mysqldump. Is there
> another way to take the backup?
>
>

No, you'd have to restore from a *previous backup* - one taken before
the problem occurred.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Navodit wrote:

> Hi
>
> I have MySQL Server 5.0 on my machine and I am trying to retrieve data
> stored in a table. However if I try doing a mysqldump on the database
> where the table is stored then the MySQL server crashes. The table has
> around 10 fields in the table. So I am able to execute the following
> commands successfully:
>
> show columns from table x; (assuming table name is x)
> select field1 from x;
> select field2 from x;
> select field3 from x;
> select field4 from x;
> select field10 from x;
>
> However the following commands cause the server to crash:
>
> select * from x;
> select field5 from x;
> select field6 from x;
> select field7 from x;
> select field8 from x;
> select field9 from x;
>
> So basically I have been able to retrieve the schema for the table and the
> entries for the fields (field1,field2,field3,field4,field10) but I am not
> able to retrieve the data in the other fields. Therefore my question is:
>
> Is there a way that I can backup/dump data in this table? A look at the
> logs revealed the following error:
>
> InnoDB: Error in pages 609 and 610 of index PRIMARY of table mt/mt_entry
> InnoDB: records in the wrong order on adjacent pages
>
> Presumably data has been entered in the wrong format due to poor design of
> the database schema. But is there a workaround to this? Any help/hints
> would be highly appreciated. Thanks


Have you tried REPAIRing the table?


--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png

"Brian Wakem" <no@email.com> wrote in message
news:54oigaF20lptrU1@mid.individual.net...
> Navodit wrote:
>
>> Hi
>>
>> I have MySQL Server 5.0 on my machine and I am trying to retrieve data
>> stored in a table. However if I try doing a mysqldump on the database
>> where the table is stored then the MySQL server crashes. The table has
>> around 10 fields in the table. So I am able to execute the following
>> commands successfully:
>>
>> show columns from table x; (assuming table name is x)
>> select field1 from x;
>> select field2 from x;
>> select field3 from x;
>> select field4 from x;
>> select field10 from x;
>>
>> However the following commands cause the server to crash:
>>
>> select * from x;
>> select field5 from x;
>> select field6 from x;
>> select field7 from x;
>> select field8 from x;
>> select field9 from x;
>>
>> So basically I have been able to retrieve the schema for the table and
>> the
>> entries for the fields (field1,field2,field3,field4,field10) but I am not
>> able to retrieve the data in the other fields. Therefore my question is:
>>
>> Is there a way that I can backup/dump data in this table? A look at the
>> logs revealed the following error:
>>
>> InnoDB: Error in pages 609 and 610 of index PRIMARY of table mt/mt_entry
>> InnoDB: records in the wrong order on adjacent pages
>>
>> Presumably data has been entered in the wrong format due to poor design
>> of
>> the database schema. But is there a workaround to this? Any help/hints
>> would be highly appreciated. Thanks
>
>
> Have you tried REPAIRing the table?
>
>
> --
> Brian Wakem
> Email: http://homepage.ntlworld.com/b.wakem/myemail.png

The table is an InnoDB table and not ISAM so I am not sure if this can be
done. Any ideas how to repair InnoDB tables? Thanks