How to disable synchronisation for a mySQL database table
February 23, 2015 / by Marco / Categories : Technology, Websites
In a previous post, I wrote an article on how to setup database replication using mySQL. I recently had to figure out a way to exclude a database table in the replication process and this is what I had to do:
NOTE: I’m using WAMP as my website hosting software
Open up the my.ini file under in the following location:
In the section [mysqld] add the following syntax:
replicate-wild-ignore-table=[databasename].[tablename]Just replace [databasename] with the name of your database and [tablename] with the name of your database table. If you want to include several table names you can use the wildcard % e.g
test.log%This will disable any replication of database tables with the name log.
Once you have saved the changes make sure you restart the WAMP services.
OTHER ARTICLES YOU MAY LIKE
CHATGPT USEFUL FEATURE: TEMPORARY CHAT
Everyday use of ChatGPT naturally trains you to think in threads. You ask a question, you get an answer, you refine the prompt, and the conversation accretes context. It’s one of the reasons ChatGPT feels more like a companion than a search box: it remembers what you said so it can respond appropriately next time […]
read more
HOW TO GET FREE UPGRADE TO PERPLEXITY.AI PRO FOR 12 MONTHS AND TESTING PRO FEATURES
If you spend time researching, comparing, or synthesising information online, you have probably encountered Perplexity.ai — a research-focused assistant that blends large language models with live web search and citation trails. The Pro plan supercharges that experience with priority access to powerful models, higher usage limits, and premium capabilities baked directly into the interface. Right […]
read more





