How about mysqldump? Stephen Hitchner wrote:
A table using Berkeley Tables should have 55000 records. The mysql server
crashed.
When running this query:
select id from customers;
returns 16000 records
running:
select count(id) from customers;
returns 16000 records
however running a specific query on an specific id i.e.
select * from customers where id = 6243655;
returns a valid record with data.
when scrolling through the above query records this id does NOT exist.
The data I need to recover is *there* and seems to be accessible only
through a direct query.
It seems like the indexing for this table is corrupt.
How do you repair an index on a DB Berkeley Table????
I can only find references to myiamchk which states is can only be used for
MyISAM tables?????
Any help would be GREAT!
cheers
steve
/************************************
* Stephen Hitchner
*
* Senior Developer
* Number 41 Media Corporation
* p 250.414.0410
* f 250.414.0411
* [EMAIL PROTECTED]
* www.number41media.com
*
*/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
