Thanks !
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 08, 2004 3:18 AM
To: [EMAIL PROTECTED]
Subject: Re: Load data question in cross database replication
Hello.
It seems to be a bug:
http://bugs.mysql.com/bug.php?id=6353
"Sa
ch are not using
> --replicate-rewrite-db. It do not work for those which are using this.
>
> Thanks for you reply.
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 03, 2004 4:14 AM
> To: [EMAIL PROTECTE
:[EMAIL PROTECTED]
Sent: Friday, December 03, 2004 4:14 AM
To: [EMAIL PROTECTED]
Subject: Re: Load data question in cross database replication
Hello.
--replicate-rewrite-db is not taken into account while executing LOAD
DATA
FROM MASTER. See:
http://dev.mysql.com/doc/mysql/en
Hello.
--replicate-rewrite-db is not taken into account while executing LOAD DATA
FROM MASTER. See:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA_FROM_MASTER.html
"Sanjeev Sagar" <[EMAIL PROTECTED]> wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Hello Everyone,
I have a question on using LOAD DATA command in cross database
replication setup. MySQL version is 4.0.21
I have replication farm where few slaves have been set up as cross
database replication slave by using (replicate-rewrite-db).
When Load data command get executed on
Thanks Michael - I was being a putz wasn't I!
You have a file of SQL statements. LOAD DATA INFILE is for importing a
file of data (comma-separated, for example), not for reading a SQL file.
You can do this from the command line with
mysql name_of_db
or within the mysql client program with
You have a file of SQL statements. LOAD DATA INFILE is for importing a file
of data (comma-separated, for example), not for reading a SQL file. You can
do this from the command line with
mysql name_of_db
or within the mysql client program with
source '/tmp/updates.txt';
Michael
J S wrote:
Hi,
I'm trying to load a file containing a set of updates e.g.
UPDATE url_table SET hits=3 WHERE
url="http://cache.unicast.com/java60/HTMLad_utils/ad2applet.js";;
UPDATE url_table SET hits=2 WHERE
url="http://abclocal.go.com/images/wabc/2003/wabc_images_whatsonseven.gif";;
UPDATE url_table SET hi
Taylor,
Thursday, May 23, 2002, 11:46:16 PM, you wrote:
TL> What priviledge does a user need in order to be able to execute the load data
infile command in mysql..? is it FILE?
Yes, you are right. Your user must have file privilege.
Note: MySQL must have permissions on that file in your OS.
T
Yes it is ...
See: http://www.mysql.com/doc/P/r/Privileges_provided.html
Gurhan
-Original Message-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 4:46 PM
To: [EMAIL PROTECTED]
Subject: mysql load data question
What priviledge does a user need in order to
What priviledge does a user need in order to be able to execute the load data infile
command in mysql..? is it FILE?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepath..."
"You Know where to apply."
_for_row';
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Taylor Lewick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thur
-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 4:52 PM
To: [EMAIL PROTECTED]
Subject: Mysql Load Data question
I read in the Mysql manual where you can change the default column
seperator, but it didnt specify how to do this.
So, how can I tell the LOAD DATA command
I read in the Mysql manual where you can change the default column seperator, but it
didnt specify how to do this.
So, how can I tell the LOAD DATA command to use commas, or better yet, where can I go
to find out about mysql command syntax...?
Thanks,.
Taylor Lewick
Unix System Administrator
Dear Benjamin.
I firstly very very thanks for your interest.
This is my 3'rd mail with same question and you 're the first one who
reply.
- Original Message -
From: Benjamin Pflugmann <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>
Cc: Mysql Mailing list <[EMAIL PROTECTED]>
Sen
Hello, what is the correct syntax forignore?
I have a table with columsn already put in, and primary key has 0 as value.
When I do "load data infil 'file.txt'...
it gives a duplicate error. Documentation says to use 'ignore'. But I can't get it to
work.
What is the *correct* syntax to load a
16 matches
Mail list logo
