# mysql\_tzinfo\_to\_sql /usr/share/zoneinfo - how to update without server restart?

**URL:** <https://forums.percona.com/t/mysql-tzinfo-to-sql-usr-share-zoneinfo-how-to-update-without-server-restart/6339>\
**Category:** Other MySQL® Questions\
**Created:** [May 5, 2018, 11:23am UTC](https://forums.percona.com/t/mysql-tzinfo-to-sql-usr-share-zoneinfo-how-to-update-without-server-restart/6339 "2018-05-05T11:23:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mangoo](https://avatars.discourse-cdn.com/v4/letter/m/df788c/32.png) [@mangoo](https://forums.percona.com/u/mangoo)\
**Post date:** [May 5, 2018, 11:23am UTC](https://forums.percona.com/t/mysql-tzinfo-to-sql-usr-share-zoneinfo-how-to-update-without-server-restart/6339/1 "2018-05-05T11:23:59Z")

</div>

Our application serves people around the globe, and we update the timezones every month or so with:

mysql\_tzinfo\_to\_sql /usr/share/zoneinfo | mysql -u root mysql

Unfortunately, a zone which was cached by mysqld, stays cached, and the only way to purge that cache seems to be restarting mysqld.

Is there a better way to do it (withot restarting mysqld)?
