Publishers of technology books, eBooks, and videos for creative people

Home > Articles > Web Design & Development > Usability

Web Design Reference Guide

Hosted by

Databases

Last updated Oct 17, 2003.

MdbToMySQL — This is a utility for programmers who want to migrate a Microsoft Access database into MySQL. MdbToMySQL reads an MDB file and dumps out a text file (preferably with the extension *.sql) containing MySQL Strings for building and filling the database. To use it, doubleclick "MdbToMySQL.exe," locate the MDB database file, select the tables to export (Check mark them or click on [All]), choose "What to export," make some "Options" (default setting should do fine), click "Export MySQL file" and choose the destination file. Now activate your Import Tool on the server (like phpmyadmin) and import that just created file. (If there is no special import function, look for Sql Execute or similar.)