Re: import mysql dump file

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Wed, 17 Nov 2010 06:24:55 -0800 (PST)
Message-ID: <dcc53341-0fd3-431a-9140-b88384d474ad_at_y31g2000vbt.googlegroups.com>

On Nov 17, 8:35 am, syd_p <sydneypue..._at_yahoo.com> wrote:
> On 16 Nov, 23:49, Enrico 'Henryx' Bianchi <henryx.b_INVA..._at_libero.it>
> wrote:> syd_p wrote:
> > > Any ideas?
>
> > You can use --compatible=oracle with mysqldump (the result is not assured)
>
> > Enrico
>
> Thanks -Tried that - sqlplus did not like the result tho.
>
> Also I installed the latest version 4.1.1 Oracle sql developer
> Tools-Migration-Third Party Database Offline Capture-Create Database
> Capture Scripts
>
>  And I craeted some scripts for linux  (get_col_table_5.sh
>  get_max_col_5.sh      get_table_5.sh
>  get_constraint_5.sh  get_stored_proc_5.sh  master_5.sh)
>  invoked master_5.sh with user password and hostname
>  amd got some sql files:
>  all_cols_tabs19675.sql  showdatabases.sql
>  temp_constraints_tabs19675.sql  temp_showtabs19675.sql
>  routines_name19675.sql  showviews19675.sql
>  temp_routines_def19675.sql      version19675.sql
>  routines_name2444.sql   showviews2444.sql
>  temp_show_cols_tabs19675.sql    version2444.sql
>
> +  some xml files
> +  a mysql5.ocp file
>
>  But I dunno what the next step is - anyone can help with that plz do.
>  -Syd

Check to see if the Oracle migration workbench supports mySQL to Oracle conversion. If it does and you have access to the mySQL database this tool may be of use.

If you have access to the mySQL database you might just want to extract the data into delimited data files and then use sqlldr to load it. This would require creating Oracle DDL to create the objects but it is one possible approach.

HTH -- Mark D Powell -- Received on Wed Nov 17 2010 - 08:24:55 CST