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
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