ignore
2.6.32-279.14.1.el6.x86_64
I have created checksum table and tried to use --ignore-tables-regex to
remove some tables from checking.
pt-table-checksum --chunk-size-limit= --nocheck-plan --replicate-check
--ignore-tables-regex=^test.s_.*_tmp$
--ignore-tables=test.catalogsearch_fulltext
Hi!
> "Noel" == Noel Butler writes:
Noel> Shaun,
Noel> Is this option planned for backport into 5.5.x ?
Another option is to provide a patch and suggest to have it included
in MariaDB 5.5.
You can of course also consider to sponsor this so that we can do this
for you...
Regards,
Monty
Cr
Shaun,
Is this option planned for backport into 5.5.x ?
Cheers
signature.asc
Description: This is a digitally signed message part
Hi Daniel,
you can use a workaround from the shell,
cd /path/to/your/database (e.g.: cd /var/lib/mysql/mydb)
ls -al *table** | awk '{print $8}' | awk -F"." '{print "--ignore-table=*mydb
*."$1}' | xargs mysqldump -u*root* -p*toor* *--your-flags **mydb
Dear all,
I am currently trying to figure-out how I could ignore multiple tables in
mysql using a simple a regex. For example I have multiple tables which have
the following structure: mytable1, mytable2, ..,mytable100. And I
would like these tables to be ignore when doing mysqldump by
replicated.
Just a couple of ideas
Claudio
2010/7/23 Bryan Cantwell
> I know that you can ignore certain databases and tables in mysql
> replication, but is it possible to replicate all but a certain column or
> two from a table? This is 5.1.48 on linux.
>
> Thanks,
> Bryancan
I know that you can ignore certain databases and tables in mysql
replication, but is it possible to replicate all but a certain column or
two from a table? This is 5.1.48 on linux.
Thanks,
Bryancan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
i said: ignore!
But did it work?
;-)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http
i said: ignore!
--
hartmut
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
n any
platform, nor are column aliases.
Can we see your query?
Regards
Adrian
- Original Message -
From: Scott Haneda
To: Adrian Aitken
Cc: mysql@lists.mysql.com
Sent: Thursday, August 27, 2009 11:04 PM
Subject: Re: Getting mySQL to ignore case sensitivity of field names
htt
, Google isn't my friend :-(
How can I tell mySQL 5.0 to ignore the case of field names i.e.
FullName
should also be able to be referenced as fullname,fullNAME etc ?
I'm running it on a linux box at home but my copy at work (running on
Windows 2000 server) has this by default - I certain
o only talk about field values.
Regards
Adrian
- Original Message -
From: Scott Haneda
To: Adrian Aitken
Cc: mysql@lists.mysql.com
Sent: Thursday, August 27, 2009 11:04 PM
Subject: Re: Getting mySQL to ignore case sensitivity of field names
http://dev.mysql.com/doc/refman/5.0/en/case-se
http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
You need to set the field format to a non binary one, and case
insensitive will be the default.
On Aug 27, 2009, at 2:57 PM, Adrian Aitken wrote:
Hi, Google isn't my friend :-(
How can I tell mySQL 5.0 to ignore the case of
Hi, Google isn't my friend :-(
How can I tell mySQL 5.0 to ignore the case of field names i.e. FullName
should also be able to be referenced as fullname,fullNAME etc ?
I'm running it on a linux box at home but my copy at work (running on
Windows 2000 server) has this by default - I cer
I agree with Per, I use utf8 and it works fine for me, even with Chinese
characters
On Fri, Jun 12, 2009 at 8:40 AM, Per Jessen wrote:
> PJ wrote:
>
> > Let me put it this way, I am not having the problem. The problem seems
> > to be withthe way that character encoding is set up on the internet
PJ wrote:
> Let me put it this way, I am not having the problem. The problem seems
> to be withthe way that character encoding is set up on the internet -
> as confused and inconsistent as most everything else.
> You can put whatever charset you want in the header, in the collations
> in your data
Isart Montane wrote:
> Hi,
>
> I'm not having any problem on my local computer
>
> mysql> select text,text2 from table1 order by text2 desc;
> +--+---+
> | text | text2 |
> +--+---+
> | a   |    1 |
> | �   |    0 |
> +--+---+
>
> mysql>select text,text2
Hi,
I'm not having any problem on my local computer
mysql> select text,text2 from table1 order by text2 desc;
+--+---+
| text | text2 |
+--+---+
| a| 1 |
| �| 0 |
+--+---+
mysql>select text,text2 from table1 order by text2 desc;
+--+---+
| text | t
Is there a way to order lists while ignoring the accents?
So far, I have found nothing simple; and I need to keep the accents for
output.
The language is French (and québécois) :-)
TIA
--
Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
---
On Wed, May 27, 2009 at 11:24 AM, Cantwell, Bryan
wrote:
> I want to check all my functions and procs into my svn as individual sql
> files. When I use these to create my db, the person doing this may not
> realize the correct order to run these files and not have dependency
> challenges... How
I want to check all my functions and procs into my svn as individual sql files.
When I use these to create my db, the person doing this may not realize the
correct order to run these files and not have dependency challenges... How can
I have procs that depend on functions, or vice versa, get suc
I have a table like this:
unique_serial - Auto Increment
field_1
field_2
field_3
The Primary key is a combination of field_1, field_2, and field_3.
I want to do:
INSERT IGNORE INTO table_name (field_1,field_2,field_3) VALUES
('xx','xx','xx')
Sometimes t
ten to the binary log, it states:
2. There are some rules (--binlog-do-db, --binlog-ignore-db, or both).
Is there a default database (has any database been selected by USE?)?
* No: Do not write the statement, and exit.
* Yes: Go to the next step.
I'm interpreting this to mean that
Try something like this. If there are multiple punctuation values you
want to ignore you can nest multiple REPLACE functions.
mysql> create table names (name varchar(20));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into names values
('Osbourn'),("O'sh
R
BY Score;
Hope to help,
-Andy
-Original Message-
From: Bill Guion [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 03, 2007 8:33 PM
To: mysql@lists.mysql.com
Subject: Order By and Ignore Punctuation
I would like to perform a query of a personnel database with an ORDER BY
clause th
Hi,
Bill Guion wrote:
I would like to perform a query of a personnel database with an ORDER BY
clause that ignores punctuation. For example, O'shea would sort after
Osbourne, not to the beginning of the Os.
Is this doable in the query?
If you only have a limited number of punctuation charac
I would like to perform a query of a personnel database with an ORDER
BY clause that ignores punctuation. For example, O'shea would sort
after Osbourne, not to the beginning of the Os.
Is this doable in the query?
-= Bill =-
--
You can tell a lot about a man by the way he
Hi Ed,
Can you please reply with a repeatable test case?
On 2/1/07, Ed Pauley II <[EMAIL PROTECTED]> wrote:
I am importing a file into a table in which I want it to ignore
duplicate rows. When I specify --ignore (this also happens if I do a
SELECT IGNORE INTO from the client also) I
I am importing a file into a table in which I want it to ignore
duplicate rows. When I specify --ignore (this also happens if I do a
SELECT IGNORE INTO from the client also) I get a duplicate key error. If
I run the command again it skips the first such instance of a duplicate
key and gives me
I've just found convert()...
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
I used to think I was indecisive, but now I'm not so sure.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT
At 0:07 + 1/29/06, Jessica Svensson wrote:
From: Paul DuBois <[EMAIL PROTECTED]>
To: "Jessica Svensson" <[EMAIL PROTECTED]>,mysql@lists.mysql.com
Subject: Re: LOAD DATA, Ignore in SET?
Date: Sat, 28 Jan 2006 17:59:23 -0600
At 23:42 + 1/28/06, Jessica Svensson wrote
From: Paul DuBois <[EMAIL PROTECTED]>
To: "Jessica Svensson" <[EMAIL PROTECTED]>,mysql@lists.mysql.com
Subject: Re: LOAD DATA, Ignore in SET?
Date: Sat, 28 Jan 2006 17:59:23 -0600
At 23:42 + 1/28/06, Jessica Svensson wrote:
I'm doing load data a few times a
..]
Now if the partnumber does NOT exists in the products table the
product_id gets the value 0 (zero). I would like to have it ignore
if there is not match, so i don't need to run a seperate query to
delete everything with product_id = 0.
If by "ignore it" you mean "skip the
ducts table the product_id
gets the value 0 (zero). I would like to have it ignore if there is not
match, so i don't need to run a seperate query to delete everything with
product_id = 0.
Thanks in advance.
_
Hitta rätt på
Hi.
Use the --insert-ignore option of mysqldump.
You can type 'mysqldump --help' on command line to see all options available.
Richard AB.
- Original Message -
From: "Michael Williams" <[EMAIL PROTECTED]>
To:
Sent: Sunday, December 11, 2005
Hi All,
I have read thehttp://dev.mysql.com/doc/refman/5.0/en/
mysqldump.html and can find nothing regarding getting dump to
INSERT IGNORE instead of simply INSERT INTO. Is there any way to get
INSERT IGNORE to be dumped? Otherwise, I fear I may be forced to
parse the dump file
#x27; AND Birthdate =
> >
> > '$bday'"
> >
> > > to check for preexisting records. This means before I inserted a
> >
> > record, I
> >
> > > would select on specific fields and see if they matched the fields of
> >
&
see if they matched the fields of
>
> the
>
> > current record. If they did, I threw out the record I was going to
>
> enter, if
>
> > there was not a match, I'd INSERT the new record. If I use "INSERT
> > IGNORE...", MySQL will still have to v
Comments embedded. See below
Hal Vaughan <[EMAIL PROTECTED]> wrote on 11/01/2005 02:50:13 PM:
> I want to be sure I understand "INSERT IGNORE..." correctly before I
start
> depending on it. Up until now, I have not been using any kind of key or
> unique index, si
I want to be sure I understand "INSERT IGNORE..." correctly before I start
depending on it. Up until now, I have not been using any kind of key or
unique index, since many of my tables are created automatically and, until
now, it has been difficult for me to create a way to distingui
Hal,
>*IF* INSERT IGNORE worked ...
INSERT IGNORE _does_ work exactly as documented in the manual: "If you
specify the IGNORE keyword in an INSERT statement, errors that occur while
executing the statement are treated as warnings instead. For example,
without IGNORE, a row that dupli
On Thursday 25 August 2005 04:44 am, [EMAIL PROTECTED] wrote:
> Hal Vaughan <[EMAIL PROTECTED]> wrote on 24/08/2005 17:41:36:
>
> #>
>
> > Okay, so INSERT IGNORE only works if I am avoiding duplicate keys. Is
>
> there
>
> > any way to use INSERT the way
Hal Vaughan <[EMAIL PROTECTED]> wrote on 24/08/2005 17:41:36:
#>
> Okay, so INSERT IGNORE only works if I am avoiding duplicate keys. Is
there
> any way to use INSERT the way I thought INSERT IGNORE worked -- in other
> words is there any keyword for the INSERT comma
nt),
Name,
> > Value (both varchar), and I try a command like this:
> >
> > INSERT IGNORE INTO myTable SET Name = "Variable1", Value = "100";
> > or
> > INSERT IGNORE INTO myTable (Name, Value) VALUES("Variable1", "100");
>
On Wednesday 24 August 2005 02:47 am, Hal Vaughan wrote:
> I may have a misunderstanding of this, but as I have been told, if I have a
> table with 3 columns, Idx (an Index column, unique, auto-increment), Name,
> Value (both varchar), and I try a command like this:
>
> INSERT IGNO
command only checks columns that is instructed are to be unique.
The purpose of the IGNORE modifier is simply to ignore the error produced
when a duplicate occurs.
Alec
Hal Vaughan <[EMAIL PROTECTED]>
24/08/2005 07:47
Please respond to
[EMAIL PROTECTED]
To
mysql@lists.mysql.
Hi Hal,
in order to get INSERT IGNORE to work as you want it you must violate
a unique index somehow, i.e. you must have a unique index on Name,Value
or both and then you would get a quiet ignore of that violation.
The IGNORE keyword doesn't make the INSERT as such different, it just
affect
I may have a misunderstanding of this, but as I have been told, if I have a
table with 3 columns, Idx (an Index column, unique, auto-increment), Name,
Value (both varchar), and I try a command like this:
INSERT IGNORE INTO myTable SET Name = "Variable1", Value = "100";
o
IGNORE: test only since I did not get my last posting.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just a test - thanks
<><><><><><><><><><><><><><><><><><><><><>
"There are no problems, only solutions."
Gabe Tucker
Bloomberg LP
(609) 750 6668 - P
(646) 268 5681 - F
<><><><><><><><><><><><><><><><><><><><><>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
I'm loading 100 million rows into a MyISAM table and I'm wondering what
overhead is there when using the "Load Data Infile REPLACE " over "Load
Data Infile Ignore" syntax.
For example, does the REPLACE do a lookup prior to inserting the row? Would
it be fas
Please ignore
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please ignore
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Gary Richardson wrote:
These are essentially temporary tables that aren't defined as such --
they typically take a long time to derive (30 minutes to an hour) and
are used for multiple queries afterwards before being dropped.
In that case, why not just ignore those tables for replicatio
nection only.
>
>
>
>
> -Original Message-
> From: Gary Richardson [mailto:[EMAIL PROTECTED]
> Sent: Thu 10/21/2004 11:24 AM
> To: Mysql General (E-mail)
> Subject: Ignore a single query in replication
>
> Hey,
>
> Is there a way to tell the slave to not exe
> If this is the case you can create the table in a separate database, and
> in your mysql configuration tell the binary logging to exclude that
> database. Then anything in that specific database won't get replicated,
> I believe you can only do this exclusion on the database level, not per
> tab
> If the queries modify tables that are being replicated, then how would
> the slave remain
> in sync with the master if it didn't replicate them?
These are essentially temporary tables that aren't defined as such --
they typically take a long time to derive (30 minutes to an hour) and
are used fo
Try SET SQL_LOG_BIN=0 before you run your queires on master. This will be valid for
that connection only.
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Thu 10/21/2004 11:24 AM
To: Mysql General (E-mail)
Subject: Ignore a single query in replication
Hey,
Is
So I gather you are creating a table, and doing some work in it, but
even though it isn't declared 'temporary' it really is and you don't
want it replicated?
If this is the case you can create the table in a separate database, and
in your mysql configuration tell the binary logging to exclude that
Gary Richardson wrote:
There are a bunch of queries that happen on the master for statistical
purposes that don't use temp tables and generate large amounts of
data. These queries don't need to run on the slaves and in fact slow
it down quite a bit.
If the queries modify tables that are being repli
Hey,
Is there a way to tell the slave to not execute a query without
ignoring tables or databases?
There are a bunch of queries that happen on the master for statistical
purposes that don't use temp tables and generate large amounts of
data. These queries don't need to run on the slaves and in fa
Hi there,
I'm finding that DELETE IGNORE doesn't actually ignore all errors when using
InnoDb and trying to remove rows that would result in a foreign key error.
I've checked the docs and think that what I'm doing should work, but
doesn't - I'm using server 4.1.
so, for having
a complete database-status view .
Best regards
Peter
- Original Message -
From: "Mike Lohmann" <[EMAIL PROTECTED]>
To: "Victor Pendleton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 13, 2004 11:49 AM
Subject:
Yes. I also tried that. Are there any other suggestions?
What's about the different sections in my.cnf?
Should these statements beeing written under [mysqld_safe], too?
Victor Pendleton wrote:
In the slave's my.cnf have you tried just expliciting statement what tables
to ignore?
replic
In the slave's my.cnf have you tried just expliciting statement what tables
to ignore?
replicate-ignore-table=db.table1
replicate-ignore-table=db.table2
...
replicate-ignore-table=db.tablen
And remove the other statements?
-Original Message-
From: Mike Lohman
To: [EMAIL PROTECTED]
om/mysql/153722
I tried several times to delete the master.info on the slave and restart the
slave-server. Replication allways got up to work again. But the
replicate-wild and replicate-ignore-table entries are never used.
Please help.
Part of the slave- my.cnf, concerning replication:
master-host
I never got a reply for this, and I'm still trying to figure out the
best way to handle it. Anyone?
John A. McCaskey
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 2:17 PM
To: [EMAIL PROTECTED]
Subject: INSERT IGNORE like featur
want the behavior to be that the one fails
silently and the other 4999 insert successfully.
Any ideas how I can do this? It seems like INSERT IGNORE would make
sense but that appears to only ignore duplicates not foreign key
failures.
John A. McCaskey
Software Development Engineer
IP
Testing another time the mailing list.
Regards,
Heikki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Testing the MySQL mailing list.
Regards,
Heikki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- --
~ |...|
~ | _ _|Victor Medina M |
~ |\ \ \| | _ \ / \ |Linux - Java - MySQL |
~ | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria
had no mysql list mail for a while
just testing please ignore
mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That's a lot of stuff to ignore but I managed to do so successfully
> -Ursprüngliche Nachricht-
> Von: Victor Medina [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 15. April 2004 13:39
> An: [EMAIL PROTECTED] Mysql. Com
> Betreff: please ignore
>
> ---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, i been having problems with my mail server, just ignore this message.
- --
~ |...|
~ | _ _|Victor Medina M |
~ |\ \ \| | _ \ / \ |Linux - Java
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
please ignore
- --
~ |...|
~ | _ _|Victor Medina M |
~ |\ \ \| | _ \ / \ |Linux - Java - MySQL |
~ | \ \ \ _| | |_) / _ \ |Dpto
My apologies for missing the previous discussion and thanks for the info. A follow up
question: is there a performance penalty associated with using PreparedStatement's
with queries that will never be reused? Clearly, there's a performance benefit for
statements executed multiple times, but ho
Hi Alex. This question was discussed last week. Search the archives
for 'backslash'. The short answer is that there is no global option to
do what you want. You'll have to do it in code.
On Mon, 2004-04-12 at 17:10, [EMAIL PROTECTED] wrote:
> Is there a 'global' way to tell MySQL to not interp
Is there a 'global' way to tell MySQL to not interpret the backslashes ('\'s) in the
submitted SQL as escape characters? In other words, I'd like for them to always be
treated as if they themselves were already escaped with a backslash (i.e. '\\'). I'm
using 3.23.52, accessing it with an older
--
|...|
| _ _|Victor Medina M |
|\ \ \| | _ \ / \ |Linux - Java - MySQL |
| \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA |
| / / / |___| __/ ___ \ |[EMAIL PROTECTED
Is there anyway to get mySQL to generate a warning or other info when
it ignores a row via LOAD DATA INFILE IGNORE? I'm happy having the
duplicates ignored but ideally would like to log which records were
dupes in a place I can find them again.
--
t
test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Title: Test!!!Please ignore this message
Hi fellows,
...just a test.Please ignore this message.
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION & SOFTWARE DEVELOPER
Permanent e-mail address :
[EMAIL PROTECTED]
[E
On Tue, 20 Jan 2004, Todd Burke wrote:
> Is there any way to disable replication of all temp tables using
> replicate-ignore-table or some other means? The names of the temp tables
> are generated randomly by a script. Thanks
If you could have all temporary tables starting with
Is there any way to disable replication of all temp tables using
replicate-ignore-table or some other means? The names of the temp tables
are generated randomly by a script. Thanks
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
-ignore-table=info.notes # Added this Line
#3 Restarted slave server /etc/init.d/mysql restart
#4 start slave
"show status slave" shows that replication is running , but actually it
doesnt. I even can type start slave many times with no warning. Previously
I got an error message if I tr
At 22:37 + 12/19/03, Mike S wrote:
I want to stop replication for one table in the database. According
to the mysql documentation: I need to add the parameter
(replicate-wild-ignore-table ) to the my.cnf file. I have some
question.
#1 In what database I should made the change to my.cnf
I want to stop replication for one table in the database. According to the
mysql documentation: I need to add the parameter
(replicate-wild-ignore-table ) to the my.cnf file. I have some question.
#1 In what database I should made the change to my.cnf? Slave or Master?
#2 Than I should restart
Hi,
We are using the binary distribution of mysql for solaris 9 64bit on 2
machines that are replicating to each other for redundancy:
mysql-standard-4.0.14-sun-solaris2.9-sparc-64bit
I am successfully able use replicate-ignore-db=blah to stop replication
on a database, however when I specify
didn't ignore, huh?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Testing ..Please ignore this email
On Thursday 20 March 2003 22:42, John Hardin wrote:
> It would be really nice if there were some way (a variable) to make
> MySQL totally ignore certain directories in the datadir - for example,
> "lost+found", "RCS", and suchlike.
>
> The listed dirs should no
All:
It would be really nice if there were some way (a variable) to make
MySQL totally ignore certain directories in the datadir - for example,
"lost+found", "RCS", and suchlike.
The listed dirs should not show up in SHOW DATABASES and you should not
be able to CREATE a
Test
--
Karthikeyan Balasubramanian
[EMAIL PROTECTED]
--
http://www.fastmail.fm - Access your email from home and the web
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
On Tuesday 11 March 2003 18:57, vlady wrote:
> I am trying to set up a replication ignoring a given database, but
> unfortunatly it doesn't works (for me).
> In my.cnf of my master I have at the end :
> log-bin
> server-id = 1
> binlog-ignore-db=access
>
>
Hi All,
I am trying to set up a replication ignoring a given database, but
unfortunatly it doesn't works (for me).
In my.cnf of my master I have at the end :
log-bin
server-id= 1
binlog-ignore-db=access
The line: " binlog-ignore-db=access " is supposed to make the mas
>Description:
Please IGNORE my previous bug report. I had another script which was
deleting the data. Stupid user error.
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Mudit Wahal
>Organization:
>MySQL support: [none | licence | ema
On Thursday 16 January 2003 12:16, CheongMeng wrote:
> is it possible to ignore all sql delete statement while doing
> mysql replication?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensi
You could do something like have a process periodically run the non-delete
queries in the logs against another database and replicate the second
database. Wouldn't be automatic, but you'd have as much control as you like
over what goes in the other db.
Depending on what you're trying to do, it ma
1 - 100 of 154 matches
Mail list logo
