Export an MS Access database to a MySQL database

Posted on 2009-12-22
Last Modified: 2012-06-21

I'm trying to convert an MS Access 2003 database with a variety of tables and data into a MySQL database. Just need to exactly replicate it.

I CANNOT (as in am not allowed to ny my hosting company) to connect to the MySQL database remotely, so cannot use any ODBC connectivity tools to do the importing.

I can only connect to the new MySQL database via phpmyadmin so my choices here are rather limited.

Question by:Sean Clarke
    LVL 11

    Expert Comment

    This article explains this process using a import/export approach. I think you can do it using phpmyadmin.
    LVL 4

    Expert Comment

    Have you attempted the above solution?  If not, I have a few other suggestions as I've migrated multiple databases to MySQL from Access.
    LVL 1

    Author Comment

    by:Sean Clarke
    I bought some software to export the MS Access tables and content to SQL scripts that I've ran into the MySQL database.
    LVL 4

    Expert Comment

    I believe that closing this question without assigning points is inappropriate given the inquirer did not respond to the suggestion given and thus did not give the Experts an opportunity to offer a different solution.  
    LVL 1

    Accepted Solution

    OK - I downloaded the Access 2 MySql application from

    Ran it to create an SQL dump from my access database.
    Then logged into my MySQL database and imported the SQL that the utility had created, thus creating a copy of the access database

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now