MySQL tip: before dropping a table
Sun 23 Aug 2009 12:44:31 | 1 comments
Check its last modification date, a la filemtime of PHP. How can you do that? Easy:
show table status from DATABASE_NAME like 'TABLE_NAME'G
This gives you an output such as:
mysql> show table status from groups like 'analytics'G
*************************** 1. row ***************************
Name: analytics
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 453161
Avg_row_length: 343
Data_length: 15573804
Max_data_length: 281474976710655
Index_length: 2778112
Data_free: 0
Auto_increment: 158700
Create_time: 2009-08-20 14:26:29
Update_time: 2009-08-23 12:33:49
Check_time: 2009-08-20 14:26:31
Collation: utf8_unicode_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.00 sec)
Bold section is the last modification date.
If it's NULL, that means you probably can remove it safely.
Comments
kat 5 months ago
or
