BACKUP TABLE causes the error "The handler for the table doesn't support check/repair"

["Shailen Mistry" <SMistry@xxxxxxxxx>]

i am using MySQL version 3.23.33 and i created a database with one simple
table called "chapters"

according to http://www.mysql.com/doc/M/y/MyISAM.html
MyISAM is the default table type in MySQL Version 3.23

so the "chapters" table should be a MyISAM table.  i populated the table
with some information and would like to back it up.  i followed the
instructions at http://www.mysql.com/doc/B/A/BACKUP_TABLE.html (which says
backups will work for MyISAM tables)

when i do a the backup command
BACKUP TABLE chapters TO '~/www/Dbase/db/'
i get the error message "The handler for the table doesn't support
check/repair"

what am i doing incorrectly?  how do i fix this problem?

output is below.  - shailen


mysql> desc chapters;
+------------+---------------+------+-----+---------+----------------+
| Field      | Type          | Null | Key | Default | Extra          |
+------------+---------------+------+-----+---------+----------------+
| id         | tinyint(3)    |      | PRI | NULL    | auto_increment |
| country    | varchar(30)   | YES  |     | NULL    |                |
| state      | varchar(30)   | YES  |     | NULL    |                |
| chapter    | varchar(30)   | YES  |     | NULL    |                |
| contact    | varchar(75)   | YES  |     | NULL    |                |
| email      | varchar(75)   | YES  |     | NULL    |                |
| telephone  | varchar(75)   | YES  |     | NULL    |                |
| date_added | datetime      | YES  |     | NULL    |                |
| modified   | timestamp(14) | YES  |     | NULL    |                |
| comments   | varchar(120)  | YES  |     | NULL    |                |
| url        | varchar(75)   | YES  |     | NULL    |                |
+------------+---------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

mysql> BACKUP TABLE chapters TO '~/www/Dbase/db/';
+---------------+--------+----------+---------------------------------------
-----------------+
| Table         | Op     | Msg_type | Msg_text
|
+---------------+--------+----------+---------------------------------------
-----------------+
| asha.chapters | backup | error    | The handler for the table doesn't
support check/repair |
+---------------+--------+----------+---------------------------------------
-----------------+
1 row in set (0.00 sec)

mysql>


---------------------------------------------------------------------
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 <mysql-thread67753@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php