I'm trying to import a 1 GB mysql database into oracle using a perl/dbd
interface written by a 3rd party software company. This is over a network,
but I've pinpointed my bottleneck as being the disks attached to the
target oracle db server. This process dies with a timeout on the mysql
server while moving a table with 246,000 rows. It seems that some rows
were added to this table while the migration was happening. The ubiquitous
and uninformative error message is:

020702 19:49:25  Aborted connection 25 to db: 'test' user: 'testuser'
host: `snafu' (Got an error reading communication packets)

I did some poking around newsgroup archives and mysql docs yesterday and
as a result tried upping the interactive_timeout parameter. This didn't
seem to help.

Any suggestions on what else to try?

Dave Lowenstein
Programmer/Analyst
Instructional Technology Services
San Diego State University
(619)594-0270
http://www-rohan.sdsu.edu/dept/its



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to