Determine a MySQL Database Creation Date

This article was posted more than 1 year ago. Please keep in mind that the information on this page may be outdated, insecure, or just plain wrong today.

Here’s a simple way to determine the date/time a database was created in MySQL:

SELECT create_time
FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'DB_NAME'
mysql> select create_time from information_schema.tables where table_schema='foo';
+---------------------+
| create_time         |
+---------------------+
| 2013-03-01 10:42:34 |