ok i found the troubled table DROP TABLE IF EXISTS `activity`; CREATE TABLE `activity` ( `int_activity_id` int(11) NOT NULL auto_increment, `vch_uniqid` varchar(50) NOT NULL default '', `int_user_id` int(11) NOT NULL default '0', `ts_time` int(50) NOT NULL default '0', `vch_page_viewed` varchar(255) NOT NULL default '', PRIMARY KEY (`int_activity_id`), UNIQUE KEY `int_activity_id` (`int_activity_id`), KEY `vch_uniqid` (`vch_uniqid`) ) TYPE=MyISAM;
wot could be the prob ? -----Original Message----- From: Dan Rossi [mailto:daniel@;electroteque.org] Sent: Thursday, November 07, 2002 6:11 PM To: MySQL Mailing List Subject: Mysql dump error mysqldump: Got error: 1030: Got error 127 from table handler when retrieving data from server for some reason i get this when i dump all databases using mysqldump -p --all-databases --add-drop-table --quote-names > all_databases.sql --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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