How to disable synchronisation for a mySQL database table

February 23, 2015   /   by Marco  / Categories :  Technology, Websites
mysql database table no replication my ini file

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:

[codesyntax lang=”php”] [/codesyntax]

mysql database table no replication

In the section [mysqld] add the following syntax:

[codesyntax lang=”php”] [/codesyntax]

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

[codesyntax lang=”php”] [/codesyntax]

mysql database table no replication my ini file

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.

DO YOU LIKE WHAT YOU'VE READ?
Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!

Our Sponsors

  • Follow us:

OTHER ARTICLES YOU MAY LIKE


USING WPFORMS FOR WORDPRESS POLLS

USING WPFORMS FOR WORDPRESS POLLS

Have you tried creating polls in WordPress? It’s pretty easy, and it’s a great way to collect feedback from your users. With WPForms (a WordPress plugin), you can add awesome polls right within the WordPress platform and all the information collected you will able to keep right within WordPress – you will not have to […]

read more
USE MAILCHIMP AND WPFORMS

USE MAILCHIMP AND WPFORMS

Have you considered using Mailchimp and WPForms to help you market your business? If not, you could be missing out. Both tools are incredibly powerful, and if combined, could help you accomplish a lot more. For example, you could use WPForms to capture leads for your business, and then use Mailchimp to email new subscribers […]

read more

Subscribe

Receive the latest news and awesome deals via email

Like our Page

site auditing tools