I have a database in which I have stored a lot of data, and as far as I know nothing has been deleted from it.
Yet when I do mysql> select * from bet; Empty set (1.42 sec) If I cd into the mysql data dir and do an ls -l on the tables [EMAIL PROTECTED] poker]# ls -l total 79600 -rw-rw---- 1 mysql mysql 23692724 Dec 12 07:36 bet.MYD -rw-rw---- 1 mysql mysql 11362304 Dec 12 07:36 bet.MYI -rw-rw---- 1 mysql mysql 8688 Dec 10 13:56 bet.frm They don't appear to be empty, which should be correct because as I say, noone has deleted them yet. The same also goes for the other tables in the database. Is there something else I can do to track down what may be going wrong? Thanks, John Hunter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
