MySQL, is there a way to tell when was database last changed/modified?
Solution 1:
I use:
mysql -e "use <NAMEOFTHEDATABASE>;SELECT MAX(UPDATE_TIME) FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ;" | grep -v "\----" | grep -v "MAX(UPDATE_TIME)" | awk '{print $1}'
Regards!
Solution 2:
it's not exactly answer to what you are looking for, but i think that's what you need: enable binary logging, backup binlogs and create full dumps once a week or so.
Solution 3:
Only works for MyISAM tables
You can run a MySQL query against the information_schema table:
Example (replace dbname with your database name):
SELECT UNIX_TIMESTAMP(MAX(UPDATE_TIME)) as last_update
FROM information_schema.tables
WHERE TABLE_SCHEMA='dbname'
GROUP BY TABLE_SCHEMA;