Problem with mysqlimport and timestamp

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

Re: Problem with mysqlimport and timestamp

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

update problem with mysqlimport (bug/misuse?)

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 SLOW. SO I read carefully

Re: update problem with mysqlimport (bug/misuse?)

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 executes and UPDATE for each

Re: Problem with mysqlimport

--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

Problem with mysqlimport

have serious problem. System indicates problem: mysqlimport: Error: Can't get stat of '/root/mysql/gwarancje.txt' (Errcode: 13), when using table: gwarancje where gwarancje is the name of table. I tryed to set privileges by chmod 777 command or smilar but it still doesn`t work. Does anybody have

Re: Problem with mysqlimport

] rfam.pl cc: Subject: Problem with mysqlimport 12/09/2003 10:27

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:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:27 AM To: [EMAIL PROTECTED] Subject: Problem with mysqlimport I tryed

Re: Problem with mysqlimport

' [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

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

Problem with mysqlimport.

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

Re: Problem with mysqlimport.

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.

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

Problem with mysqlimport

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

Re: Problem with mysqlimport

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

, 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

problem with mysqlimport

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

re: problem with mysqlimport

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

* [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

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

Problem with MySQLImport utility

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 - -fields-terminated-by=, test newtest.txt

Re: Problem with MySQLImport utility

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

* [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 -