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
USE FUSEBASE TO AUTOMATE TEAMWORK AND COLLABORATION
If your business is growing, your team is juggling too many moving parts, and your client communication is spread across email threads, chat apps, documents, task boards, and endless follow ups, there is a good chance the real problem is not effort but fragmentation. Most businesses do not lose time because people are lazy. They […]
read more
USING REAP FOR VIDEO CLIPS
Short form video is now one of the most effective ways to reach new audiences, grow brand awareness, and turn long form content into a steady stream of social media assets. For creators, marketers, consultants, educators, and business owners, the challenge is rarely a lack of content. The real problem is time. Editing long videos […]
read more





