0

Is it possible in MySQL that I can get a list of all the UPDATE, DELETE and INSERT queries executed in last 1 hour? I want to do this for a sync functionality where I'll get this list at Server1 and pass to Server2 which will then execute all these and get sync'd.

arxoft
  • 1,385
  • 3
  • 17
  • 34

1 Answers1

1

Try to turn on mysql log on server to store all queries executed on it.

Log all queries in mysql

Community
  • 1
  • 1
J33nn
  • 3,034
  • 5
  • 30
  • 46