Assuming that we have to trace every intervention on a database called « stats»
As result we wil have a new database with the “history_” prefix which will contain all the same tables of our source database “stats” but with different column definition. We have to add 3 new colums.
- Operation made.
- Creating the histroy database.
To continue we need to be sure that the mysql user has all privilieges for creating databases and Triggers.