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
