Determine a MySQL Database Creation Date

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 |

Leave a Reply

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

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