I'm using MySQL with BerkeleyDB tables because I need to make transaction. But sometimes one table loses its records. In phpmyadm the table looks to have 10000000 records but it will not return any records on select.
If I use "REPAIR TABLE tbl_name" I get the message "The handler for the table doesn't support check/repair" and when I use "OPTIMIZE TABLE tbl_name" phpmyadm will indicate 0 records for that table and so I lose all data.
Why this happen?
How can I avoid this to happen?
Where I am wrong?
