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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
