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
Last activity: Jun 30, 2015, 07:48 PM