> Why don't you use the load data command to import the data in to mysql? > I've done this successfully for about 56,000 records. I currently don't > have a larger data set, so that is definitely not a limit I hit.
The server I need to load data into is replicated: load data with a local infile doesn't work across a replicated server on 3.23.x, and I can't place the file onto the master prior to running the load. Once we are able to migrate to 4.0.x that problem will go away and I am planning to rewrite to use that approach. Chris > Server uname -a: > Darwin localhost 5.5 Darwin Kernel Version 5.5: Thu May 30 14:51:26 PDT > 2002; root:xnu/xnu-201.42.3.obj~1/RELEASE_PPC Power Macintosh powerpc > > Distro: > MacOS 10.1.5 > > MySQL version: > 3.23.51 > > On Thursday, September 19, 2002, at 06:55 PM, Chris Tucker wrote: > > > I'm having some trouble with a sizable (but certainly not huge) > > multi-row insert statement. I can successfully execute the query with > > up to 7365 rows, but any more and it fails > -- > Brent Baisley > Systems Architect > Landover Associates, Inc. > Search & Advisory Services for Advanced Technology Environments > p: 212.759.6400/800.759.0577 > > > --------------------------------------------------------------------- > 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 > > > --------------------------------------------------------------------- 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
