MySQL Forums - Perl

update DBD::mysql error (no replies)

h h — Wed, 19 Jun 2013 06:02:08 +0000

i upgrade DBD::mysql from 3.0007 to 4.023 ,get an error,anyone know how to solve this problem? thanks a lot

# find /usr -name 'mysql_config'
/usr/lib64/mysql/mysql_config
/usr/local/mysql-5.5.30-linux2.6-x86_64/bin/mysql_config
/usr/local/mysql-5.1.63/bin/mysql_config
/usr/local/mysql-cluster-gpl-7.1.22/bin/mysql_config
/usr/bin/mysql_config
/usr/lib/mysql/mysql_config

i use mysql5.5 so
# perl Makefile.PL --mysql_config=/usr/local/mysql-5.5.30-linux2.6-x86_64/bin/mysql_config

]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base....................ok 1/6
t/00base....................NOK 2# Failed test 'use DBD::mysql;'
# at t/00base.t line 21.
# Tried to use 'DBD::mysql'.
# Error: Can't load '/root/DBD-mysql-4.023/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.18: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
# at (eval 7) line 2
# Compilation failed in require at (eval 7) line 2.
# BEGIN failed--compilation aborted at (eval 7) line 2.
FAILED--Further testing stopped: Unable to load DBD::mysql
make: *** [test_dynamic] Error 9

# make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Writing /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/.packlist
Appending installation info to /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/perllocal.pod
[root@CHS118 DBD-mysql-4.023]# perl -MDBD:mysql
syntax error at - line 0, near "use DBD:"
Execution of - aborted due to compilation errors.

# perl -MDBD::mysql
Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.18: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at - line 0
Compilation failed in require.
BEGIN failed--compilation aborted.

Using DBI for MySQL metadata (no replies)

CHap Harrison — Sun, 17 Feb 2013 19:47:23 +0000

I'm unable to get the information I need from reading the CPAN DBI documentation, and it was suggested I post here for help specifically for MySQL. (FYI I'm using Perl 5.10 and MySQL 5.5/5.6).

I can't seem to find a list of descriptions of the info that's being returned from this:

my $sth_column_info = $dbh->column_info( $catalog, $schema, $table, undef );
my $aoa_ref = $sth_column_info->fetchall_arrayref;

There are 30-some elements in the array for each column. The meaning of some is obvious, the meaning of others is not.

It's also not clear to me how to express the arguments to fetchall_arrayref() to ask for only certain information.

And there are some numeric codes that aren't meaningful without a key.

Is there some documentation, specifically aimed at MySQL, on how to use the DBI for obtaining metadata?

Select query returns false result. (1 reply)

Tom Thomas — Tue, 05 Feb 2013 03:03:01 +0000

eg:

Table : user
column : user_id (type is int)

SELECT * FROM user WHERE user_id = '10xyz' is giving same result of
SELECT * FROM user WHERE user_id = '10'

The input value is not integer but not giving an error in this case.

MySql, Perl, and HTML Update function not working (6 replies)

adam gruber — Tue, 05 Feb 2013 14:51:14 +0000

Hello,
I used a guide that I found that was written by Tony Darnell regarding using MySql, Perl, and a little HTML to create, update, and delete database records. Everything works perfectly, except for the UPDATE functionality. Is there anything explicitly wrong with the following lines

$serial = $formdata{'serial'};
$name_first = $formdata{'name_first'};
$name_last = $formdata{'name_last'};
$address_01 = $formdata{'address_01'};
$address_02 = $formdata{'address_02'};
$address_city = $formdata{'address_city'};
$address_state = $formdata{'address_state'};
$address_postal_code = $formdata{'address_postal_code'};

$dbh = ConnectToMySql($Database);

$query = "update address set name_first = '$name_first', name_last = '$name_last', address_01 = '$address_01', address_02', address_city = '$address_city', address_state = '$address_state', address_postal_code = '$address_postal_code' where serial = '$serial'";

$sth = $dbh->prepare($query);

$sth->execute();

$dbh->disconnect;

When I takek out the $serial and enter in a manual value in the $query line, it works. So something is not kosher with having it grab that value on its own. I am a complete MySql and Perl n00b btw, so I apologize right off the bat if i misunderstand something or am missing something easy. Thanks for the help and let me know if you need any other info.

Mysql query produces different results for different users (3 replies)

Amir Weinberger — Sun, 09 Dec 2012 19:45:19 +0000

Hello,

On my website I have a form with 6 fields the user fills in order to retrieve desired records from database.
The user can leave all fields empty, in which case all the records are displayed.
Alternetively, he can fill any combination of fields and the mysql query will be built dynamically based on the user's choices.

When I click the submit button, it works fine, no matter what fields combination I fill in the form.

But, I have a problem with a user, actually a company with a network of 20 users connecting online using Sbox (router).
When they leave all the above form fields empty, they get the recordset and it's working fine. But, when they fill any of the form fields (any number of fields in any combination), they get an empty recordset. No errors but no records.

I have no idea what's the reason for this.

If they get all the records when the form fields left empty, it means they connect successfully to the database. Also, the PHP code is OK, after all I tested it and it worked (and still working) fine.
So if there is no connection problem and no code problem, what can the problem be?

If it is relevant, the difference between their computers and mine:
They use ie8 (I use ie9)
Their OS: Windows XP (mine Windows 7)
Om all stations they have NOD32 antivirus. (I have a different one)

I don't think any of the above is relevant, but because the situation is so
unexpected so I don't know where to look for the solution, I provide all details....

Any ideas?

Thanks for your help!

Apologies - not perl (no replies)

Paul A — Thu, 22 Nov 2012 22:20:33 +0000

Paul

Get data from Mysql with php (1 reply)

Jack Rima — Tue, 20 Nov 2012 12:28:41 +0000

Hello all,

I have a Mysql database with 3 column ID, Name and Image.

The Image is store in the for of:
[{"index":1,"image":"value.jpg","thumbnail":"value_t.jpg"}]

I want to get the value of "image" with Php, what just I do? plz Help

UPDATE ... WHERE writing a new line (4 replies)

Paul A — Mon, 19 Nov 2012 20:07:15 +0000

I am having trouble converting valid MySQL command line to Perl. This works:

mysql> UPDATE control_number SET ctrlnum=714568 WHERE id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM control_number;
+---------+------+
| ctrlnum | id |
+---------+------+
| 714568 | 1 |
+---------+------+

But when I run it in a production .pl (increment by 1 every time the script is called), it writes a new line:

my $sth = $dbh->prepare("UPDATE control_number SET ctrlnum='$max' WHERE id = 1;");
$sth->execute;
+---------+------+
| ctrlnum | id |
+---------+------+
| 714568 | 1 |
| 714569 | NULL |
+---------+------+

Cane somebody please help? Many thanks. -- Paul

Retrieving the default database name (7 replies)

Meir Guttman — Tue, 23 Oct 2012 20:34:21 +0000

Setting the default database is really simple and learning how to do it is simple too!

But it is really frustrating, and so far I was unsuccessful, to find how to retrieve the default database name.

Is there a "SELECT" way to do it? Any other way???

Thanks

Perl script Mysql update help (2 replies)

Neil Bernard — Tue, 04 Sep 2012 18:27:06 +0000

Ok I give up, i've read loads of posts I just cannot get this snippet work with variables, works fine if I use manual values.... Please help

$sql = 'UPDATE snmpcol SET sysUpTime = "$snmpresult" WHERE IP = "192.168.1.60"';
$sth = $dbh->prepare($sql) or die "Cannot prepare: " . $dbh->errstr();
$sth->execute() or die "Cannot execute: " . $sth->errstr();
$sth->finish();

Thanks in advance chaps

DB connect error (no replies)

Paul Brown — Fri, 24 Aug 2012 21:45:05 +0000

Hello all,

I was wondering what this problem was. I write a simple script after installing MySQL, DBD-mysql-4.021, DBI-1.622, and Data-ShowTable-3.3.

MySQL version: mysql Ver 14.14 Distrib 5.5.27, for osx10.6 (i386) using readline 5.1

The script was:

#!/usr/bin/perl

use strict;
use DBI;
use warnings;

# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=rendb:localhost",
"renadm", "wiseman",
{'RaiseError' => 1, PrintError => 0, AutoCommit => 1});

print $dbh, "\n";

# Disconnect from the database.
$dbh->disconnect();

exit 0;

The error was:

dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from: /Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Expected in: flat namespace

dyld: Symbol not found: _mysql_init
Referenced from: /Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Expected in: flat namespace

Trace/BPT trap: 5

Perl can't find _mysql_init? After all that installation? I bet this problem is simple. I just don't have the experience yet. Any clues?

Thanks.

Paul Brown

install DBD:mysql without mysql (no replies)

F L — Tue, 31 Jul 2012 12:09:11 +0000

Hi,
I'd like to install DBD::mysql to connect to a mysql instance on an other server.
I cannot install mysql locally.
Can someone advice which files I need (for installation / execution) or
how to achieve that?

RHEL5 / mysql 5.5.8

Thanks a lot!

converting latin1_swedish_ci "text" column data to utf8_bin (1 reply)

7 reeds — Wed, 25 Jul 2012 19:10:21 +0000

Hi,

I have seen several discussions on-line about converting existing databases and tables from latin1_* to utf8 using ALTER TABLE commands. I can't do that.

The MySQL instance I have inherited has the default latin1_swedish_ci encoding. All the existing databases and tables are in that encoding.

I am in the process of making major modifications to some of the existing apps and want to move to utf8 encoding. I have created the tables with the new encoding and I want to copy the old data from the old latin1 tables into the new tables. i will then setup an AFTER TRIGGER on the old tables to push any new items that come in to the new tables.

The question is how do I do the conversion "on the fly"? I know about the CONVERT() and CAST() functions.

I am mainly having issues with an old "TEXT" column that is latin1_swedish_ci. I am doing the following:

SELECT * FROM the old table

FOREACH row
    INSERT INTO new table ...
    VALUES (..., CONVERT(old_text_col USING utf8), ...)
END FOR

but that column in the new table always reports the column contents as a BLOB.

I do not see a charset option in DBI. What am I missing?

SQL_CALC_FOUND_ROWS / found_rows() vs loop counter (no replies)

7 reeds — Wed, 18 Jul 2012 16:46:31 +0000

Hi,

I am using perl 5.8.8, MySQL 5.1.51 and am connecting to the db via DBI->connect_cached()

I am experimenting with using SQL_CALC_FOUND_ROWS and FOUND_ROWS() to tell me the number of items returned from a query with a LIMIT clause. I have an ever growing table with (currently) 348735 records -- based on a SELECT count(*) FROM table. As i type this that number may grow by a few or a dozen.

Last evening I was running a perl script to test the numbers and issued the query:

$tmp = <fetchrow_hashref; $i++) {
    if ($i && ($i % 2000) == 0) {
        print STDOUT "\tSleeping after $i\n";
        sleep 2;
    }
}
$sth->finish;
print STDOUT "Number of rows operated on = $i\n";

$sth = &returnQuery($DBH, "SELECT FOUND_ROWS()");
@cnt = $sth->fetchrow_array;
$sth->finish;
print STDOUT "returned rows = $cnt[0]\n";

The last time i ran this yesterday it returned:

# ./copyDB
        Sleeping after 2000
        Sleeping after 4000
        Sleeping after 6000
        Sleeping after 8000
        Sleeping after 10000
[...]
        Sleeping after 344000
        Sleeping after 346000
        Sleeping after 348000
Number of rows operated on = 348690
returned rows = 279260

So, last night there were a few less records in the table than there are now. That is to be expected. The question is why is the number returned by FOUND_ROWS() so much lower than the loop counter?

I figure that I did something wrong but I can't see it yet.

ideas?

Seven

install_driver(mysql) failed (no replies)

Frederick Eason — Sat, 23 Jun 2012 17:24:39 +0000

Please help!

I have DBD::mysql installed, and all the files are in the right places, but when I run the program, I receive this error:

install_driver(mysql) failed: Can't load 'C:/wamp/bin/perl/site/lib/auto/DBD/mysql/mysql.dll' for module DBD::mysql: load_file:The specified module could not be found at C:/wamp/bin/perl/lib/DynaLoader.pm line 191, line 3.
at (eval 401) line 3.
Compilation failed in require at (eval 401) line 3, line 3.
Perhaps a required shared library or dll isn't installed where expected
at C:/wamp/www/wakaba.pl line 45.

What's wrong with the program?

I've using WampServer 2.2 64-bit with Apache 2.4.2 and ActivePerl 5.16.0.

Query for unkown column name (1 reply)

Rene Jaspers — Sun, 24 Jun 2012 05:04:03 +0000

Oke here it goes,
i have 2 tables (exchangerate and player)
player has a column called currency
and exchangerate has columns named after those currencies
So what i would like to do is this

select
player.name,
player.currency, (like eur of usd)
exchangerate.[player.currency] as exchangerate
from
player
inner join exchangerate on ( exchangerate.date = DATE(NOW()) )
where
player.id = 1;

Giving me the following row
[name] [currency] [exchangerate]
John 'usd' 1.2345

Any help is nice!

MYSQL and Perl (1 reply)

Johannes Schuller — Tue, 05 Jun 2012 17:14:56 +0000

Hello Community !

Fist of all, my congratulations for this outstanding forum here.

And here are my questions:

I have to do a MYSQL Server in our company for our customer tables. The Server is already working and I have installed a DB and tables in it for testing.
Now my problem is, that I have a list of data which is like this 11111(accountnr);name;street;..... etc.
In my perl script I have to search with the account number, and want to get back the row with the information to have them my perl script.
The Problem is I'm always only getting the account number instead the whole row back. Here is a part of my script:

if (/^customer\;/)
{
$kto = $line[1];

$connection1 = "DBI:mysql:testdb";
$user = "XXXXX";
$pass = "XXXXX";

$dbh = DBI->connect("$connection1","$user","$passwort") || die "DB connection not made: $DBI_errstr";

$sql = "SELECT $kto FROM mytable";
$sth = $dbh->prepare($sql);
$sth->execute();

while (@array =$sth->fetchrow_array())

{
print "*".$array[0]."*".$array[9]."*\n";
}

Thanks for your help.

how to get database backup (2 replies)

arc v — Tue, 19 Jun 2012 20:28:05 +0000

I have run this command

mysqldump -uroot -pv1rtue vtsmain > backfile.sql
this backupfile.sql contain only table backup not function or triggers
i will get all this backup(table data,fun,triggers) what command i will run

Perl - Mysql database connection error (1 reply)

Pooja Nair — Sat, 21 Apr 2012 05:37:48 +0000

Hello,

I am a newbie in MySql database,I have a perl script which connects to mysql database and executes select and update query.Sometimes while running that script,iam getting an warning :

DBD::mysql::st execute failed: MySQL server has gone away

and the script fails.

The database is installed on a linux box and the script is excuted from a windows machine.Also, I tried to connect to the mysql database from command line.I am able to do that w/o any problem.

Can anyone help me to find the reason for this failure?

Thanks,
pooja

Connect to two DB same server... (2 replies)

Enrique Welch — Mon, 26 Mar 2012 16:16:05 +0000

Hello,

I have an application that uses two databases in the same server that need to share data.

Is important to have diferent users/password for each DB but i need to cross data between both. This is an example:

DB1: Table "A" user "aaaa"
DB2: Table "B" user "bbbb"

SELECT * FROM A INNER JOIN B ON x=x

I know this can be done using the same user and password but I need to know if is possible using diferent user.

I am using in my perl application DBI / DBD mysql... if is possible... how can i do connections?

Thanks in advance

This will give column names only (no replies)

Dvd Avins — Thu, 22 Dec 2011 15:39:47 +0000

A few years ago, someone asked how to get a list of column names of a table and I don't think any of the supplied answers gave just the list, rather than additional information. That's what he was looking for. It can be done by:

SELECT column_name from information_schema.columns where table_schema = "your_database_name" and table_name = "your_table_name";

The old topic as at http://forums.mysql.com/read.php?51,158277,158277

Data gets preloaded upon $sth->execute? (1 reply)

Dmitry Nikiforov — Fri, 02 Dec 2011 19:57:46 +0000

Hi

I've been working with both DBD::Oracle and DBD::mysql from my perl scripts, and noticed an odd difference between how they operate. Consider this:

my $oracle = DBI->connect( @oracle_params ) or die $DBI::errstr;
my $mysql = DBI->connect( @mysql_params ) or die $DBI::errstr;

my $query = "select * from table1";

my $sthO = $oracle->prepare( $query );
my $sthM = $mysql->prepare( $query );

Everything is simple so far. But now we do "$sthO->execute()" and then "$sthM->execute()". And this is where the weirdness begins: $sthO->execute returns immediately, while $sthM->execute takes a very long time and a lot of memory. It seems that with MySQL, the query is executed and its results are transferred from the mysql server to the script even before I start fetching the data, while with Oracle no data gets sent until I actually start fetching it with something like "while( my $row = $sthO->fetchrow_arrayref() ) {}".

Can anybody tell my _why_ MySQL sends the results in their entirety? Is there a way to prevent that from happening, and only return rows as I request them?

Regards - D.

selectall_arrayref returns empty Array (1 reply)

Dustin Macdonald — Fri, 18 Nov 2011 05:20:27 +0000

PLEASE HELP: $dbh->selectall_arrayref is returning an empty array.

But, when I run the same query in mysql it returns a lot of data.

The exact same perl code is running and working on a freebsd server, so I know it is written correctly.

I am just having a problem with $dbh->selectall_arrayref on my development machine.

Other functions like $dbh->prepare work fine and return values.

Is there a way to reset or update functions in mysql 5.5?

I did have a hard time installing DBI & DBD::mysql but I finally got them to install smoothly.

My machine: Mac OS X Snow Leopard, Mysql 5.5, Perl 5.10, DBI 1.616, DBD::mysql 4.020.

Any help would be VERY appreciated.

Net::MySQL (1 reply)

Lenny Cheng — Thu, 17 Nov 2011 03:46:08 +0000

Can someone help me with the example of how to use dynamic sql with Net::MySQL? The example in the perldoc for Net::MySQL only give you the example with hardcoded data which is not practice in real life case.

thanks

Lenny

not able to install DBD::mysql on Windows (3 replies)

preetha m — Fri, 06 Jan 2012 02:52:51 +0000

Hi,

I have installed ActivePerl 5.12.4 on my windows machine which is missing DBD:mysql driver. I tried to install it through several ways but cudn't pass through.

This is the error I'm receiving when I perform binary installation.

C:\Perl\bin>ppm install dbd-mysql
Downloading DBD-mysql-4.020...redirect
Downloading DBD-mysql-4.020...done
Unpacking DBD-mysql-4.020...ppm install failed: Can't extract files from C:\User
s\username\AppData\Local\Temp\ppm-x75dhB/DBD-mysql-4.020.tgz

CPAN too doesn't work for me.

I really have no idea of what could be the problem. Have spent real lot time to fix this but hard luck so far. Please help.

Thanks,
Preetha

Help Me please (1 reply)

Ahmad Fathoni — Sun, 30 Oct 2011 17:33:43 +0000

table1
code name A B C D
1 matt 4 6 8 10
2 sam 5 7 9 3
3 jack 6 8 4 2

table2
code name A B C D
1 matt 3 4 5 6
2 sam 2 5 3 4
3 jack 3 7 5 3

result

code : 1
name : matt
desc table1 table2
A 4 3
B 6 4
C 8 5
D 10 6

etc...

how to select and result like above ? thanks for all

What's wrong with my code?? (2 replies)

Dain Hedgpeth — Mon, 24 Oct 2011 17:13:32 +0000

I'm a total noob to Perl. Why isn't this working?? I don't get an error message, it just returns '0' and nothing is added to the database:

---------------------
#!/usr/bin/perl

use Mysql;
use CGI;
use DBI;

print "Content-type: text/html \n\n";

# Read form data etc. dh
my $cgi = new CGI;

my $game = $cgi->param('game');#next 3 dh
my $playerName = $cgi->param('player');
my $score = $cgi->param('score');

exit 0 unless $game; # dh

# MYSQL CONFIG VARIABLES
$host = "xxxx";
$database = "xxxx";
$tablename = "xxxx";
$user = "xxxx";
$pw = "xxxx";

# PERL MYSQL CONNECT()
$connect = Mysql->connect($host, $database, $user, $pw);

# SELECT DB
$connect->selectdb($database);

# DEFINE A MySQL QUERY
$myquery = "INSERT INTO $tablename (game, player, score) VALUES (?,?,?)";

# PREPARE THE QUERY FUNCTION DH
$execute = $connect->prepare($myquery);

# EXECUTE THE QUERY FUNCTION DH
$execute->execute($games, $player, $score);

# AFFECTED ROWS
$affectedrows = $execute->affectedrows($myquery);

# ID OF LAST INSERT
$lastid = $execute->insertid($myquery);

print $affectedrows."
";
print $lastid."
";

-------------------------------

If I replace the lines:

# PREPARE THE QUERY FUNCTION DH
$execute = $connect->prepare($myquery);

# EXECUTE THE QUERY FUNCTION DH
$execute->execute($games, $player, $score);

With:

# EXECUTE THE QUERY FUNCTION
$execute = $connect->query($myquery);

And I put explicit VALUES in the definition of $myquery preceding this line the values are inserted with no issues...

If it helps at all the HTML form code I'm using is:

What's goin on here? I feel like my code matches every example I can find to a tee...

Importing a .tsv file into a mysql table (1 reply)

Hector Mehta — Fri, 07 Oct 2011 15:41:32 +0000

Hi All,

I have a tab separated file (.tsv) which I would like to import into a table. The file is large (around 11GB) in size with 256 columns.

I tried running the following command from the mysql prompt

LOAD DATA LOCAL INFILE 'importfile.tsv'
INTO TABLE test.destination_table
LINES TERMINATED BY '\n';

and it would only copy the first row of the file.

How do I get the entire data set in ? Alternately, if there is another way to do it thru the Workbench interface - that would be even better. Any suggestions, let me know.

Thanks for your help in advance
hector

using Signed Int in table (2 replies)

B A — Wed, 28 Sep 2011 12:07:11 +0000

hi,
I am trying to insert negative integers into one of the columns of my table so I tried to specify the variable as
col1 SIGNED INT NOT NULL,

however, that gives an error. how do I fix this, so my col1 can accept negative integers. thx!

Load data is slow (no replies)

John Stricklen — Fri, 16 Sep 2011 18:20:35 +0000

Greetings! I am loading data from a file to a table using "load data local infile" and have found that loading on the same server is quite a bit faster than if I load to a database that is across the network. The file is between 50 and 60 million records, almost 4 GB in size, pipe (|) delimited, database is 5.0.51a. I am using a Perl script (DBI module) to connect to the database and run the load statement.

I understand that loading over the network will always be a little slower, but this is slow by a factor of 2 to 3. Is this normal?

I have found the folloiwng (times are approximate and vary quite a bit):
Loading from server A to a database on server A: 12 to 15 minutes
Loading from server A to server B over Gigabit ethernet: 45 to 90 min. (the preferred production configuration)
Transferring the file from A to B using sftp: 2 min.
Loading server B to database on server B 12 to 15 min. (using MySQL command prompt).

There are no indexes on the table but there is a primary key. There are no rows in the table when the load starts.

Things I've tried so far:
Using the mysql command prompt. Over the network is still slow but is a little faster than the Perl DBI connection. I tried this in the Perl script using a qx() to run the command. Again, it is a little faster, but not significant.

Increasing BULK_INSERT_BUFFER_SIZE=256217728. No change.

Increasing MYISAM_SORT_BUFFER_SIZE=256217728. No change.

Using Disable Keys. No change.

Given the data above it seems this has to be the MySQL protocol, not the network and not either server.

Any suggestions what to look at in terms of variables to change, network monitoring, and troubleshooting would be appreciated.

Thanks!

John