rmck <[EMAIL PROTECTED]> wrote:
> I thought I could wrap this LOAD DATA option in my perl script which could
> speed things up... Any help is great
You can consider using bulk insert.
See http://dev.mysql.com/doc/mysql/en/INSERT.html and note that you can
insert more than a single row at
In the last episode (Dec 20), ads mysql said:
> Hi,
> I was looking to solution of same problem as Hans
> Kind.
>
> You have suggested to map network drive. Is it O.K.if SAMBA is
> ruuning on main server. Or can you guide to Documentation for mapping
> on Linux. I know it is out of topic but it wi
Hi,
I was looking to solution of same problem as Hans
Kind.
You have suggested to map network drive. Is it O.K.if
SAMBA is ruuning on main server. Or can you guide to
Documentation for mapping on Linux.
I know it is out of topic but it will help me great.
Thanks
--- Larry Brown <[EMAIL PROTECTE
If the servers are on the same local subnet, why not just map a network
drive so both servers have access to the file locally.
-Original Message-
From: Hans Kind [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 8:22 AM
To: [EMAIL PROTECTED]
Subject: load data in file
Hi,
We h
Are you placing the file in the same directory as the MySQL data files? Are
the databases and the location you placed the text file on the same physical
drive?
-Original Message-
From: Hans Kind [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 7:22 AM
To: [EMAIL PROTECTED]
Subje
LOAD DATA LOCAL INFILE
But it must be enabled on both the server and client.
See the docs.
Hans Kind wrote:
Hi,
We have a 2 server setup. 1 server runs the web server with a PHP
application, the second server is the mysql database server.
The php application needs to connect to the mysql server
