Hi,
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 all on
the destination database. The user also
Thanks Paul, the options file worked fine!
Neil Belch
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Neil Belch [EMAIL PROTECTED]; mySQL List
[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 2:48 AM
Subject: Re: mysqlimport problems
At 0:34 +0100 9/4/03, Neil Belch
, 2003 5:10 PM
To: 'Fortuno, Adam'; [EMAIL PROTECTED]
Subject: RE: mysqlimport command question
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: mysqlimport command question
Darryl,
Provide a copy of the table's details either with a describe
table output or
the table's definition
Hi all, new to the list and new to mySQL...
I've only been at it for a few days and am looking at importing text files to
databases.
I'm having trouble with mysqlimport and would appreciate any help or solutions as to
what I'm doing wrong - I'm sure its a dumb mistake!
I tried LOAD DATA INFILE
At 0:34 +0100 9/4/03, Neil Belch wrote:
Hi all, new to the list and new to mySQL...
I've only been at it for a few days and am looking at importing text
files to databases.
I'm having trouble with mysqlimport and would appreciate any help or
solutions as to what I'm doing wrong - I'm sure its
greetings,
I have created a text file in windows (from a database) that has the format
empnum name fname lname ext email listit bm bd hd
bm, bd are integers and hd is date.
I have tried to import using the follow command
#mysqlimport -u root -pmypass -d --local iweb emp2.txt
it imports the 97
PROTECTED]
Subject: mysqlimport command question
greetings,
I have created a text file in windows (from a database) that has the format
empnum name fname lname ext email listit bm bd hd
bm, bd are integers and hd is date.
I have tried to import using the follow command
#mysqlimport -u root -pmypass
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: mysqlimport command question
Darryl,
Provide a copy of the table's details either with a describe
table output or
the table's definition and a sample of the input file's top 5-rows.
Regards,
Adam
OK, here is the table structure:
mysql
Hi,
I'm importing ~2000 rows using mysqlimport with the following syntax:
mysqlimport -d -v --ignore -u root -p[rootpw] [database] [tablename].txt
Connecting to localhost
Selecting database [database]
Deleting the old data from table [tablename]
Loading data from SERVER file: /[path
and save it as a csv file.
Then I'll use mysqlimport on it.
Then the fun will begin. The data really is in a horrible format. The
order of each row is important. Can I trust mysqlimport to import the
data in the right order, or is it just by chance that that's the way
it's happened so far?
Thanks
there. I've made myself a ~/.my.cnf file
and it appears to work:
[client]
user=idries_wedding
password=**
Since creating it I no longer need to enter username or password details
when I run mysql :)
Now, I'm trying to use mysqlimport:
idries ~/src/wedding/database$ mysqlimport idries_Wedding
, and there's no problem there. I've made myself a ~/.my.cnf file
and it appears to work:
[client]
user=idries_wedding
password=**
Since creating it I no longer need to enter username or password details
when I run mysql :)
Now, I'm trying to use mysqlimport:
How about
[mysqlimport]
user
for a few
days now, and there's no problem there. I've made myself a ~/.my.cnf file
and it appears to work:
[client]
user=idries_wedding
password=**
Since creating it I no longer need to enter username or password details
when I run mysql :)
Now, I'm trying to use mysqlimport:
idries ~/src
Hi, I'm a newbie to MySQL
I have use mysqldump to backup a database to an file named test.sql ,but how I
can load the test.sql to create the same database to another server??
Thanks!
Best Regards
Li Yang
into your audience
-Original Message-
From: Li Yang [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 8:10 PM
To: mysql
Subject: Hi,All ,About mysqldump and mysqlimport
Hi, I'm a newbie to MySQL
I have use mysqldump to backup a database to an file named test.sql
,but how I can
On Sunday 23 March 2003 21:04, Klaus Mueller wrote:
LOAD DATA LOCAL INFILE member.txt INTO TABLE member;
- ERROR 1148: the used command is not allowed with this MySQL version
Does anybody know how to manage these two commands in MySQL 3.23.49?
Add --local-infile=0 to mysqld commandline.
Victoria,
LOAD DATA LOCAL INFILE member.txt INTO TABLE member;
- ERROR 1148: the used command is not allowed with this MySQL version
Add --local-infile=0 to mysqld commandline.
See: http://www.mysql.com/doc/en/LOAD_DATA.html
This doesn't work with MySQL = 4.0.10. I reported to
[EMAIL
Why am I getting this error? I have looked on google and it said to use
the full path when naming the import file. I have done this and still
get the error. What else could I be doing wrong?
#
mysqlimport -d --fields-optionally-enclosed-by=\' --fields-terminated-by=, --use
r=userid --password
Please ignore this this problem as I found the answer. For those inquring minds,
I added a -L to the mysqlimport command and we are all happy now.
James
-Original Message-
From: James E Hicks III [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 2:48 PM
To: Mysql
Subject
On 24-Mar-2003 James E Hicks III wrote:
snipage
mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode:
13), when using table: thefile
localhost.dread$ perror 13
Error code 13: Permission denied
localhost.dread$
--
Don Read
the FILE
privilege on the server host.
Try chmoding it 666 or moving it to the same partition as your MySQL data
dir.
Dan
-Original Message-
From: James E Hicks III [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 2:48 PM
To: Mysql
Subject: mysqlimport: Error: Can't get stat of
Why
Probably a permission problem. If it cannot read the file it cannot import
it.
monster perror 13
Error code 13: Permission denied
-Original Message-
From: James E Hicks III [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 11:48 AM
To: Mysql
Subject: mysqlimport: Error: Can't get
Dear all,
I started to work with the book MySQL from Pau DuBois.
When trying to load data into the samp_db the following two operations
don´t work:
LOAD DATA LOCAL INFILE member.txt INTO TABLE member;
- ERROR 1148: the used command is not allowed with this MySQL version
mysqlimport --local
Linux Redhat 7.3
MySQL 4.0.9-gamma
I tried to import a 900M file with mysqlimport command. Everything works fine.
All the data has been insert into the DB.
However, all the memory has been used up. Before the mysqlimport, I have 800M
free memory, after that, 13M free memory left.
Is there any
Hello -
I am curious what extensions to mysqlimport people might be interested
in seeing.
I am importing some data with inconsistencies and and I find that
mysqlimport helps one not at all. It seems to me that there are things
it could do.
For example:
-rejected_lines=filename : would put
At 16:50 -0800 2/23/03, Ray Kiddy wrote:
Hello -
I am curious what extensions to mysqlimport people might be
interested in seeing.
I am importing some data with inconsistencies and and I find that
mysqlimport helps one not at all. It seems to me that there are
things it could do.
For example
When I tried loading data using the following command from command line:
mysqlimport DatabaseName tablename.txt
I got the following error:
mysqlimport: error : can't get stat of /home/./tablename.txt
However, when I used the following command from mysql prompt, I was able to
load the data
At 22:14 + 2/21/03, Mamatha Balasubramanian wrote:
When I tried loading data using the following command from command line:
mysqlimport DatabaseName tablename.txt
I got the following error:
mysqlimport: error : can't get stat of /home/./tablename.txt
However, when I used the following
Thanks a lot for your help. It works!
From: Paul DuBois [EMAIL PROTECTED]
To: Mamatha Balasubramanian
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: Re: Can't load data using mysqlimport
Date: Fri, 21 Feb 2003 16:32:31 -0600
At 22:14 + 2/21/03, Mamatha Balasubramanian wrote:
When I tried
able to create a new table
ACTL_MAT_VW from database FPY_BRT on Mysql 3.23 but when I used the
mysqlimport from Mysql 4.0 to populate that table , I'm having an error.
The error looks like this:
% mysqlimport -u username -ppassword -h (ip addr of the other
workstation) - - delete - - fields
I have installed MySQL version Release: mysql-3.23.38 (as found in the
mysqlbug.txt). When I use mysqlimport, I get the following error code
ERROR 1148 : the used command is not allowed with this MySQL version.
I get the same message whenever I use LOAD DATA.
WHich version should I install
we get a strange error when trying to import data into our database:
mysqlimport: Error: Can't get stat of 'KUNDEN' (Errcode: 13), when using table: KUNDEN
it is NO permission Problem, the file ist world readable and the user CAN access the
DB.
any hints what else could be the problem
it is NO permission Problem, the file ist world readable and
the user CAN access the DB.
stupid me, it WAS a permission problem. The permission for a directory in the path
wasn't right.
sql, mysql or what else the spam filter needs.
On Tuesday 18 February 2003 12:08, Stefan Immel wrote:
we get a strange error when trying to import data into our database:
mysqlimport: Error: Can't get stat of 'KUNDEN' (Errcode: 13), when using
table: KUNDEN
it is NO permission Problem, the file ist world readable and the user CAN
access
Hi,
You should not use mysqlimport but mysql:
mysql my_db file.sql
See http://www.mysql.com/doc/en/mysqldump.html
for details.
Regards,
Joseph Bueno
Elby Vaz wrote:
I created a file.sql with mysqldump.
mysqldump my_db my_table file.sql
What I do to get this file with the mysqlimport
Elby,
I created a file.sql with mysqldump.
mysqldump my_db my_table file.sql
What I do to get this file with the mysqlimport?
mysqlimport ??
You do this with mysql in batch mode, not with mysqldump:
shell mysql your_database file.sql
Regards
You don't.
you use the file as input to the mysql client.
mysql file.sql
Elby Vaz wrote:
I created a file.sql with mysqldump.
mysqldump my_db my_table file.sql
What I do to get this file with the mysqlimport?
mysqlimport ??
Thanks,
e
I created a file.sql with mysqldump.
mysqldump my_db my_table file.sql
What I do to get this file with the mysqlimport?
mysqlimport ??
Thanks,
e.
_
MSN Messenger: converse com os seus
Hi
I'm trying an import of a 'comma delimited' file and I get this error.
The command
-=-=--=-=-=-=-=
mysqlimport -c
user_id,user_id_lower,passwd_lower,fname,lname,address1,city,state,zip,country,email,email_lower,user_num,team_name,team_city,team_canonical,public_email,league_name,league_pwd
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
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
Hi,
I didn't notice in the other e-mail, but the syntax of mysqlimport says
everything.. :-)
mysqlimport is like LOAD DATA INFILE and imports data to ONE table.
To use your UM.txt you may use:
# mysql test UM.txt
For further explanation of mysqlimport:
# mysqlimport --help
Loads tables
run the following from the shell
prompt:
$:/usr/local/mysql/bin/mysqlimport db1 table1.txt
I get:
/usr/local/mysql/bin/mysqlimport: Error: Access denied for user:
'user1@localhost' (Using password: NO), when using table: table1
--
I want this user 'user1' to be able to run the mysqlimport
.
Try this instead:
grant all on db1.* to user1@localhost
However when as the solaris user 'user1', I run the following from
the shell prompt:
$:/usr/local/mysql/bin/mysqlimport db1 table1.txt
I get:
/usr/local/mysql/bin/mysqlimport: Error: Access denied for user:
'user1@localhost' (Using
On Monday 09 December 2002 16:26, Kekette wrote:
I played with mysqlimport because I must transfer a db from msql to mysql.
I have 1.600.000 records to transfer. Everything's perfect except when I
finished the import, I have Warning:16. All the records were transfered.
So, my question
Hello everybody,
I played with mysqlimport because I must transfer a db from msql to mysql.
I have 1.600.000 records to transfer. Everything's perfect except when I
finished the import, I have Warning:16. All the records were transfered.
So, my question is: is there a log created by mysqlimport
Hello everybody,
I played with mysqlimport because I must transfer a db from msql to mysql.
I have 1.600.000 records to transfer. Everything's perfect except when I
finished the import, I have Warning:16. All the records were transfered.
So, my question is: is there a log created by mysqlimport
file. I then opened the file in BBedit, deleted
duplicates and made other adjustments (like sorting the output
properly) and then saved the file (with unix line breaks).
I then opened a Terminal on a my Mac running OS 10.2.1 and issued
the following command:
mysqlimport -v omomain
In the last episode (Oct 20), Peter J. Schoenster said:
A cohort wrote a script to import tab delimited files. He uses
mysqlimport. He uses the -d option to ONLY empty the data from the
table before importing the new data. My cohort believes that
mysqlimport is also dropping the table
Hi,
A cohort wrote a script to import tab delimited files. He uses
mysqlimport. He uses the -d option to ONLY empty the data from the
table before importing the new data. My cohort believes that
mysqlimport is also dropping the table and then recreating the table
from somewhere
other adjustments (like sorting the output
properly) and then saved the file (with unix line breaks).
I then opened a Terminal on a my Mac running OS 10.2.1 and issued the
following command:
mysqlimport -v omomain
/Users/paul/Desktop/omostuff/csv_files/aproducer.txt
This is what I got in return
as the access table
that works fine.
when I try this:
mysqlimport testdb cop.txt;
I get the error:
The used command is not allowed with this MySQL version when using
table: cop
any hints?
Julia
-
Before posting, please check:
http
structure as the access table
JM that works fine.
JM when I try this:
JM mysqlimport testdb cop.txt;
JM I get the error:
JM The used command is not allowed with this MySQL version when using
JM table: cop
JM any hints?
What version of MySQL are you using? Usually this error ocurs when
LOAD DATA
Greetings,
I have an application that creates an SQL file from the data it
produces, but in some of that data, there might be a , or ' which
mysqlimport does not like. I need to use the mysqlimport utility, and I am
wondering if there is a way around this. I admit I have not tried yet
vinita,
Monday, September 23, 2002, 9:12:24 AM, you wrote:
vvM I can create a database called test,
vvM mysql create database test;
vvM Query OK, 1 row affected (0.03 sec)
vvM BUT I can't create any other databases???
vvM mysql create database tem;
vvM ERROR 1044: Access denied for user:
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to ddb@localhost IDENTIFIED BY 'passwd'
What should go into #, is it a *? but I should NOT given permission
to access other databases.
Thanks
Egor Egorov wrote:
vinita,
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to ddb@localhost IDENTIFIED BY 'passwd'
What should go into #, is it a *? but I should NOT given
permission to access
Hi paul
Paul DuBois wrote:
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to ddb@localhost IDENTIFIED BY 'passwd'
What should go into #, is it a *? but I
At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
Hi paul
Paul DuBois wrote:
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to ddb@localhost IDENTIFIED BY 'passwd'
Paul DuBois wrote:
At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
Hi paul
Paul DuBois wrote:
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to
sql,query
At 11:49 +1000 9/24/02, vinita vigine Murugiah wrote:
Paul DuBois wrote:
At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
Hi paul
Paul DuBois wrote:
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need
sql,query
HI sorry for the confusion.
well.. I want to create a database where I can give *any* name
(ofcourse, the database doesn't exist).
Are you trying to say, I need to ask the root, to give me create
privilege on database xxx, even before it exist, then only I can
create the database
Hi
I can create a database called test,
mysql create database test;
Query OK, 1 row affected (0.03 sec)
BUT I can't create any other databases???
mysql create database tem;
ERROR 1044: Access denied for user: 'ddb@localhost' to database 'tem'
mysql create database proj;
ERROR 1044: Access
the mysqlimport command, and it works perfectly inside
a shell script when run from the command line.
When I try to execute that same shell script with cron, it will not import the file.
The exact script works perfectly in Mac OS 10.1.4.
Also, if I run the mysqlimport command as part of the crontab file
. I'm using the mysqlimport command, and it works perfectly inside
a shell script when run from the command line.
When I try to execute that same shell script with cron, it will not import the file.
The exact script works perfectly in Mac OS 10.1.4.
Also, if I run the mysqlimport command as part
, 2002 4:16 PM
To: Warren, Keith
Cc: [EMAIL PROTECTED]
Subject: Re: Cron and mysqlimport on OS X 10.2
Warren, Keith wrote:
I've created a mysql database solutions that works perfectly in Mac OS X 10.1.4.
However, I've purchased a new G4 running 10.1.2 (Jaguar) and I'm having one
server and did a mysqlimport. I tried:
mysqlimport -u username -p database table_name
I am told that it cannot find the ISM (I think that was the name) file.
Well, nowhere for the mysqldump that I could find did it mention anything
about this.
Clearly I am doing something wrong. I searched for hours
, and I used the following syntax:
[...]
I copied the files to the sparc server and did a mysqlimport. I tried:
mysqlimport -u username -p database table_name
I am told that it cannot find the ISM (I think that was the name) file.
Well, nowhere for the mysqldump that I could find did
Hello to everybody,
I installed mysql ver 11.17 distrib 3.23.49a on redhat
7.2.
I would like to import data into database table using
command line instructions.
I tried mysqlimport but I got the following error
messagge
mysqlimport: Error: The used command is not allowed
with this MySQL version
James,
Tuesday, July 23, 2002, 8:32:10 PM, you wrote:
JC There didn't seem to be any responses to this question last time I posted.
JC So I'll try again. Does anyone know where to locate mysqlimport logs, if
JC there are any?
No, mysqlimport doesn't write logs and you can't see warnings
There didn't seem to be any responses to this question last time I posted.
So I'll try again. Does anyone know where to locate mysqlimport logs, if
there are any?
TIA
James
-Original Message-
From: James Ching [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 4:54 PM
Hi,
Does anyone know where to view mysqlimport logs? After running with
--replace and I can see a number of rows recorded as deleted and some as
warnings. I can't locate any history anywhere - not in the current
directory, not in mysql installation location, not in in syslog...
Thanks much
Hello,
Here is my problem, I would like to use mysqlimport (which i
have compiled as a batch file to run) from a client side to load data onto
the database on a server side, meaning that I would normally access my
server through the pc and running the batch file. Problem
-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 5:42 AM
Subject: Need Help with mysqlimport please-urgent!
Hello,
Here is my problem
* [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 - -fields
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
c:\mysql
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
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 - -fields-terminated
Hello
MySQL 4.0.1 Solaris 2.7 official binary reproducibly crashes with sig
11 when run in a slave mode and when its master (4.0.1 official Linux
binary) is populated via mysqlimport tool from a remote machine.
Here are some interesting log files [edited]:
, $ mysqld --user=mysql
| 020612
Hi!
Receive the message:
mysqlimport: Error: The used command is not
allowed with this MySQL version, when using table: t_parameter.
What´s this??
Thanks,
/Jonas
-
Before posting, please check:
http://www.mysql.com
Jonas,
Friday, May 17, 2002, 4:54:18 PM, you wrote:
JO Receive the message:
JO mysqlimport: Error: The used command is not
JO allowed with this MySQL version, when using table: t_parameter.
Did you tried to use mysqlimport with --local option?
If so, you should specify local-infile
Scott,
Tuesday, April 9, 2002, 6:20:38 PM, you wrote:
SA I been using mysqlimport for a long time with no problems.
SA But today when I try (as root)
SA mysqlimport admin /usr/local/systems/admin/data/person.txt -p
SA I get
SA mysqlimport: Error: Can't get stat of
SA '/usr/local/systems
Hi,
I been using mysqlimport for a long time with no problems.
But today when I try (as root)
mysqlimport admin /usr/local/systems/admin/data/person.txt -p
I get
mysqlimport: Error: Can't get stat of
'/usr/local/systems/admin/data/person.txt' (Errcode: 13), when using
table:
person
even
Hello,
mysqlimport --replace --fields-terminated-by=\| --verbose --user=user --password=mysql
database tables.sql
I'm trying to use the mysqlimport command. I have multiple tables listed in my
table.sql file. But the command requires that the filesname be the same as the table
you try
At 22:04 -0700 3/25/02, Keith Spiller wrote:
Hello,
mysqlimport --replace --fields-terminated-by=\| --verbose
--user=user --password=mysql database tables.sql
I'm trying to use the mysqlimport command. I have multiple tables
listed in my table.sql file. But the command requires
I try to run the import test as listed in the document.
mysqlimport: Error: The used command is not allowed with this MySQL version,
when using table: imptest
My server version: 3.23.49.
What is the problem? How can I fix it?
Thanks!
Danny
Hi:
I had solve MY problem, it was a disk full. But mysql hangs, don't give
an error about it.
Bye.
Rogelio Triviño
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Hi.
That's how the manual describe how MySQL usually handles disk full
conditions (http://www.mysql.com/doc/F/u/Full_disk.html).
Bye,
Benjamin.
On Thu, Feb 28, 2002 at 11:45:35AM +0100, [EMAIL PROTECTED] wrote:
Hi:
I had solve MY problem, it was a disk full. But mysql hangs, don't
From: rogelio
To: [EMAIL PROTECTED]
Subject: bug in mysqlimport with many rows
Description:
if I split a 3 rows file in 5000 chuncks, I can run mysqlimport
on each one over a deleted table
but if I don't use --delete, the first mysqlimport work ok but
the second hangs
Description:
slaves does not honore the mysqlimport --lines-terminated-by='\n\n' switch
How-To-Repeat:
i've set up two machines as master - slave. i start out with a running
replication in a sane state.
now i do on the master:
mysql -e '
drop table TOR5
That means the server does not have permission to read the file.
James E. Hicks III wrote:
What exactly does this error mean?
mysqlimport: Error: Can't get stat of '/home/jameshicks/NONSTOCK' (Errcode: 13),
when using table: NONSTOCK
James
mysql
Hello,
Has anyone experienced and/or solved this problem on a Linux / Apache / MySQL system?
I'm trying to call mysqlimport remotely over CGI using perl's system command, to
upload and import csv files. Basically everything works except for setting the
'--fields-optionally-enclosed
I am sending this again since the first time I sent it I wasn't entirely
signed in to the list.
I am running RedHat linux 7.1 and MySQL 3.23.37. I am trying to use
mysqlimport and am getting an error message mysqlimport: Error: Can't get
STAT of /path/to/file/file (Errorcode: 13) , when
I am running RedHat linux 7.1 and MySQL 3.23.37. I am trying to use
mysqlimport and am getting an error message mysqlimport: Error: Can't get
STAT of /path/to/file/file (Errorcode: 13) , when using table: table_name.
I looked the error up in the on-line documentation and changed the UMASK
;load data
infile" on localserver on my pc in MySQL no problem.
This is syntax I've tried:
command prompt $mysqlimport -u -p -h x --local DBNAME [problem
part not finding try1.txt]
"Errcode: 2 file try1.txt not found for table try1"
Where do I place the text file on my pc for
. The text file is fine. I've done this via "load data infile" on
localserver on my pc in MySQL no problem.
if you mysqlimport or mysql (client) on the win2k box then:
run program on win2k (ie mysqlimport or mysql client)
connect to the remote unix host, eg
c:\mysql\binmysql -u
database server.
1. I have to initially go through SSH to access the remote host server.
Fine, I get through to the shell prompt.
2. I use username, password, and DB Name to access the remote server, which
I handle through the mysqlimport options OK.
3. I understand the basic mysql syntax
the remote server, which
I handle through the mysqlimport options OK.
3. I understand the basic mysql syntax except for interpreting the --local
option :
shellmysqlimport [options] database textfile1
How do I specify the --local option to tell the remote host where to find
the location
Hi Gerald
Thanks a lot for the suggestion, but I'm not sure it will solve my prob,
'cos I dont want to copy a whole DB, and it's not on the same server anyway.
I think it's my --local syntax in the mysqlimport (given in earlier message
posted) that's dodgy. I've also tried an equals sign
101 - 200 of 209 matches
Mail list logo