Re: Problem with mysqlimport and timestamp

2007-10-18 Thread mysql
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

Re: Problem with mysqlimport

2003-12-10 Thread Pawe Filutowski
--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

Re: Problem with mysqlimport

2003-12-09 Thread jeffrey_n_Dyke
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

RE: Problem with mysqlimport

2003-12-09 Thread Matt Griffin
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

Re: Problem with mysqlimport

2003-12-09 Thread Pawe 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 mysqlimport. Matt -Original Message- From: Pawe Filutowski [mailto

RE: Problem with mysqlimport

2003-12-09 Thread Matt Griffin
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

Re: Problem with mysqlimport.

2003-07-02 Thread gerald_clark
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,

Re: Problem with mysqlimport.

2003-07-02 Thread Paul DuBois
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

Re: Problem with mysqlimport

2003-01-17 Thread gerald_clark
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

Re: Problem with mysqlimport

2003-01-17 Thread Diana Soares
, 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

re: problem with mysqlimport

2002-10-17 Thread Egor Egorov
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

Re: Problem with MySQLImport utility

2002-07-01 Thread Roger Baklund
* [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 -

Re: Problem with MySQLImport utility

2002-06-26 Thread Victoria Reznichenko
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

Re: Problem with MySQLImport utility

2002-06-25 Thread (Borus.Kung)
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

Re: Problem with MySQLImport utility

2002-06-25 Thread Roger Baklund
* [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 -