Skip to content

Latest commit

 

History

History
65 lines (44 loc) · 3.03 KB

README.md

File metadata and controls

65 lines (44 loc) · 3.03 KB
Raw

mdb2mysql logo

stable branch latest release donate link

mdb2mysql

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.

Requirements

Synopsis

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.

Changelog

  • 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