Re: [PHP] Oracle's dump to MySQL

2009-04-03 Thread 9el
On Fri, Apr 3, 2009 at 8:56 PM, Bob McConnell wrote: > On Behalf Of 9el > > > The strategy depends on how complicated the database is. If it is single > table, then Oracle can export that to a CSV file which MySQL can import. > You simply have to make sure the column types match. If it is more >

RE: [PHP] Oracle's dump to MySQL

2009-04-03 Thread Bob McConnell
On Behalf Of 9el > On Fri, Apr 3, 2009 at 5:21 PM, Phpster wrote: > >> Extract to csv/XML? >> > > My main goal is to import the data from Oracle DB to mySQL for a live site I > wrote in php. I dont know a better way to do that. The strategy depends on how complicated the database is. If it is s

Re: [PHP] Oracle's dump to MySQL

2009-04-03 Thread 9el
On Fri, Apr 3, 2009 at 5:21 PM, Phpster wrote: > Extract to csv/XML? > My main goal is to import the data from Oracle DB to mySQL for a live site I wrote in php. I dont know a better way to do that.

Re: [PHP] Oracle's dump to MySQL

2009-04-03 Thread Phpster
Extract to csv/XML? Bastien Sent from my iPod On Apr 3, 2009, at 5:10, 9el wrote: On Fri, Apr 3, 2009 at 3:47 AM, Chris wrote: 9el wrote: I found this command from one guy for importing Oracle's dump to MySQL Shell> mysql -uroot db_name -vvf < oracle_dump.dmp But, v is for verbose a

Re: [PHP] Oracle's dump to MySQL

2009-04-03 Thread 9el
On Fri, Apr 3, 2009 at 3:47 AM, Chris wrote: > 9el wrote: > >> I found this command from one guy for importing Oracle's dump to MySQL >> >> Shell> mysql -uroot db_name -vvf < oracle_dump.dmp >> >> But, v is for verbose and f is for force continuation. >> >> Anyone worked with Oracle and MySQL? >>

Re: [PHP] Oracle's dump to MySQL

2009-04-02 Thread Chris
9el wrote: I found this command from one guy for importing Oracle's dump to MySQL Shell> mysql -uroot db_name -vvf < oracle_dump.dmp But, v is for verbose and f is for force continuation. Anyone worked with Oracle and MySQL? Yep, and there's no way that will ever work except for the very sim

Re: [PHP] Oracle's dump to MySQL

2009-04-02 Thread Igor Escobar
I'm in the Oracle/MySQL E-mail List ? Regards, Igor Escobar systems analyst & interface designer www . igorescobar . com On Thu, Apr 2, 2009 at 6:26 AM, 9el wrote: > I found this command from one guy for importing Oracle's dump to MySQL > > Shell> mysql -uroot db_name -vvf < oracle_dump.dmp >

[PHP] Oracle's dump to MySQL

2009-04-02 Thread 9el
I found this command from one guy for importing Oracle's dump to MySQL Shell> mysql -uroot db_name -vvf < oracle_dump.dmp But, v is for verbose and f is for force continuation. Anyone worked with Oracle and MySQL?