DelphiFAQ Home Search:

How to log all mysql database modifications

 

commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

How can we log changes done to our mysql production database? People here use the mysql shell as their client.

Answer:

You can specify tee=/var/logs/mysql_cli.log in the mysql shell config file (my.cnf) and it will log all CLI session content (input and output) to this file.

Considering that these CLI modifications can be very powerful, you really should log them.

This does not help if some users use a web front end e.g. phpmyadmin.


[root@www etc]# pwd
/etc
[root@www etc]# cat my.cnf
[client]
tee=/Content/tmp/mysql_cli.log
[root@www etc]#

Content-type: text/html

Comments:

2012-11-12, 04:02:25
anonymous from United States  

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: