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’