Nick Pasich writes:
After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics
when using mysqlimport. (Records: Deleted: Skipped: Warnings:)
I took a quick look at 3.23.32 mysqlimport.c and it is the same code as
3.23.35.
The command
---
mysqlimport
After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics
when using mysqlimport. (Records: Deleted: Skipped: Warnings:)
I took a quick look at 3.23.32 mysqlimport.c and it is the same code as
3.23.35.
The command
---
mysqlimport --ignore --verbose --fields-terminated
After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics
(Records: Deleted: Skipped: Warnings:) when using mysqlimport.
I took a quick look at 3.23.32 mysqlimport.c and it is the same code as
3.23.35.
The command
---
mysqlimport --ignore --verbose --fields-terminated
, I type: mysqlimport -d --local cur myfile.txt
where -d means delete the existing records, --local means get the file from the
client, cur is my table and myfile.txt is the file on my hard drive. Again, I get
parse errors.
Any thoughts on the command string?
Also, how do I specify
, then login to the mysql server with mysql
-hlocalhost.isp.com. -p databasename
Then from mysql, I type: mysqlimport -d --local cur myfile.txt
mysqlimport is a command you would start from the telnet prompt,
not from the mysql prompt.
where -d means delete the existing records, --local means
inning, so mysqlimport was useless where the database did
not yet exist. Do I have to manually add those lines to transfer a
dump file to a new machine?
John Jensen
520 Goshawk Court
Bakersfield, CA 93309
661-833-2858
-
Befo
errors like:
ERROR 1046 at line 10: No Database Selected.
Line 10 just says "CREATE TABLE Test (" with only comment preceeding,
until I realized that mysqldump was not putting:
CREATE DATABASE Test;
USE Test;
at the beginning, so mysqlimport was useless where the database did
not yet
I suppose that only way to reorganize unique field is to use another table.
- Original Message -
From: Irmund Thum [EMAIL PROTECTED]
To: Rus [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 8:53 AM
Subject: Re: mysqlimport - LOAD DATA LOCAL INFILE
Rus schrieb
Rus schrieb:
Maybe it's problem with end_of_line symbol.
You could use PHP to insert records directly into db.
- Original Message -
From: Irmund Thum [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, February 12, 2001 2:30 PM
Subject: mysqlimport - LOAD DATA LOCAL INFILE
201 - 209 of 209 matches
Mail list logo