Hello all,
Is there a way to change a table's Create_time that is displayed when doing a `SHOW TABLE STATUS FROM mydb LIKE 'foo'\G`?
I've tried using touch to modify the file dates directly and searched the online docs with no luck.
The reason I want to do this is because we had some tables that were dangerously close to running out of room. The tables are in excess of 5-8 million rows and it is not possible to lock them for the time it would take to alter the MAX_ROWS and AVG_ROW_LENGTH so I renamed them to a temporary name and created a new table to be used for the duration of the alter. Once the alter statement was complete I switched the names and INSERT...SELECT from the temporary table into the newly altered table. This changed the table's Create_time which breaks a program we have that estimates how many days, months, or years we have before a table is full based on the number of rows and the Create_time. We have far too many tables to just alter them all in one sitting so we do them as needed.
Thanks.
-- Jim Grill
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
