A tool to convert Microsoft Access databases into MySQL compatible SQL dump file. This file can then be imported into MySQL just like a standard SQL dump.
mdb2mysql [options] <mdb file> -c Create table structure only, no data. -d Add a 'drop table' before each create. -e Use the much faster, extended INSERT syntax. -i Export data inserts only. -l Add locks around insert statements. -o <tables> Omit tables in this comma separated list. -r <character> Replace illegal characters with given character. -t <tables> Export only this list of comma separated tables. -u Report unknown Access data type and exit. -x Same as using -d -e -l combined options. -M Convert Access System tables ('MSys') as well. -C <type> Define character set of the transferred data. -U <type> Use the MySQL data type for unknown Access types. Unless given, 'blob' will be used by default. -h, --help This message and exit. -V, --version Output version information and exit. -
v1.1.1
- Minor documentation updates.
- Reverted to GNU General Public License v3.
-
v1.1.0
- Added ability to specify character set for the incoming data in MySQL. This allows for the import of multilingual data from Access databases.
-
v1.0.1
-
All table and column names are now quoted. Thus, fixing a problem when dealing with tables or column names that contain spaces as part of their name.
-
Illegal characters are now stripped out from table/column names by default rather then being replaced by an underscore. This is done to encourage the use of clean table/column names.
-
To avoid errors when trying to move NULL value from Access to MySQL, all columns within MySQL are now allowed to have NULL values. Also, since MDBTools do not export a default value for a column, it is now left to be set by MySQL.
-
-
v1.0.0
- First release by Bill Lewis bill@enobis.com