Difference between revisions of "Find creation date of cache tables"

From EPrints Documentation
Jump to: navigation, search
(Created page with 'To see the date that your cache tables were created, use the following MySQL comment (run as a 'powerful' mysql user): mysql> select TABLE_SCHEMA, TABLE_NAME, CREATE_TIME from i…')
(No difference)

Revision as of 12:12, 22 December 2010

To see the date that your cache tables were created, use the following MySQL comment (run as a 'powerful' mysql user):

mysql> select TABLE_SCHEMA, TABLE_NAME, CREATE_TIME from information_schema.tables WHERE TABLE_NAME RLIKE 'cache[0-9]';