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 noel.but...@ausics.net 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...
Shaun,
Is this option planned for backport into 5.5.x ?
Cheers
signature.asc
Description: This is a digitally signed message part
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
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*
It's not that beautiful but it should work
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
) that will be replicated.
Just a couple of ideas
Claudio
2010/7/23 Bryan Cantwell bcantw...@firescope.com
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 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
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 certainly set
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 field
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-sensitivity.html
You need to set the field
, 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 certainly set any
.
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
http://dev.mysql.com/doc/refman/5.0/en/case
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
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 p...@computer.org 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
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.
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 |
+--+---+
mysqlselect text,text2 from table1 order by text2 desc;
+--+---+
| text |
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 |
+--+---+
mysqlselect text,text2 from table1
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
On Wed, May 27, 2009 at 11:24 AM, Cantwell, Bryan
bcantw...@firescope.com 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
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 this will be an existing record
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
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'shea),(O'Malley),('Olathe'),('Ottawa
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
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
;
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 that ignores
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 get
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
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å nätet med MSN Search
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 input line and do not load it,
you
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 day via cron and using this:
LOAD
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:
I'm doing load data a few
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
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: mysql@lists.mysql.com
Sent: Sunday, December 11, 2005 6:19 PM
Subject
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 distinguish between
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, since many of my tables are created
INSERT
IGNORE..., MySQL will still have to verify that the new record does not
match any old records. How much faster is it to do it that way than
the way
I was? I'd think the same routines to find matching data would be used.
No, the same routine will not be used.
A hash
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 verify that the new record does
not
match any old records. How much faster is it to do it that way than
the way
I
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 command to keep it from
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 I thought INSERT IGNORE worked -- in other
words
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
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;
or
INSERT IGNORE INTO myTable
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
affects
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.com
cc
Subject
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 IGNORE INTO myTable SET
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);
AND I already have a row with the matching Name and Value columns
matching
in value, that MySQL will detect
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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 faster to use Ignore
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]
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
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
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
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
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 for
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
table.
.
-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 execute a query without
ignoring tables or databases?
There are a bunch
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 replication? I
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.4-gamma:
Welcome to the MySQL
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?
replicate-ignore
- Original Message -
From: Mike Lohmann [EMAIL PROTECTED]
To: Victor Pendleton [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 13, 2004 11:49 AM
Subject: Re: Problem with Replication - Slave Option replicate-ignore-tabl e
and replicate-wild-ignore-table
Yes. I also
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=masterip
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]
Sent
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 feature
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 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]
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]
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]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- --
~ |...|
~ | _ _|Victor Medina M |
~ |\ \ \| | _ \ / \ |Linux - Java - MySQL |
~ | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
please ignore
- --
~ |...|
~ | _ _|Victor Medina M |
~ |\ \ \| | _ \ / \ |Linux - Java - MySQL |
~ | \ \ \ _| | |_) / _ \ |Dpto
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, i been having problems with my mail server, just ignore this message.
- --
~ |...|
~ | _ _|Victor Medina M |
~ |\ \ \| | _ \ / \ |Linux - Java
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
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
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
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
--
|...|
| _ _|Victor Medina M |
|\ \ \| | _ \ / \ |Linux - Java - MySQL |
| \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA |
| / / / |___| __/ ___ \ |[EMAIL
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.
--
thanks
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]
[EMAIL
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 tmp or something
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 try to start
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
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
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 not show up in SHOW DATABASES and you should
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 database with a name
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)
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
The line: 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 master not
to log
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: submitter ID
Originator:Mudit Wahal
Organization:
MySQL support: [none | licence | email support
Hi,
is it possible to ignore all sql delete statement while doing
mysql replication?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
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
1 - 100 of 150 matches
Mail list logo