MDB Viewer Download Buy Now Also available on the
Mac App Store

MDB Viewer requires OS X 10.6 or later. The free trial is fully functional except for export limitations.
© 2011-2017 Jakob Egger

Help Index

Migrating Access Databases to MySQL

The easiest way to migrate your Access database to MySQL is to export a MySQL-compatible SQL file using MDB Viewer and then upload this file using the wonderful Open Source app Sequel Pro.

For a general introduction to SQL files, see Exporting as SQL.

Step by Step

In MDB Viewer:

MySQL Export Options

In Sequel Pro:

Access Types vs. MySQL Types

Access TypeMySQL Type
Boolean BOOLEAN
Byte INTEGER
Integer INTEGER
Long Integer INTEGER
GUID TEXT
Decimal DOUBLE
Money DOUBLE
Float DOUBLE
Double DOUBLE
Date/Time DATETIME
Text VARCHAR
Memo LONGTEXT
Ole LONGBLOB

When exporting for MySQL, backticks are used to quote table and column names. Therefore table names containing spaces etc. work just fine.

Help Index

Questions? Contact Jakob Egger.