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
USING THIS AI TOO BOOST YOUR SOCIAL MEDIA GAME
A strong social media presence is essential for individuals and businesses alike. With the ever-growing number of users on various platforms, it can be daunting to stand out and create engaging content that captivates your audience. That’s where Marky comes in – a revolutionary tool that harnesses the power of artificial intelligence to help you […]
read moreHOW TO USE KATALIST AI TO CREATE AWESOME STORYBOARDS
Creating a compelling and visually appealing storyboard is crucial for any creative project, whether it’s a film, television show, or advertisement. However, the traditional process of storyboarding can be time-consuming and labor-intensive. That’s where Katalist AI comes in. This innovative tool combines the power of artificial intelligence with the creativity of human input to revolutionize […]
read more