Hello monty,
As I remember according to documentation MYSQL should support check
table on BDB tables:
`CHECK TABLE' only works on `MyISAM' and `BDB' tables. On `MyISAM'
tables it's the same thing as running `myisamchk -m table_name' on the
table.
Therefore it does not:
mysql> check table layers_la01.g00layers_stat_hits;
+---------------------------------+-------+----------+--------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
| |
+---------------------------------+-------+----------+--------------------------------------------------------+
| layers_la01.g00layers_stat_hits | check | error | The handler for the table
|doesn't support check/repair |
+---------------------------------+-------+----------+--------------------------------------------------------+
1 row in set (0.00 sec)
and this is also thrue for any table
mysql> create table t (t int) type=BDB;
Query OK, 0 rows affected (0.30 sec)
mysql> check table t;
+--------+-------+----------+--------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------+-------+----------+--------------------------------------------------------+
| test.t | check | error | The handler for the table doesn't support check/repair |
+--------+-------+----------+--------------------------------------------------------+
1 row in set (0.01 sec)
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
