The ini now looks like this and I still have the same problem.
#This File was made using the WinMySQLAdmin 1.4 Tool <br />#12/13/2003 12:16:08 AM <br /> <br />[WinMySQLadmin] <br />Server=C:/mysql/bin/mysqld-nt.exe <br /> <br />[mysqld] <br />log-error=c:/mysql/logs/error.log <br />basedir=c:/mysql <br />#bind-address= <br />user=root <br />password=*************** <br />skip-innodb <br />connect_timeout=10 <br />datadir=c:/mysql/data <br />language=c:/mysql/share/dutch <br />#slow query log#= <br />#tmpdir#= <br /> <br />set-variable = key_buffer=64M <br />set-variable = thread_concurrency=4 <br />set-variable = flushkey_buffer=128M <br />set-variable = max_allowed_packet=16M <br />set-variable = query_cache_type=1 <br />set-variable = query_cache_limit=1M <br />set-variable = query_cache_size=8M <br />set-variable = read_rnd_buffer_size=4M <br />set-variable = sort_buffer_size=8M <br />set-variable = thread_cache_size=1M <br />set-variable = table_cache=150 <br />set-variable = tmp_table_size=64M <br />set-variable = myisam_sort_buffer_size=8M <br />set-variable = myisam-recover=BACKUP,FORCE
The server seems to hang on the "copy to temp table".
Does anyone know what (and whatfor) exactly MySQL is doing there? Could it be this temp table is misssing and therefor no data can be copyed into it?
Regards,
Ron