ORACLE to MYSQL

[blitz760]

Hi everyone,

I have a relatively small Oracle table with about 5 columns and 3217 rows that I want to export to a MySQL table. Can someone help? I'm sure this question has been asked before but I have not been able to find the answer. Thanks in advance

[mikeatrpi]

You could do a select on the Oracle command line, and redirect output to a text file. You might need to do some processing on it with awk, depending on how your data is organized. Then use LOAD DATA INFILE for mySQL.

Or you can write a PHP script that connects to both Oracle and mySQL simultaneously and transfers your data.