user16948
Reputation: 4951
Logging mysql update queries for a specific table
Is it possible to log changes only on a specific table using mysql bin log?
Upvotes: 3
Views: 1325
Answers (1)
Andreas Wederbrand
Reputation: 40001
It is possible to have just one (or several) databases go into the bin log with --binlog-do-db on the master.
It is also possible to have the slave replicate only tables that match a certain string with --replication-wild-do-table
Upvotes: 1
Related Questions
- Log all queries in mysql
- MySQL: Disable logging for table updates/inserts
- Logging only insert, update and delete mysql queries
- How to keep history of record updates in MySQL?
- log mysql updates
- How can I log MySQL queries?
- Is there a way to find out what was updated with the update query?
- Track who changed a field in mysql
- How can I retrieve which columns were updated in a MySQL table
- How should I audit changes in a MySQL table (using MySQL 4)?