Hello I meet a strange problem:
when I create a new table, the mysql cleint loose connection with the server. Synopsis: $ mysqladmin -u mysql -pxxxxx create temp (no problem reported, /var/lib/mysql got a new directory 'temp') $ mysql -u mysql -pxxxxx temp mysql> create table oups ( id bigint primary key auto_increment not null); ERROR 2013: Lost connection to MySQL server during query mysql> show tables; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id: 10 Current database: temp Didn't find any fields in table 'oups' +----------------+ | Tables_in_temp | +----------------+ | oups | +----------------+ When I look in the mysql log file: Number of processes running now: 1 mysqld process hanging, pid 16137 - killed 021018 11:12:03 mysqld restarted /usr/local/mysql-3.23.52/libexec/mysqld: ready for connections And in the directory '/var/lib/mysql/temp', there is a file 'oups.frm', but no 'oups.MYI' MySQL version is 3.23.52 handmade running on a RedHat 6.2 (linux 2.2.14) The server has no big load. Does someone know how to make it work again ? -- NetClub'ment votre, Mickael Bailly --------------------------------------------------------------------- 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