Hello.
Have you looked into error log? Server could die during the query execution. >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"Ying Sun" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
