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?

One simple solution is to load the MySQL ODBC driver onto the machine you currently use to manipulate your MS-Access database. You can then use the MS-Access GUI tools to create and manage your MySQL database.

You can also make CREATE TABLE queries in MS-Access that will actually copy the data for you. These aren't terribly efficient, but with only 2 Gb of data in an MDB file, efficiency isn't all that important!

-PatP

Take a look at the mysql Migration Toolkit from the authors of mysql - http://www.mysql.com/products/tools/migration-toolkit/

Good point, but for one MS-Access database it might be overkill.

-PatP