MySQL Forums
Forum List  »  Oracle

Importing from Oracle into MySQL
Posted by: David Beckedorff
Date: March 23, 2005 11:15AM

Hi Folks,

I'm trying to move data from an Oracle 9i schema to a MySQL 4.1 instance. First, I tried the new migration tool, but the wizard blew up connecting to the two databases. Oh well, not yet ready for prime time.

So now I'm using SQL*Plus in batch mode on the Oracle side to generate insert statements from tables of interest, outputting to SQL script files. That works fine.

Next I try to import the SQL scripts containing the insert statements using the 'mysql' command line tool. But 'mysql' bombs reading the input lines at the 81st character. It's like it's a 1970's style teletype interface.

mysql> source insert_into_managerlog.sql
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'insert into managerlog values
(null,'2005-02-11 14:37:40','' at line 2

The line I'm trying to insert is:
insert into managerlog values(null,'2005-02-11 14:37:40','','OC4J_fvm',3816,'FVM-JVM-1','LOGON','2005-02-11 14:37:40','','3f7c5709ce614195caa5b094ff9912dfb80d2a6c522','000512','AEROGRAPHERS MATE')

Does anyone know how to increase the 'mysql' tool's input line buffer size from 80 characters to something reasonable like say 512 or 1,024.

Another question. Is it possible to get rid of this part of the error message:

check the manual that corresponds
to your MySQL server version for the right syntax to use

The verbosity level is too high. Also, how do we turn off the alarm bell associated with 'mysql's error messages?


Options: ReplyQuote

Written By
Importing from Oracle into MySQL
March 23, 2005 11:15AM
January 22, 2007 12:48AM
March 30, 2005 06:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.