Subject: mysqlimport --use-threads / mysqladmin processlist
I'm in the middle of migrating an InnoDB database to an NDBCluster. I
use mysqldump to first create two dumps, the first one contains only
the database schema, the second one contains only tab delimited data
(via mysqldump --tab). I
the basis of my assumption is a *hunch* only).
I'm not sure (yet) if a single-threaded operation would run into an
i/o bottleneck. I didn't run mysqlimport using --use-threads=1 just
yet (will do if I have the time), but when I've ran it with
--use-threads=4 the import (of a ~500 MB dump) took more time
, etc.) import it and after this I import
the InnoDB data *as is* using mysqlimport.
I use it like this:
mysqlimport --local --use-threads=4 db dir/*.txt
(dir of course cotains the tab delimited data I dumped before.)
The import starts, and I check its progress via mysqladmin, like
|
+--+--++
4 rows in set (0.00 sec)
=
Before you ask, the mysql CLI is also using a named pipe.
Windows Vista 32-bit
MySQL version 5.1.31-community
Mysqlimport Ver 3.7 Distrib 5.1.31, for Win32 (ia32)
What am I missing?
Regards,
Jerry Schwartz
Global Information
It's been a long time sine I used mysqlimport, but you might want to try:
- using --fields-terminated-by rather than --fields-terminated
- losing (or escaping) the backticks in --columns=
- checking my.cnf to see if the client settings are the same for mysql
and mysqlimport
- checking user
-Original Message-
From: Carsten Pedersen [mailto:cars...@bitbybit.dk]
Sent: Monday, January 03, 2011 1:48 PM
To: Jerry Schwartz
Cc: 'mos'; mysql@lists.mysql.com
Subject: Re: mysqlimport doesn't work for me
It's been a long time sine I used mysqlimport, but you might want to try:
- using
zcat /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz | mysql -h
192.168.0.224 -u root -p alba2
Cheers
Claudio
2009/3/11 Rob Wultsch wult...@gmail.com
On Tue, Mar 10, 2009 at 7:16 PM, René Fournier m...@renefournier.com
wrote:
OK, I've managed to do the same thing with just the
Thanks. That works great.
On 10-Mar-09, at 9:36 PM, Rob Wultsch wrote:
On Tue, Mar 10, 2009 at 7:16 PM, René Fournier m...@renefournier.com
wrote:
OK, I've managed to do the same thing with just the mysql command
line
program:
mysql -h 192.168.0.224 -u root -p alba2
I'm writing script that, each night, copies a small database to my
laptop on the local network. I'm having trouble getting it to work.
Here's my syntax so far (run on the server):
mysqlimport --host=192.168.0.224 --user=root --password alba2
alba2_2009-03-10_00h45m.Tuesday.sql
Which
:
I'm writing script that, each night, copies a small database to my
laptop on the local network. I'm having trouble getting it to work.
Here's my syntax so far (run on the server):
mysqlimport --host=192.168.0.224 --user=root --password alba2
alba2_2009-03-10_00h45m.Tuesday.sql
Which
trouble getting it to work. Here's my
syntax so far (run on the server):
mysqlimport --host=192.168.0.224 --user=root --password alba2
alba2_2009-03-10_00h45m.Tuesday.sql
Which produces:
---
mysqlimport: Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL
info if we had
ill intents.
Sent from my Verizon Wireless BlackBerry
-Original Message-
From: Darryle Steplight dstepli...@gmail.com
Date: Tue, 10 Mar 2009 22:20:26
To: René Fournierm...@renefournier.com
Cc: mysqlmysql@lists.mysql.com
Subject: Re: mysqlimport remote host problem
Hi
On Tue, Mar 10, 2009 at 7:16 PM, René Fournier m...@renefournier.com wrote:
OK, I've managed to do the same thing with just the mysql command line
program:
mysql -h 192.168.0.224 -u root -p alba2
/Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql
Works great. However, the sql file
Hi,
I have a huge table with about 50 millions of rows.
I dumped the table using mysqldump -T , as text dump, and now trying
to import it to a database on another server, but it keeps hanging.
Are there any options or server variables I can set to help out with it?
Thanks,
Shuly.
--
MySQL
Hello Shuly,
Try this.
http://www.mysqlperformanceblog.com/2008/07/03/how-to-load-large-files-safely-into-innodb-with-load-data-infile/
On Tue, Feb 24, 2009 at 1:08 PM, Shuly Avraham sh...@cshl.edu wrote:
Hi,
I have a huge table with about 50 millions of rows.
I dumped the table using
Thanks for the resource!
However, I am loading into a MyISAM table, while logging is disabled.
In a matter of fact, I was able to load the data at the end, after
disabling the keys. But now, as I try to create the keys, it takes a
huge amount of time. there are 250 Million rows in one of
the command inside computer_inventory data folder as follows:
Mysqlimport -u root -p computer_inventory disposed.csv
And got the error:
Mysqlimport: Error: Data truncated for column 'mot_id' at row 1, when using
table: disposed
What am I doing wrong?
[cid:image001.jpg@01C91A66.5935E360]
inline
Hi,
I've been trying to import a 10G dump file using mysqlimport
and it is eventually failing because it runs out of tmpdir
space -- I get Errcode: 28.
I was surprised that it was using a temp file at all. I've
looked in the documentation and other sources but have not been
able to find
Mysql use tmpdir,
when ever there is any index creation.
regards
anandkl
On 8/21/08, jthorpe [EMAIL PROTECTED] wrote:
Hi,
I've been trying to import a 10G dump file using mysqlimport
and it is eventually failing because it runs out of tmpdir
space -- I get Errcode: 28.
I was surprised
to import a 10G dump file using mysqlimport
and it is eventually failing because it runs out of tmpdir
space -- I get Errcode: 28.
I was surprised that it was using a temp file at all. I've
looked in the documentation and other sources but have not been
able to find anything about this file
i read about mysqlimport load data infile for mysql, but i can't find a
way to import text file using length of column, instead of delimiter
my text file contains fixed length column:
--
i can use ms excel to convert all files to .csv format and import, but it
would
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
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
Scott Hamm wrote:
Line 48:
48, 14.729606, 10.1.1.22, 10.182.167.209, TCP, pop3
[SYN,
ACK] Seq=0 Ack=1 Win=16384 Len=0 MSS=1460
Is the line 48 is different than other lines?
--
View this message in context:
http://www.nabble.com/mysqlimport-problem-with-%2C-inside-fields
I've been trying to import fields that contains the comma character ','
inside double quotes '', with the results following:
code
mysqlimport --fields-optionally-enclosed-by= --fields-terminated-by=,
--lines-terminated-by=\r\n --ignore-lines=1 --user=root --password shark
c:\documents
Hey Scott -
I dont think you can use , with mysqlimport as a field separator if it is
part of the data. use something else - I used the pipe | character...
This is what worked for me:
C:\mysqlimport --fields-enclosed-by= --fields-terminated-by=|
--lines-terminated-by=\r\n --ignore-lines=1
,
error1 int(3),
error2 int(3),
error3 int(3),
error4 int(3),
error5 int(3),
unique key(filename,ord),
index(filename)
);
/*
Been trying to get mysqlimport to use these characters to no avail, how do I
get around to it?
*/
On 2006-10-04 Scott Hamm wrote:
OBJECTIVE:
INPUT:
E524541015.txt:20061004|,535,999|Scot|Hamm|,410|||101 Walter
Rd|Dover|MD|76709|,041|
...
Been trying to get mysqlimport to use these characters to no avail, how do
I get around to it?
I can't answer your question but think that you're
I don't think you can do this with mysqlimport. It wouldn't be hard to do
with Perl or PHP, though, and that could be automated any way you want with
a shell script.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX
I need to update a table with the contents of a CSV file regularly, I've
used mysqlimport to load all the initial data, but I have a problem with
using it for updates. The data in the CSV file does not contain all of the
data in the table, there is a field that is updated by another application
mysqlimport to pull the data from specific
column/row to insert into a specified field? Trying to find an easier
way than typing all of the data into a text file for import.
Thanks,
Hi Jim,
that needs some preprocessing, but 'sed' is your friend. You could use
some shell script doing
| 23.19 | 28.52 |
96.21 | 18.87 | 32.14 | 10.31 | 30.95 | 11199.93 | 2078.81 | 1278.55 |
Is there a way to get mysqlimport to pull the data from specific
column/row to insert into a specified field? Trying to find an easier
way than typing all of the data into a text file for import
table for this data is in this format
| 2006-08-02 | 20.72 | 8.81 | 10.08 | 22.19 | 20.48 | 23.19 | 28.52 |
96.21 | 18.87 | 32.14 | 10.31 | 30.95 | 11199.93 | 2078.81 | 1278.55 |
Is there a way to get mysqlimport to pull the data from specific
column/row to insert into a specified field? Trying
Gabriel PREDA schrieb:
Try:
ALTER TABLE `tbl_name` DISABLE KEYS;
-- now insert in the TXT file
ALTER TABLE `tbl_name` ENABLE KEYS;
I think this is what you were looking for !
That would have been a possibility. I did it this way now:
...
echo set sql_log_bin=0; set foreign_key_checks=0;
mysqldump -u [user] -h [host] -p [database] [table] fixme.sql
This is for one table.
As I need it for all my tables in all my databases, I'd have to write a
script for that.
And as --tab uses less space, I prefer --tab option for mysqldump.
--
MySQL General Mailing List
For list archives:
Hello
When I re-insert dumped data with mysql file.sql, I can simply put
set foreign_key_checks=0; at the beginning of the file and this works
fine.
How can I achieve this when inserting a text file that is read with
mysqlimport?
I tried to put the mentioned sql-statement in the txt-file
On Thursday 20 July 2006 04:10 am, Dominik Klein wrote:
Hello
When I re-insert dumped data with mysql file.sql, I can simply put
set foreign_key_checks=0; at the beginning of the file and this works
fine.
So do it that way
So if there's any other well-known solution for per-table
Try:
ALTER TABLE `tbl_name` DISABLE KEYS;
-- now insert in the TXT file
ALTER TABLE `tbl_name` ENABLE KEYS;
I think this is what you were looking for !
--
Gabriel PREDA
Senior Web Developer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I imported the data of the table using mysqlimport.
I used the following command line.
$ mysqlimport -ukawabe -paaa -h192.168.1.92 --local kawabe
C:\index_test.txt
kawabe.index_test:
Records: 4 Deleted: 0 Skipped: 4 Warnings: 2
I want to show the contents of warning ,so I
A batch script or shell script can easily be written to do this.
-Sheeri
On 2/20/06, Daniel Kasak [EMAIL PROTECTED] wrote:
I've got some import scripts that are giving me trouble.
Some MOFOs keep changing the format of the data they give us, and
sometimes I loose half the records. When this
On 2/22/06, sheeri kritzer [EMAIL PROTECTED] wrote:
A batch script or shell script can easily be written to do this.
-Sheeri
On 2/20/06, Daniel Kasak [EMAIL PROTECTED] wrote:
I've got some import scripts that are giving me trouble.
Some MOFOs keep changing the format of the data they
]
Sent: Monday, February 20, 2006 11:21 PM
To: mysql@lists.mysql.com
Subject: mysqlimport, \r\n and \n
I've got some import scripts that are giving me trouble.
Some MOFOs keep changing the format of the data they give us,
and sometimes I loose half the records. When this happens, I
running on
Linux.
Unfortunately the import routine is being triggered from MS Access ...
and come to think of it, I'm using 'load data infile' and not
'mysqlimport', but anyway, you get the idea. AFAIK there is no way to
trigger anything useful via ODBC. I could write a Perl script, chuck
' and not
'mysqlimport', but anyway, you get the idea. AFAIK there is no way to
trigger anything useful via ODBC. I could write a Perl script, chuck it
in my cgi-bin folder, and opening Firefox from Access, passing the
script some pointers to the file. But that's dodgy. I suppose while I'm
I've got some import scripts that are giving me trouble.
Some MOFOs keep changing the format of the data they give us, and
sometimes I loose half the records. When this happens, I change the line
terminator from \r\n to \n ... or from \n to \r\n.
It's starting to get to me. Is there any
Hello Listers,
Can anyone explain what are valid values for the 'debug options' on a
mysqlimport ? The manuals just say :
--debug[=debug_options], -# [debug_options]
Write a debugging log. The debug_options string often is 'd:t:o,file_name'.
What is d: ? t: ? o (ok,thats
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/the-dbug-package.html
P. Evans wrote:
Hello Listers,
Can anyone explain what are valid values for the 'debug options' on a
mysqlimport ? The manuals just say :
--debug[=debug_options], -# [debug_options]
Write
://www.hotscripts.com/Detailed/28161.html (note, I claim no
liability, I just found that script doing a web search).
-Sheeri
On 11/22/05, Jacek Becla [EMAIL PROTECTED] wrote:
Hi,
Is there a way to load a section of an input file into mysql
(MyISAM table) using mysqlimport or LOAD DATA INTO?
The input data
Hi,
Is there a way to load a section of an input file into mysql
(MyISAM table) using mysqlimport or LOAD DATA INTO?
The input data is in relatively large ascii files (10 million
rows per file), and I'd like to break the load into smaller
pieces rather than load whole file at once. Of course I
Hi Guys,
I have been searching for the answer to this question for a while. The
answer is so obvious, yet there was no useful source of documentation
that showed it. I am using the load data infile syntax rather than the
command line utility. To get the warnings the show warnings command
is
Hi
The subject says it all! My mysqlimport command reports 43 warnings,
but I have no idea how to access them. SHOW WARNINGS was only
implemented after MySQL version 4.1, and I have 4.0.15-standard-log.
Any help?
Many thanks
Mick
--
MySQL General Mailing List
For list archives: http
Hello.
Similar questions are often asked on the list, but I don't remember
any solution for old versions.
michael watson (IAH-C) [EMAIL PROTECTED] wrote:
Hi
The subject says it all! My mysqlimport command reports 43 warnings,
but I have no idea how to access them. SHOW
to actually
output any information.
Here's my command:
mysqlimport -v -h [host] [database]
[table_and_file_name].csv -u [username] -p
Here's my version info:
mysqlimport Ver 3.4 Distrib 4.0.18, for pc-linux
(i686)
Here's my output to STDOUT/STDERR:
Connecting
' param seems to actually
output any information.
Here's my command:
mysqlimport -v -h [host] [database]
[table_and_file_name].csv -u [username] -p
Here's my version info:
mysqlimport Ver 3.4 Distrib 4.0.18, for pc-linux
(i686)
Here's my output to STDOUT/STDERR:
Connecting to [hostname]
Selecting
Hi,
Anyone know how to find out what are the rows that are reported by
mysqlimport as deleted?
Thanks
HT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes I am appending to the end of an existing database. So why are rows 1
to N locked if I'm only adding rows at N+1? Wouldn't the write
privileges apply to rows being modified? And during this period even an
interactive mysql shell hangs until the mysqlimport completes. i.e. I
the database
I have been trying to use mysqlimport to load a primarily read only
database with data at regular intervals. My problem occurs when my
tables are myisam. In this case all access to the database and the
tables blocks until mysqlimport completes. The -lock-tables=false
parameter does not help
Hi Joseph,
I have been trying to use mysqlimport to load a primarily read only
database with data at regular intervals. My problem occurs when my
tables are myisam. In this case all access to the database and the
tables blocks until mysqlimport completes. The -lock-tables=false
parameter does
I need to update a table with mysqlimport.
I would like to update the table lines with the same unique key and
mantain the other lines untouched.
When I use mysqlimport --replace the table lines with the same
unique key are updated but the others are deleted.
Is it the expected behavior? How
Please do not consider the previous email. I found my error.
mysqlimport is behaving exactly as expected.
Regards, Clodoaldo Pinto
On Sat, 29 Jan 2005 15:53:48 -0200, Clodoaldo Pinto
[EMAIL PROTECTED] wrote:
I need to update a table with mysqlimport.
I would like to update the table lines
be
nice if the documentation for mysqlimport would at least make note of this.
Thanks for the response.Settles, Aaron [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net
Sure enough... I just installed the latest 4.1 linux binaries, I didn't
realize that the server itself had to be compiled with the debug enabled
(although now that I realize that it makes complete sense). It would be
nice if the documentation for mysqlimport would at least make note
the debug switch with mysqlimport so that I can figure
out why I'm getting errors on the data I'm importing, but I have yet to
figure out a way to do this. I've tried to read the sparse documentation
concerning this feature and no debug file is ever produced. I've tried
using it as indicated
I'm trying to utilize the debug switch with mysqlimport so that I can figure
out why I'm getting errors on the data I'm importing, but I have yet to
figure out a way to do this. I've tried to read the sparse documentation
concerning this feature and no debug file is ever produced. I've tried
Hi,
I just wondering if anyone notice or can confirm this: I tried to load
11 million records using mysqlimport using both 4.1.3b and 4.0.20.
4.1.3b took 1.5 hours, but the 4.0.20 took over 10 hours. This
includes loading the data and then build the index.
Thanks
Haitao
--
MySQL General
Subject: HP-UX 11.11/4.0.20 mysqlimport BUS ERROR
Description:
Installed mysql from the binary download on mysql.com
according to the INSTALL-BINARY instructions. Attempted
to use mysqlimport as described in the online documentation
(http://dev.mysql.com/doc
;
mysqlimport --fields-terminated-by=',' --ignore-lines=1 db_name Bank.CSV;
done
Something tells me that greater minds have a better way.
--
___ Patrick Connolly
{~._.~}
_( Y )_ Good judgment comes from experience
(:_~*~_:) Experience comes from bad judgment
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
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
[EMAIL PROTECTED] wrote:
is that a problem?
I want to avoid ftp db.txt files and then mysqlimport them
You should run mysqlimport on the Windows box and specify MySQL server host with -h
option.
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
is that a problem?
I want to avoid ftp db.txt files and then mysqlimport them
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 4:38 PM
Subject: Re: [mysql-php] mysqlimport error
nikos [EMAIL PROTECTED] wrote:
I'm trying
Hello list
I'm trying
mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; -
-lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt
but i get an
Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using
table: programs
What I'm doing wrong?
RH-9 - APACHE
nikos [EMAIL PROTECTED] wrote:
I'm trying
mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; -
-lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt
but i get an
Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using
table: programs
What
Hi Group,
Does anybody have any expierence with mysqlimport and a comma separated
file with data wich contains field data with a: \. For example I have the
data in de column path: C:\temp.
When I import this I got something like : c:||emp ...
Does anybody know how to solve this problem
Can you run a find and replace to double up the backslashes?
\ -- \\
-Original Message-
From: Hans van Dalen
To: [EMAIL PROTECTED]
Sent: 4/28/04 3:46 AM
Subject: mysqlimport and \ as data
Hi Group,
Does anybody have any expierence with mysqlimport and a comma separated
file with data
Ron McKeever [EMAIL PROTECTED] wrote:
I'm trying to use mysqimport instead of LOAD DATA INFILE from a shell
script. I notice an option for mysqlimport is not working or im doing it
wrong.
This works with LOAD DATA INFILE :
mysql -e LOAD DATA INFILE 'x' INTO TABLE x IGNORE 2 LINES
On Tue, 13 Jan 2004, EP wrote:
I am wondering:
I can see the MySQL data files for my various databases.
What technically prevents me from simply copying those files and using copies
- to move my database to another file structure or server
- to back-up my current db
Copying will not work
EP wrote:
I am wondering:
I can see the MySQL data files for my various databases.
What technically prevents me from simply copying those files and using
copies
- to move my database to another file structure or server
- to back-up my current db
Yes, I did put my finger in the electrical
I'm trying to use mysqimport instead of LOAD DATA INFILE from a shell
script. I notice an option for mysqlimport is not working or im doing it
wrong.
This works with LOAD DATA INFILE :
mysql -e LOAD DATA INFILE 'x' INTO TABLE x IGNORE 2 LINES
but when i try:
mysqlimport --ignore-lines=2
I am wondering:
I can see the MySQL data files for my various databases.
What technically prevents me from simply copying those files and using copies
- to move my database to another file structure or server
- to back-up my current db
Yes, I did put my finger in the electrical socket as a kid.
In the last episode (Jan 13), EP said:
I am wondering:
I can see the MySQL data files for my various databases.
What technically prevents me from simply copying those files and using
copies
- to move my database to another file structure or server
- to back-up my current db
Absolutely
--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
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
]
rfam.pl cc:
Subject: Problem with mysqlimport
12/09/2003 10:27
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
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
- Original Message -
From: Matt Griffin [EMAIL PROTECTED]
To: 'Pawe3 Filutowski
Paul,
--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?
Matt
-Original Message-
From: Pawe Filutowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December
Good question - mysqlimport seems to work siliently and not report any errors. I had
read that this was to be improved in 4 - has it ??
appreciate answers
Thomas
-Original Message-
From: Greg G [mailto:[EMAIL PROTECTED]
Sent: 02 December 2003 15:22
To: [EMAIL PROTECTED]
Subject
I'm having a tough time with the debug options for mysqlimport. I've
check the docs, but they're as clear as mud. I've tried a number of
combinations of -#d:t:o,filename and everything else I can think of, but
I can't get any debug information.
What I'm really looking for is to get the text
Good morning,
We recently put a new server online (FreeBSD) with MySQL version 4.0.15.
I have a couple of AWK scripts which used to work properly (on another
FreeBSD server with 3.23.n MySQL) with mysqlimport. Now I am getting the
following error...
/usr/local/bin/mysqlimport: Error: The used
May Yang [EMAIL PROTECTED] wrote:
Dear everyone,
I'd like to ask you a question, thanks in advance.
Q: How long will it take to import 100GB data into MySQL DB by command mysqlimport
?
Depends on how many records are to be inserted. Hard to tell not knowing your hardware
and record
Dear everyone,
(B
(BI'd like to ask you a question, thanks in advance.
(B
(BQ: How long will it take to import 100GB data into MySQL DB by command "mysqlimport" ?
(B
(BBest regards,
(BMay Yang
(B
(B
(B--
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql
Cersosimo, Steve [EMAIL PROTECTED] wrote:
Am I wrong to assume mysqlimport is supposed to emulate the LOAD DATA INFILE
syntax? I cannot find the command line option to turn on the CONCURRENT
flag.
CONCURRENT currently is not supported by mysqlimport.
--
For technical support contracts
Am I wrong to assume mysqlimport is supposed to emulate the LOAD DATA INFILE
syntax? I cannot find the command line option to turn on the CONCURRENT
flag.
Steve Cersosimo
When all is said and done, more is said than done
*
The information transmitted is intended only for the person
I've unable to load data from files into existing tables. When I give the command:
mysqlimport [database] [filename] I keep getting the following error.
mysqlimport: Error: Can't get stat of '[filename]' (Errcode: 13), when using table:
[table]
I get a similar error when trying to use LOAD
Check file permissions.
The file must be readable by the user 'mysql'.
Will Tyburczy wrote:
I've unable to load data from files into existing tables. When I give the command: mysqlimport [database] [filename] I keep getting the following error.
mysqlimport: Error: Can't get stat of '[filename
Will Tyburczy [EMAIL PROTECTED] wrote:
I've unable to load data from files into existing tables. When I give the command:
mysqlimport [database] [filename] I keep getting the following error.
mysqlimport: Error: Can't get stat of '[filename]' (Errcode: 13), when using table:
[table]
I
Carl Anthony-uzoeto [EMAIL PROTECTED] wrote:
I need to periodically load a dumpfile from another DB into
mysql. Now, since this is a cronjob, and for which I would
need to avoid interactivity, I DO NEED to run this as a
non-root user.
I have setup such a user, and have granted the user
this db
on another server using mysqlimport:
mysqlimport -u root -p dbname 'dbname.dump'
I keep getting the error:
Error: Table 'dbname.dbname' doesn't exist, when using table: dbname
My question: Why is mysqlimport interpreting the dbname argument as a table
name?
From the documentation
for each table in the database. When I try to recreate this db
on another server using mysqlimport:
mysqlimport -u root -p dbname 'dbname.dump'
mysqlimport is not the complement of mysqldump, it is a command-line
interface to the LOAD DATA INFILE statement.
To import the dump file, use mysql:
mysql -u
1 - 100 of 209 matches
Mail list logo