Sorry if this is not the best venue for my issue, but I am going nuts about it. Probably I don't understand something basic, but then I would hope for a slightly more enlightening error message.
The problem is that after doing INSERTS to two tables, when I check the tables using mysql.exe in a DOS box, the tables (one or both) are sometimes corrupted (especially noticable when I try to delete the newly inserted rows from within mysql.exe). And always a .TMD file shows up in the database's directory when I try to repair the table either with REPAIR TABLE (in mysql) or using any of the options in myisamchk. Unfortunately, the only consistent behaviour that I can produce is corrupting the tables, though not consistently. Sigh.
I'm using connect (pconnect was buggy in my first PHP version) and I'm guessing mysql.exe is somehow conflicting with a leftover connect thread (I'm not killing or cleaning up anything (ie. database resources).
Does anyone have any experience with this type of thing?
Sorry for being so vague,
Csaba
I am using PHP 4.2, MySQL 4.0.1, Apache 2.0.28 on Win2K (also happened with PHP 4.1, MySQL 4.0.0)
