Hi Heikki, Thought you might want to hear this one, I was trying to mysqldump our support database (all tables innodb) WHen I got the following error: bash-2.04$ mysqldump --opt -uken -p supportdb terms >supportdb.dump Enter password: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table 'terms' at row: 0
The server did not restart, all other tables would dump fine, but terms would not. I then altered the table type to myisam: alter table terms type=myisam ----------- then back to innodb alter table terms type=innodb And then the dump proceeded with no error! Are you aware of any problems like this? If it happens again would you like any other info? Ken P.S. Here is version info (running FreeBSD 4.4-stable) this is our internal test server bash-2.04$ mysqladmin -uken -p ver Enter password: mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for unknown-freebsdelf4.4 on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha-debug-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 19 hours 48 min 33 sec Threads: 34 Questions: 161144 Slow queries: 5 Opens: 719 Flush tables: 1 Open tables: 522 Queries per second avg: 2.260 bash-2.04$ ----------------------------------------------------- Ken Menzel ICQ# 9325188 www.icarz.com [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