Yesterday, I set the time zone on our DB server (as explained here). Doing so required using the
mysql_tzinfo_to_sql executable. Fortunately, this already existed on the server, and conversion of the time zone data went smoothly.
However, today I can see that our slave is generating the same error. The problem is that the slave doesn't seem to have the
apt-get tells me that it exists in these other packages:
root@slave:~# mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql
The program 'mysql_tzinfo_to_sql' can be found in the following packages:
Try: apt-get install <selected package>
I'm concerned that installing one of these (probably would choose
mariadb-server-5.5) would conflict with our currently-installed version of MariaDB (10.0.17-MariaDB-1~precise-log).
How should I go about installing this time zone data on the slave?
- Can it be easily copied over from the master's DB?
- Is my concern about installing
- Is there a totally different approach I'm missing?