Re: convert_tz giving null even after updating time zone files
Posted by:
Rick James
Date: August 28, 2011 01:31PM
What do you get from these two commands? Something like what I see?
mysql> USE mysql;
mysql> SHOW TABLE STATUS LIKE 'time_zone%';
+---------------------------+--------+---------+------------+-------+-----------
-----+-------------+-------------------+--------------+-----------+-------------
---+---------------------+---------------------+---------------------+----------
-------+----------+----------------+-----------------------------------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_le
ngth | Data_length | Max_data_length | Index_length | Data_free | Auto_increme
nt | Create_time | Update_time | Check_time | Collation
| Checksum | Create_options | Comment |
+---------------------------+--------+---------+------------+-------+-----------
-----+-------------+-------------------+--------------+-----------+-------------
---+---------------------+---------------------+---------------------+----------
-------+----------+----------------+-----------------------------------------+
| time_zone | MyISAM | 10 | Fixed | 560 |
7 | 3920 | 1970324836974591 | 8192 | 0 | 5
61 | 2009-05-29 04:50:34 | 2009-05-29 14:50:36 | NULL | utf8_gene
ral_ci | NULL | | Time zones |
| time_zone_leap_second | MyISAM | 10 | Fixed | 24 |
...
What ENGINE is being used for the _other_ tables in the `mysql` database?
Subject
Written By
Posted
Re: convert_tz giving null even after updating time zone files
August 28, 2011 01:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.