"lark" <hamzee@sbcdeglobalspam.net> schrieb im Newsbeitrag
news:eVn_h.187$UU.70@newssvr19.news.prodigy.net...
> Matthias Wirtz wrote:

>> I'm encountering the Error #2006 when inserting data into a table (ERROR
>> 2006 (HY000): MySQL server has gone away). Each time after the same
>> amount of rows have been successfully added the mysql client window shows
>> me this error.

> a couple of things:
> 1-are you sure you don't have any corruption in any of your data files (
> in the data dir)

I had the table files checked with myisamchk and everything is ok. Or did
you mean to use a windows tool on file level to find any corruption?

> 2-can you post the 50 last lines of your error file (generated by mysql)

I'm not sure which log file you are referencing to. There is a
[computername].err file generated in the data folder of my MySQL
installation. The last couple of lines look like this:

----------
070427 16:24:51 InnoDB: Started; log sequence number 0 46291
070427 16:24:51 [Note] C:\Programme\MySQL\MySQL Server 5.0\bin\mysqld-nt:
ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community
Edition (GPL)
070427 17:09:18 [Note] C:\Programme\MySQL\MySQL Server 5.0\bin\mysqld-nt:
Normal shutdown

070427 17:09:21 InnoDB: Starting shutdown...
070427 17:09:24 InnoDB: Shutdown completed; log sequence number 0 46291
070427 17:09:24 [Note] C:\Programme\MySQL\MySQL Server 5.0\bin\mysqld-nt:
Shutdown complete

070503 11:50:52 InnoDB: Started; log sequence number 0 46291
070503 11:50:53 [Note] C:\Programme\MySQL\MySQL Server 5.0\bin\mysqld-nt:
ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community
Edition (GPL)
----------

Looks ok to me. If there is another log file I should have a look at let me
know.
--
Matthias Wirtz - Karlsruhe, DE