How to check the creation date of your databases (MySQL)

The Query

If you have a lot of databases and you want to check their creation dates just run this SELECT.

If the ‘create_time’ is null then your user won’t have the necessary permissions.

SELECT
    table_schema,
    MAX(create_time) create_time
FROM information_schema.tables
-- where TABLE_SCHEMA ='myDb' -- uncomment for specific database
GROUP BY TABLE_SCHEMA
-- SORT BY create_time

Run the query in your favourite tool (like HeidiSQL)

 

 

 

 

 

More hints here

How to run MySQL 5.7 in K/Ubuntu 20.04 with docker here

 

Hits: 470

Share area

Leave a Reply

Your email address will not be published. Required fields are marked *