Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL.

To perform a global search and replace in vi editor, use the search and replace command in command mode: