I have been pouring over the MYSQL documentation trying to determine if my script or MYSQL itself is causing a truncation of a large table. The basic behavior I am seeing:
- A PHP script is kicked off from the browser to select rows from a MSSQL table and immediately insert them into a local MySQL database table.
- After determining the number of rows in MSSQL, my script breaks down the select into chunks to avoid any out of memory issues.
- The script then truncates the local table and starts to import the data by iterating over the chunks
- Following the data in MySQL directly, I see the table close in on ~200,000 rows and then suddenly the table truncates and the count starts over
- I would think that I would see some errors about the table being full and I didn't think MySQL would truncate the table if the table limit was reached.
Can anyone confirm whether or not MySQL would truncate a table automatically if the table limit is reached or a setting to check to turn off such behavior?