MySQL Forums
Forum List  »  Newbie

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?

Options: ReplyQuote


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.