Randall,
I have not heard of NaviCat so I can't say if this will fix the problem. It did fix my problem so I thought it might help you.

Yes, I am doing a text file dump from VFP and importing that file into MySQL. When I tried running my conversion program using ODBC and doing one record at a time it took just over 4 hours to move my data. When I tried using the text file dump / import it took 2 MINUTES!!! I ran it several times both ways and the results were the same each time.

I realize that many people prefer to stick with ODBC but it is really slow when working with large amounts of data. It is a lot more work to set up but once you get all the backround utility procedures written it can be easy.

As for when to run the procedure I gave you:
Just before you pass data between VFP and MySQL:

=jDateFormat('MySQL')

Then right after set it back with:

=jDateFormat('DEFAULT')

or

=jDateFormat('AMERICAN')