check the post below, it has some suggestions:
http://forums.mysql.com/read.php?61,4260,6109#msg-6109
David Beckedorff wrote:
> 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',381
> 6,'FVM-JVM-1','LOGON','2005-02-11
> 14:37:40','','3f7c5709ce614195caa5b094ff9912dfb80d
> 2a6c522','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,