Sample Header Ad - 728x90

How to test mysql for changes

0 votes
1 answer
1299 views
I'm OCD person, I think I accidentally dropped something in my mysql. Problem is I've around 50 databases, and I cannot manually check everything :( Is there a way to check for these kind of changes? I tried to look at timestamps in /var/lib/mysql but it didn't help, I was looking at directory timestamps. I also ran:
table_schema,table_name,update_time
FROM information_schema.tables
WHERE update_time > (NOW() - INTERVAL 1 day)
it only returned databases changed in last few secs.
Asked by user21227
Jun 30, 2015, 06:27 PM
Last activity: Jun 30, 2015, 07:48 PM