How to determine import date from MySQL?

Question

I uploaded the joomla website to my database some time ago. Now I would like to know exactly what date that I downloaded the website. Is there any way to find this in the database?

Answer 1

A quick way is to check create_time or update_time when executing this command:

 show table status; 

as in the following example:

 +--------------------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +--------------------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | a_table | MyISAM | 10 | Dynamic | 2 | 60 | 120 | 281474976710655 | 1024 | 0 | NULL | 2011-09-08 18:26:38 | 2011-11-07 20:38:28 | NULL | latin1_swedish_ci | NULL | | | 

Answer 2

I'm sure there is another way to do this, but you can probably look in the data folder and see the date the mysql data files were created.