‘MySQL error code 1298, Slave Unknown or incorrect timezone: ‘Asia/Calcutta’ ‘ on the query. Default database: ‘tastethelinux’. Query ….. you will find more detail in the Screenshot
So, now the scenario was we have successfully established the connection between Master and Slave in MySQL, now after that, the SQL was restoring its remaining relay-log-files at that time I got the error “1298 Slave Unknown or incorrect timezone”.
So for the solution, we had used the below command
#mysql_tzinfo_to_sql /usr/share/zoneinfo/| mysql -u root mysql -p
You can look into the screenshot what the output do we get
So, this command will load the timezone into the MySQL database after executing the command.
Now we will start and stop the slave by using a following commands
That’s worked for me, with no error in the log file of MySQL slave server.
The question is “what is mysql_tzinfo_to_sql”, “What will be in that /usr/share/zoneinfo”?
So, the mysql_tzinfo_to_sql is a program that loads the time zone tables into the MySQL databases.
And the /usr/share/zoneinfo contains the information of the world timezone like Asia, America, Australia and many more this all stored in binary.
Thanks !!! for reading the post. Keep Supporting and Keep Sharing.
The solution for MySQL Error code 1062 Slave Duplicate entry refers to the link.
Solution of MySQL error code 1594, Relay log read failure into the MySQL slave Server.
When the Master host will be changed then we have to follow the certain steps, so that the slave can reconnect with MySQL Master host.
To Upgrade the MySQL 5.5 to 5.7 in CentOS refer this link.
How to install MySQL 8 on Linux of any version on any flavour of the Linux refer this link.
If you want to learn Linux Basic command follow this link.
1298, basic, error 1594 1062, error code 1298, incorrect time zone, Linux basic command, MySQL, MySQL basic, MySQL install, MySQL upgrade, Reconnecting after a failed master event read, relay log read failure 1594, Slave Duplicate Entry error, slave Unknown or incorrect time zone, error code 1298