github.com/bigwhoop/mysql-tz-converter
This CLI tool converts all fields of all datetime, date and timestamp columns in a MySQL database from one time zone to another.
go install github.com/bigwhoop/mysql-tz-converter
mysql-tz-converter -u user -p pass -h host -P port database from_tz to_tz
mysql-tz-converter -u root -p secret some_db CET UTC
mysql-tz-converter --help
This tool uses MySQL's CONVERT_TZ() function. To use it with named time zones (like UTC) you should
make sure that the time zones are properly installed.
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysqlFAQs
Unknown package
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Socket CEO Feross Aboukhadijeh discusses open source security challenges, including zero-day attacks and supply chain risks, on the Cyber Security Council podcast.
Security News
Research
Socket researchers uncover how threat actors weaponize Out-of-Band Application Security Testing (OAST) techniques across the npm, PyPI, and RubyGems ecosystems to exfiltrate sensitive data.
Security News
Research
A malicious npm campaign is targeting Ethereum developers by impersonating Hardhat plugins and the Nomic Foundation, stealing sensitive data like private keys.