Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › ODBC to SQL Optimizations
It would be nice to have an option in the ODBC export tool to save the data exported to a SQL script that had optimizations in it similar to mysqldump with the settings:
–quick –add-locks –disable-keys –extended-insert –lock-tables
Or some similar variation. This would greatly speed up insertion into a MySQL database. Thanks!