PDA

Click to See Complete Forum and Search --> : Convert MS Access to MySQL database using PHP script

azrina
Jun 5th, 2006, 03:49 AM
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?
penagate
Jun 5th, 2006, 03:51 AM
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.
mendhak
Jun 5th, 2006, 04:12 AM
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.
azrina
Jun 5th, 2006, 04:31 AM
mendhak,

Can you teach me how to use the LOAD DATA ?
Or, you can give me the link for the tutorial site.
mendhak
Jun 5th, 2006, 09:52 AM
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
azrina
Jun 5th, 2006, 10:21 PM
Ever used MySQL Migration Toolkit?
grilkip
Jun 6th, 2006, 01:32 AM
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
shumaker212
Mar 5th, 2010, 04:56 AM
Take a look at this pages it may solve your problem for a tool to migrate database (http://www.dbload.com).

From Here : http://www.dbload.com
menre
Mar 5th, 2010, 08:27 AM
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