qt4x11 wrote:
Hi-
I'm using the command 'mysqlimport -u usr -ppassh -h mysqlserver -P 3306 -v
db --local $workdir/$filename'to import a table into mysql from a file
$filename.
The data in $filename looks something like:
test test
where there is a blank space between the two 'test's to represen
Hi-
I'm using the command 'mysqlimport -u usr -ppassh -h mysqlserver -P 3306 -v
db --local $workdir/$filename'to import a table into mysql from a file
$filename.
The data in $filename looks something like:
test test
where there is a blank space between the two 'test's to represent an empty
colum
At 12:03 -0300 7/5/04, j llarens wrote:
Hi people
I'm facing a (not huge) problem with mysqlimport.
The mysql version I'm using is MySQL
4.0.11a-gamma'-Max'
For updating a #29000 records table from fixed-lenght
ASCII file, I'm using a php script that gets a record
and exe
Hi people
I'm facing a (not huge) problem with mysqlimport.
The mysql version I'm using is MySQL
4.0.11a-gamma'-Max'
For updating a #29000 records table from fixed-lenght
ASCII file, I'm using a php script that gets a record
and executes and UPDATE for each one: pretty S
> --local is a valid option for mysqlimport in 3.23.49 according to the
> manual. (Source: http://www.cict.fr/app/mysql/manual.html#mysqlimport)
> What is the entire command you are using?
Hi,
My command is:
mysqlimport -p -L ilk gwarancje.txt
And I get error:
"mysqlimport: Error: The used co
09, 2003 12:06 PM
To: [EMAIL PROTECTED]
Subject: Re: Problem with mysqlimport
I tryed this option but i got following error:
"mysqlimport: Error: The used command is not allowed with this MySQL
version, when using table: gwarancje"
MySQL version is 3.23.49
What Can I do ?
PROTECTED]>
To: "'Pawe3 Filutowski'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 09, 2003 5:11 PM
Subject: RE: Problem with mysqlimport
> If the the file is on the same machine as your shell is running,
> specify --local when running my
If the the file is on the same machine as your shell is running,
specify --local when running mysqlimport.
Matt
-Original Message-
From: Paweł Filutowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:27 AM
To: [EMAIL PROTECTED]
Subject: Problem with mysqlimport
I tryed
[EMAIL PROTECTED]>
rfam.pl> cc:
Subject: Problem with mysqlimport
I tryed to import from text file (columns divided by tabulators) like this:
5724KF2003CSDEUROPAPARKAN2003-12-12MarcinTamkanono
.
.
.
On PHPTriad (under Windows 2000) it works perfectly !
I use command: mysqlimport database file.txt
But under Linux (RedHat) i h
At 14:18 +0100 7/2/03, Idries Hamadi wrote:
Hi all,
I've just started using mysql and I'm sure that my all problems are
something todo with my oracle-ness, so please bear with me if I use
case-insensitive table names or somthing ;)
Ok. I've been using the mysql interactive command-line interface f
Idries Hamadi wrote:
Hi all,
I've just started using mysql and I'm sure that my all problems are
something todo with my oracle-ness, so please bear with me if I use
case-insensitive table names or somthing ;)
Ok. I've been using the mysql interactive command-line interface for a few
days now, a
Hi all,
I've just started using mysql and I'm sure that my all problems are
something todo with my oracle-ness, so please bear with me if I use
case-insensitive table names or somthing ;)
Ok. I've been using the mysql interactive command-line interface for a few
days now, and there's no problem t
ME FOLLOWING ERROR:
>
> mysqlimport: Error: Table 'test.UM' doesn't exist, when using table: UM
>
> So, this is my problem.
>
> Thanks for your immediate reply
>
> Thanks & Regards,
>
> Shripal.
>
> - Original Message -
> From:
Do not use mysqlimport.
That is for flat file import.
mysql test < UM.txt
Shripal Shah wrote:
Dear Sir/Madam,
I've one data file which is built with the help of mysqldump. This file
contains structure & data of 2 tables of test database. Like this..
mysqldump -C --add-drop-table -e test patie
Dear Sir/Madam,
I've one data file which is built with the help of mysqldump. This file
contains structure & data of 2 tables of test database. Like this..
mysqldump -C --add-drop-table -e test patient hospital > UM.txt
then I am trying to import data using this statement..
mysqlimport test UM
I'm trying to import an access database table into MySQL
This is what I've done:
created a database testdb in access with a table cop
exported the table as comma separated values into cop.txt
created a database called testdb in mysql,
created a table called cop of the same structure as the acces
Julia,
Thursday, October 17, 2002, 2:29:57 PM, you wrote:
JM> This is what I've done:
JM> created a database testdb in access with a table cop
JM> exported the table as comma separated values into cop.txt
JM> created a database called testdb in mysql,
JM> created a table called cop of the same
* [EMAIL PROTECTED]
> Hie
> I'm new in MySQL.anyone out there can help please?
> I'm actually experimenting with the mysqlimport utility to import
> data from
> a text file.however i'm always getting this error upon the command
>
> c:\mysql\bin>mysqlimport - - local - -fields
ericloe,
Tuesday, June 25, 2002, 12:17:03 PM, you wrote:
e> I'm new in MySQL.anyone out there can help please?
e> I'm actually experimenting with the mysqlimport utility to import data from
e> a text file.however i'm always getting this error upon the command
c:\mysql\bin>m
* [EMAIL PROTECTED]
> I'm new in MySQL.anyone out there can help please?
> I'm actually experimenting with the mysqlimport utility to import
> data from
> a text file.however i'm always getting this error upon the command
>
> c:\mysql\bin>mysqlimport - - local - -fields-termi
you don't need space between dashes
"--local" instead of "- -local"
Borus
> Hie
> I'm new in MySQL.anyone out there can help please?
> I'm actually experimenting with the mysqlimport utility to import data
from
> a text file.however i'm always getting this error upon the c
Hie
I'm new in MySQL.anyone out there can help please?
I'm actually experimenting with the mysqlimport utility to import data from
a text file.however i'm always getting this error upon the command
c:\mysql\bin>mysqlimport - - local - -fields-terminated-by="," test
newtest.t
23 matches
Mail list logo
