How to export access database to MySql/PHP?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
gma216
Forum Newbie
Posts: 5
Joined: Wed Aug 23, 2006 3:22 pm

How to export access database to MySql/PHP?

Post by gma216 »

I have a access database that i would like to export into a MySql database weekly. What is the easiest and most effective way to do this. I still want to keep the access database and make any changes there, but just would like to export it to an online MySql database.

Any input would be much apprieciated.

Thanks,
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Are you doing it manually or with code?
gma216
Forum Newbie
Posts: 5
Joined: Wed Aug 23, 2006 3:22 pm

Post by gma216 »

Manually, well ideally would be just use an export function in Access, and upload that file on the web server compatible for MySql. I dont know if thats possible or not though.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

No, it is not. The only export functionality that Access has in a CSV/Tab Delimited text file. What I have done in the past was to dump the access file as a CSV then use phpMyAdmin to try to import the data. That will probably not work out well (at least it didn't in my experience). I ended up ditching Access in favor of two MySQL databases. One was local (like Access was) and the other was hosted. Syncing can be done by dump/import or by a Sync mechanism like SQLYog offers.
gma216
Forum Newbie
Posts: 5
Joined: Wed Aug 23, 2006 3:22 pm

Post by gma216 »

Is there any way to keep the acces database and use some other conversion. Because i think our company would want to stay with Access. I've researched online and found a software by Soft Galaxy: http://www.softgalaxy.net/access-mysql/ dont know if this software is any good or not though.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Never heard of it, but maybe you could try it and let us know how it goes? Just remember to back up early and often.
Post Reply