Not the answer you need?
Register and ask your own question!

Can not start slave to AWS Master : 1298 Error Unknown or incorrect time zone: 'UTC'

MR.YMR.Y ContributorCurrent User Role Beginner
We are moving from AWS to host and store all DBs on own Data center
I took a mysql dump from AWS (with binlog name and position)
I import on new Percona 5.6 db but get error while trying to start slave.
setup CHANGE MASTER works but start slave fails .

When checking AWS it shows : system_time_zone= UTC
time_zone = UTC

Mine NEW 5.6 Percona show
system_time_zone = PDT
time_zone = SYSYEM

I had to change my unix host to UTC and bounce mysql since it reads the host time_zone upon startup

I also set in my.cnf and bounce mysql.
[mysqld_safe]
timezone='UTC'
default-time-zone='UTC'

mysql> show variables where variable_name like '%zone%' ;
system_time_zone UTC
time_zone SYSTEM

IT still show time_zone as = SYSTEM
HOW DO I CHANGE THIS to UTC ??? (I want same as AWS)
or how else can I start a slave replicaiton from AWS to slave on premises .... ?

TRIED :
mysql> SET @@global.time_zone = UTC ;
ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'
mysql> SET @@global.time_zone = 'UTC' ;
ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'
mysql> SET time_zone = 'UTC' ;
ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'
mysql> SET time_zone = UTC ;
ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.