Wwwebber's Blog

Migrating an access file to mysql

Posted in Uncategorized by wwwebber on July 17, 2009

UPDATE TO THIS POST: avoid using data-lists.com– I bought two databases from them. One was fine  but the other was terrible, and I’m fighting them to live up to their website’s claim that you can get a refund. Again avoid these guys. If you need a good public or private school database, here’s a reliable one digitalpoint . Moreover, this guys list is available in various formats including a MySql dump.

Ok, this post will help you if

1) your data is an Access file (who the hell uses Access databases anyway?)

2) You need that data in a MySql databases

3) you have mysql  and phpadmin up and running on your computer (you probably also have apache up and running)

The background : After doing a lot of comparison shopping for a few different databases ( I needed one for all public and private schools in the US), the best deal–by a long shot-was this site: http://www.data-lists.com/ — their data was way more complete–1000’s more unique records than  the others I saw and the price was even a bit better than most of the others that I saw out there. There was only 1 major draw back (at least at first it seemed like a draw back) the data only comes in 1 format: a Microsoft Access file–crap. I thought I was in for a major pain in the butt–and before I started researching how to try to parse an Access file into something I could import into mysql I discovered an awesome mysql to Access conversion  tool that is, amazingly enough, free and does a lot of the work for you–it’ll  import your Access db into your MySql db… All you need is mysql up and running on your computer and this baby’ll convert the entire thing for you!.

To be able to do this my way (the easy way), just follow these steps

1) make sure that you log into mysql and start it up, make sure that you have phpmyadmin booted up also

2) download and install bullzip’s convertor tool , then run the tool. It’s pretty straightforward.

3) you will be asked for a bit of mysql info–port number etc..

4) At the prompt you want to do a ‘direct transfer’ which will just take the data and put into a database on your mysql server

5) then you’re good. It’s in your server. Below is a screen shot of the converter tool in action!



Comments Off on Migrating an access file to mysql

%d bloggers like this: