How can I tell when a MySQL table was last updated?
In later versions of MySQL you can use the information_schema database to tell you when another table was updated:
[pre]SELECT UPDATE_TIME
FROM information_schema.tables
WHERE TABLE_SCHEMA = ‘dbname’
AND TABLE_NAME = ‘tabname'[/pre]