Dear MR/Mrs/Ms, I working on a web project using PHP and MySQL with Berkeley DB support for database. It is my first time when I use BDB database type and I need it for transaction support. All look to be fine but sometime after few operation on database, not necessary transaction, I get message from phpmyadim that some tables have 10000000 records, even if those tables have under 1000 records, and any "SELECT" query on that tables will have no effect. 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. I want to know why this problem appear. It is possible to be my mistake or of those who offer hosting and database support? Please help me to avoid this to happen and keep my records safe.
Thank you very much. With respect, Marius Babuica. P.S. I already send this message to "Sleepycat Software" and I've got the following message: " Sleepycat Software doesn't maintain the MySQL interface to the Berkeley DB library, so I can't directly help you with this question. I'm told that the best place to ask MySQL questions is the general MySQL mailing list, [EMAIL PROTECTED]" __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.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
