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

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
VidTechy: The Ultimate Tool for AI-Powered Video Optimization
Unlock the potential of your videos with VidTechy, the ultimate AI-powered tool for seamless video optimization and enhanced viewer engagement.
read more