Determine a MySQL Database Creation Date

This content 7 years old. Please, read this page keeping its age in mind along with the fact technology changes fast and the information on this page me be outdated, not best practice, or plain wrong.

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 |

Speak Your Mind

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.