On 2015/04/12 08:52, Pothanaboyina Trimurthy wrote:
The problem is , as mentioned the load data is taking around 2 hours, I
have 2 timestamp columns for one column I am passing the input through load
data, and for the column "DB_MODIFIED_DATETIME" no input is provided, At
the end of the load data
Hi All,
I am facing an issue with timestamp columns while working with MySQL load
data in file, I am loading around a million records which is taking around
2 hours to complete the load data.
Before get into more details about the problem, first let me share the
table structure.
CREATE TABLE
Hi Guys,
Need some pointers. I've got a MySQL server (5.0.22) which is basically
pulling data from SQL Server into a file and then I'm using mysqlimport
to load the data into the DB.
The updates are being generated like every 2 to 5 seconds.
Due to this, my Binary Log files are huge! (and many)
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
hello,
I was tring to understand the steps to read from pipe and load using LOAD DATA INFILE?
I dont understand the "x's" or the cat of tcp, can someone shed some light on this for
me??
mkfifo /mysql/db/x/x
chmod 666 /mysql/db/x/x
cat < /dev/tcp/10.1.1.12/4711 > /mysql/db/x/x
mysq
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
; To: [EMAIL PROTECTED]
> Subject: load data in file
>
>
> 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
>
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
]
Subject: load data in file
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, to import data
from a text file. For this we use Load Data Infile.
While
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
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, to import data
from a text file. For this we use Load Data Infile.
While everything else in the applicati
start adding an 'export
directly to MySQL server' option want to know if it is possiable to issue the
'LOAD DATA IN FILE' or 'SOURCE' SQL commands to export the data from the
Windows machine to the FreeBSD machine.
--
Regards,
William Bailey.
Hi,
I just updated a new database with the update log from another server, and
the script failed on the LOAD DATA INFILE commands that I have to import
data overnight from other sources, because, of course, those files didn't
exist.
Now, I know I can use --force to allow the script to complete,
13 matches
Mail list logo
