Command Line Fu - MySQL - find last update per database
Want to find the last time a database was updated?
SELECT MAX(UPDATE_TIME), TABLE_SCHEMA as last_update from information_schema.tables GROUP BY TABLE_SCHEMA;
Want to find the last time a database was updated?
SELECT MAX(UPDATE_TIME), TABLE_SCHEMA as last_update from information_schema.tables GROUP BY TABLE_SCHEMA;