Results 1 to 9 of 9

Thread: Convert MS Access to MySQL database using PHP script

  1. Jun 5th, 2006, 03:49 AM #1
    azrina
    azrina is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2004
    Posts
    100

    Convert MS Access to MySQL database using PHP script

    Hi all.

    I have database in MS Access.
    I want to convert the database to MySQL.
    I have surfed the net that there are several ways to migrate data from Access to MySql, and the easiest is to buy a piece of software.
    And, other than that, we can use the MySQL odbc driver.

    I just wanna know, if there are any other way like using some script, example PHP script to convert the database?

    Can anyone here tell me the tutorial site that teach how to convert using PHP script ? or any other script that can do so?
    Reply With Quote Reply With Quote
  2. Jun 5th, 2006, 03:51 AM #2
    penagate
    penagate is offline
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    Re: Convert MS Access to MySQL database using PHP script

    Unless it needs to be done through a web interface it doesn't really make sense to use PHP for this, but still. You could basically run through every table, every record, using the Access ODBC driver, and output it to MySQL.
    Reply With Quote Reply With Quote
  3. Jun 5th, 2006, 04:12 AM #3
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Convert MS Access to MySQL database using PHP script

    I think, from your post, that you're open to possibilities other than writing a php script for it. For one, the way I've done it before is to export from Access, into text files, then loading the text files into MySql using LOAD DATA.
    Reply With Quote Reply With Quote
  4. Jun 5th, 2006, 04:31 AM #4
    azrina
    azrina is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2004
    Posts
    100

    Re: Convert MS Access to MySQL database using PHP script

    mendhak,

    Can you teach me how to use the LOAD DATA ?
    Or, you can give me the link for the tutorial site.
    Reply With Quote Reply With Quote
  6. Jun 5th, 2006, 09:52 AM #5
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Convert MS Access to MySQL database using PHP script

    http://dev.mysql.com/doc/refman/5.0/en/load-data.html
    Reply With Quote Reply With Quote
  7. Jun 5th, 2006, 10:21 PM #6
    azrina
    azrina is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2004
    Posts
    100

    Re: Convert MS Access to MySQL database using PHP script

    Ever used MySQL Migration Toolkit?
    Reply With Quote Reply With Quote
  8. Jun 6th, 2006, 01:32 AM #7
    grilkip
    grilkip is offline
    Fanatic Member
    Join Date
    May 2005
    Posts
    898

    Re: Convert MS Access to MySQL database using PHP script

    You would be best off connecting to the mysql server using Access and running a query from the access database.

    Mysql comes with an ODBC driver which you can use from access to make a connection.

    http://dev.mysql.com/downloads/connector/odbc/3.51.html
    "so just keep in mind that fantasy is not the same as realtiy and make sure u remember that wii sports may be fun but u cant count on it as exercise ok cool bye" - HungarianHuman
    Reply With Quote Reply With Quote
  9. Mar 5th, 2010, 05:56 AM #8
    shumaker212
    shumaker212 is offline
    New Member
    Join Date
    Mar 2010
    Posts
    1

    Re: Convert MS Access to MySQL database using PHP script

    Take a look at this pages it may solve your problem for a tool to migrate database.

    From Here : http://www.dbload.com
    Reply With Quote Reply With Quote
  11. Mar 5th, 2010, 09:27 AM #9
    menre
    menre is offline
    Addicted Member
    Join Date
    Sep 2005
    Posts
    150

    Re: Convert MS Access to MySQL database using PHP script

    If you are using phpmyadmin with your MYSQL program, I will advice you take a look at the link below. I had a problem loading data into MYSQL before. But now I am confident with it and I do it easily. Thanks to the help I got from some 'pros' here recently. Some of the advice I got have also been mentioned to you here already.

    This is the link for the post.
    http://www.vbforums.com/showthread.php?t=603702

    Menre
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width