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
--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
is there a higher level directory that does not allow excecution? does it
work if you run it as root? can you 'vi /root/mysql/gwarancje.txt'?
just some thoughts
Jeff
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]; [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 mysqlimport.
Matt
-Original Message-
From: Pawe Filutowski [mailto
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 ??
Regards
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,
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
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
, this is my problem.
Thanks for your immediate reply
Thanks Regards,
Shripal.
- Original Message -
From: Diana Soares [EMAIL PROTECTED]
To: Shripal Shah [EMAIL PROTECTED]
Sent: Friday, January 17, 2003 6:48 PM
Subject: Re: Problem with mysqlimport
Hi,
What version of MySQL
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\binmysqlimport - - local -
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
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 command
* [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\binmysqlimport - - local -
15 matches
Mail list logo