Dear there, I met some problem when I try to use \. command to create several tables from a file in mysql. I got error as follows: ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) .....
I read MySQL Reference Manual http://dev.mysql.com/doc/mysql/en/gone-away.html. Actually, my query file is not large, I think, it is within 1M. Even I try "mysql> mysql --max_allowed_packet=32M" and "mysql> mysqld --max_allowed_packet=16M", it doesn't work either. And I also notice, if I type shell>mysqld, it gives me error report: " 050524 12:49:35 [Warning] Asked for 196608 thread stack, but got 126976 050524 12:49:35 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 050524 12:49:35 [ERROR] Do you already have another mysqld server running on port: 3306 ? 050524 12:49:35 [ERROR] Aborting 050524 12:49:35 [Note] ./mysqld: Shutdown complete" I have no idea about that problem. Could someone can help me? Thanks a lot! Best Regards, Ying
