Restoring DB with lots of INSERTS stops after tablesize reaches 2,3MB

[nms]

I try to restore a database with lots of tables.
It works well, until one of my tables gets bigger than 2.3 MB.
After that any insert to any table is impossible.

I've been told there is a cache thing, but in 3.23.xx there is nothing mentioned about that.

What could be the problem, and how can I bypass this?

Erik

[PHPdev]

You may look in the MySQL manual for a temporary table. I remember reading something about there being a limitaion to the size of tables, the SHOW SETTINGS command may help also..

Sorry I dont know more...

PHPdev

PS.. I assume you are running MySQL.. You dont say

[nms]

I found out that our test-table in MySQL (yes..) used a smallint for our field ID.
As ID's where bigger than 32768, it was obvious it would stop..

Bad programming (not echoing mysql_error() cause a global wasn't defined) made it impossible to see.

Now I just made a restore of 1 table with more than 27.000 records and more than 9.0 MB big in just 6 seconds on a live site...

Thanks for the advise, cause I found out that table-caching only applies for SELECT/JOIN/SORT and stuff, but not for DROP/CREATE/INSERT (and probably ALTER/UPDATE too)

Erik