Kev,
Please, download,
http://www.hostcl.com/zip/exportar.zip
This bas module was adapted to export all tables
from databases to xxx.txt. Using xxx.sql itīs fine. Hope you can read some spanish!
Change database name and name for text files as your requires. Call exportSQL funtion w/o parameters from any form in your vb app.
The best way to give the txt file to mysql have been with phpMyAdmin. The file delete tables in your mysql database, re-create empty tables and transfer data for that table, one pass for table.
Best from Santiago de Chile
Charliej
Originally posted as a Categorized Answer.