Moving specific data from an Oracle database to a MySQL db

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
Chewy
Forum Newbie
Posts: 1
Joined: Wed Aug 25, 2004 8:28 am

Moving specific data from an Oracle database to a MySQL db

Post by Chewy »

Hi all,

I've just found this site - seems to brimming with knowledge :)

I've got a project coming up, whereby I need to copy some specific data (all entries with a disability) from an Oracle db and then dump it into my mysql db.

Just wondering if there is an easy way to do this, I've had a root on google but can't seem to find anything.

Thanks a lot.

Chew
lostboy
Forum Contributor
Posts: 329
Joined: Mon Dec 30, 2002 8:12 pm
Location: toronto,canada

Post by lostboy »

i would do an export on the data and then bulk import it into mysql with 'load file'
Post Reply