First off – allow me to congratulate you on a very well designed and efficient Software Application. For me, it is an absolute must-have as one of our 'tools'.
I have discovered one issue which I feel you should be aware of. It concerns the exporting of the database using Batch Scripts.
Our Database is relatively small at this point, however, the other day when 'exporting' the structure and data of a table, everything worked well. However, after a disaster with the table, I needed to restore it using the earlier script. The table contains approx. 5500 records. All other tables restore properly although they all hold less than 1000 to 2000 records.
When attempting to restore the 5500 record table, it would not complete. Kept 'losing mySQL Server'. In order to fully restore the table, I was forced to manually chop the script into three sections, each of which DID restore OK.
Investigating further, I found out what had caused the problem. If I export the DB and use option 'Create Bulk Insert Statements', the whole table refuses to restore. If I uncheck the 'Create Bulk Insert Statements' option when exporting, the restore works perfectly. Problem is, the default for the option is 'checked'. Could these options be made to remember their settings?
Just thought you would like to know.
