Resolved date/time of the last change to a Database in Plesk

[zed2007]

Hi, to all. I have 9 Databases on Server and i need to know date/time of last change each Database. How i can see this in Plesk or phpMyAdmin?
Can someone advise me? Thank you in advance.

 

[Peter Debik]

Get the date time of the last change to a MySQL database

Get the date time of the last change to a MySQL database - You can get the date/time of the last change to a MySQL database with the help of INFORMATION_SCHEMA.TABLES. The syntax is as follows −SELECT update_time FROM information_schema.tables WHERE table_schema = 'yourDatabaseName’' AND...

www.tutorialspoint.com

 

[zed2007]

Thanks, for Tables with timestamp attribute it works.