How to disable synchronisation for a mySQL database table
February 23, 2015 / by Marco / Categories : Technology, WebsitesIn 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
POWERFUL REFERRAL PROGRAM TOOL
Businesses of all sizes are constantly seeking new and innovative ways to grow their customer base and increase brand awareness. With the rise of social media and the reliance on word-of-mouth marketing, referral programs have become an essential tool for companies looking to expand their reach. However, managing a successful referral program can be a […]
read moreCYBER SECURITY PLATFORM FOR YOUR BUSINESS
Cyber security has become a top priority for individuals and organizations alike. With the ever-evolving threat of cyber attacks, it is imperative to have a strong and reliable security platform in place to protect sensitive information and data. That’s where Bleach Cyber comes in. As a leading cyber security platform, Bleach Cyber is dedicated to […]
read more