I (and our local Access god) had to do this for a project a couple of months ago. We weren't just cloning the database, we were also changing the structure. He exported the tables to csv files, I wrote some perl to do things like translate the date, time, and boolean formats from MS to MySQL.

Because there isn't a perfect 1 to 1 mapping of data types between Access and MySQL, and we were restructuring the database, we found it easier just to csv export and then 'load data infile' into MySQL. You might also consider this route if your servers aren't network to each other.

The downside is you have to do this one table at a time...it would suck if you had 100's of tables :)

--/\/\averick

In reply to Re: Transferring an Access Database to mySQL by maverick
in thread Transferring an Access Database to mySQL by kevin_i_orourke

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.