in reply to Transferring an Access Database to mySQL
Because there isn't a perfect 1 to 1 mapping of data types between Access and MySQL, and we were restructuring the database, we found it easier just to csv export and then 'load data infile' into MySQL. You might also consider this route if your servers aren't network to each other.
The downside is you have to do this one table at a time...it would suck if you had 100's of tables :)
--/\/\averick
|
|---|