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
FILMORA 15.2.3 UPDATE: DID IT FIX PLAYBACK JITTER? A PRACTICAL TEST WITH GPU SETTINGS
Wondershare Filmora has received a new point release, and for many editors the first question is simple. Has this update finally fixed that annoying playback jitter in the preview window. If you have felt a stutter during editing that makes your footage look as if frames are being skipped or shuffled rather than played smoothly, […]
read more
STOP NOISY CALLS: THE ANDROID SETTING YOU SHOULD SWITCH ON TODAY
Phone calls still matter. Whether you’re speaking to a client, checking in with family, or handling something urgent on the move, clarity can make or break the conversation. If you’ve ever found yourself apologising for the construction noise behind you, the wind across your microphone, or the café chatter muddling your words, there’s an Android […]
read more




