Hey Guys... suddenly, after several months, I can't add transactions to my mysql database.

Periodically, I will offload transactions from my filemaker table to a mysql table (once the filemaker table has > 500,000 transactions).

The import to the mysql table takes place in a script.

I started getting a 729 import error on the mysql table import. (729 = Errors occurred during import...)

So... I manually tried to import and -0- records imported.  The "Import Summary" reads:

---------------------------------------------------------------------------

Total records added / updated: 1500

Total records skipped due to errors: 1500

Total fields skipped due to errors: 0

Table created: <none>

---------------------------------------------------------------------------

So... I tried to add one record to the mysql table.... that was several hours ago and filemaker "hangs" while working with the entire 3 million record found set.

(The mysql table presently has 3,484,495 records in it and the filemaker table has just over 800,000 records.)

If I, say, do a search on a specific date, to constrain the found set count in the mysql, I can add a record just fine.

So, it is importing with errors.

Can anyone suggest where I start looking for the error.  729 does not tell me much.

(The fm database is hosted on an fm server).

Thanks

Edited October 14, 20169 yr by CCBtx
More information

SOLVED!!!

My data had gotten so big, a transaction counter had added a digit which made the data in that field 1 digit longer than the field length.

...sure wish there was a log that told me that rather than searching for it for 3 days :-(