Mysql get database restore date time

Mysql get database restore date time

solution:

I think Information_Schema used to identify "CREATE_TIME"  of purticular table..

Example:

To get the creation date of MySQL table, use the information_schema. The syntax is as follows

SELECT create_time FROM INFORMATION_SCHEMA.TABLES

WHERE table_schema = 'yourDatabaseName’

--   AND table_name = 'yourTableName'

ORDER BY create_time DESC LIMIT 1;

Output: