Importing from Oracle into MySQL
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','fvmweb.cellexchange.co' at line 2
mysql>
<<<
The line I'm trying to insert is:
>>>
insert into managerlog values(null,'2005-02-11 14:37:40','fvmweb.cellexchange.com','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?
Thanks,