Re: [PHP] Oracle's dump to MySQL

2009-04-03 Thread 9el
On Fri, Apr 3, 2009 at 3:47 AM, Chris dmag...@gmail.com 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-03 Thread Phpster
Extract to csv/XML? Bastien Sent from my iPod On Apr 3, 2009, at 5:10, 9el le...@phpxperts.net wrote: On Fri, Apr 3, 2009 at 3:47 AM, Chris dmag...@gmail.com wrote: 9el wrote: I found this command from one guy for importing Oracle's dump to MySQL Shell mysql -uroot db_name -vvf

Re: [PHP] Oracle's dump to MySQL

2009-04-03 Thread 9el
On Fri, Apr 3, 2009 at 5:21 PM, Phpster phps...@gmail.com 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 Bob McConnell
On Behalf Of 9el On Fri, Apr 3, 2009 at 5:21 PM, Phpster phps...@gmail.com 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.

Re: [PHP] Oracle's dump to MySQL

2009-04-03 Thread 9el
On Fri, Apr 3, 2009 at 8:56 PM, Bob McConnell r...@cbord.com 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

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 le...@phpxperts.net wrote: I found this command from one guy for importing Oracle's dump to MySQL Shell mysql -uroot db_name -vvf

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