Onyx, a CentOS 7.x MySQL Server for MythTV
Quick notes on upgrade of the MySQL server for MythTV (was on CentOS 6).
mariadb-server
Install the mariadb package (was mysql):
# systemctl enable mariadb # systemctl start mariadb
Apply the timezones to the 'mysql' database using the root identity (add a '-p' option if the root user has a password):
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Links
Appendices
Yum install mariadb-server
Dependencies Resolved ===================================================================================================== Package Arch Version Repository Size ===================================================================================================== Installing: mariadb-server x86_64 1:5.5.37-1.el7_0 updates 11 M Installing for dependencies: libaio x86_64 0.3.109-12.el7 base 24 k mariadb x86_64 1:5.5.37-1.el7_0 updates 8.9 M perl x86_64 4:5.16.3-283.el7 base 8.0 M perl-Carp noarch 1.26-244.el7 base 19 k perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k perl-DBD-MySQL x86_64 4.023-5.el7 base 140 k perl-DBI x86_64 1.627-4.el7 base 802 k perl-Data-Dumper x86_64 2.145-3.el7 base 47 k perl-Encode x86_64 2.51-7.el7 base 1.5 M perl-Exporter noarch 5.68-3.el7 base 28 k perl-File-Path noarch 2.09-2.el7 base 26 k perl-File-Temp noarch 0.23.01-3.el7 base 56 k perl-Filter x86_64 1.49-3.el7 base 76 k perl-Getopt-Long noarch 2.40-2.el7 base 56 k perl-HTTP-Tiny noarch 0.033-3.el7 base 38 k perl-IO-Compress noarch 2.061-2.el7 base 260 k perl-Net-Daemon noarch 0.48-5.el7 base 51 k perl-PathTools x86_64 3.40-5.el7 base 82 k perl-PlRPC noarch 0.2020-14.el7 base 36 k perl-Pod-Escapes noarch 1:1.04-283.el7 base 49 k perl-Pod-Perldoc noarch 3.20-4.el7 base 87 k perl-Pod-Simple noarch 1:3.28-4.el7 base 216 k perl-Pod-Usage noarch 1.63-3.el7 base 27 k perl-Scalar-List-Utils x86_64 1.27-248.el7 base 36 k perl-Socket x86_64 2.010-3.el7 base 49 k perl-Storable x86_64 2.45-3.el7 base 77 k perl-Text-ParseWords noarch 3.29-4.el7 base 14 k perl-Time-Local noarch 1.2300-2.el7 base 24 k perl-constant noarch 1.27-2.el7 base 19 k perl-libs x86_64 4:5.16.3-283.el7 base 686 k perl-macros x86_64 4:5.16.3-283.el7 base 42 k perl-parent noarch 1:0.225-244.el7 base 12 k perl-podlators noarch 2.5.1-3.el7 base 112 k perl-threads x86_64 1.87-4.el7 base 49 k perl-threads-shared x86_64 1.43-6.el7 base 39 k Transaction Summary ===================================================================================================== Install 1 Package (+36 Dependent packages) Total download size: 32 M Installed size: 144 M Is this ok [y/d/N]: y Downloading packages: (1/37): libaio-0.3.109-12.el7.x86_64.rpm | 24 kB 00:00:02 (2/37): perl-Carp-1.26-244.el7.noarch.rpm | 19 kB 00:00:02 (3/37): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00 (4/37): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:00 (5/37): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:01 (6/37): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm | 140 kB 00:00:01 (7/37): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00 (8/37): perl-Exporter-5.68-3.el7.noarch.rpm | 28 kB 00:00:00 (9/37): perl-Encode-2.51-7.el7.x86_64.rpm | 1.5 MB 00:00:00 (10/37): perl-File-Path-2.09-2.el7.noarch.rpm | 26 kB 00:00:00 (11/37): perl-Filter-1.49-3.el7.x86_64.rpm | 76 kB 00:00:00 (12/37): perl-File-Temp-0.23.01-3.el7.noarch.rpm | 56 kB 00:00:00 (13/37): perl-Getopt-Long-2.40-2.el7.noarch.rpm | 56 kB 00:00:00 (14/37): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm | 38 kB 00:00:00 (15/37): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00 (16/37): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00 (17/37): perl-PathTools-3.40-5.el7.x86_64.rpm | 82 kB 00:00:00 (18/37): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00 (19/37): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm | 87 kB 00:00:00 (20/37): perl-Pod-Simple-3.28-4.el7.noarch.rpm | 216 kB 00:00:00 (21/37): perl-Pod-Escapes-1.04-283.el7.noarch.rpm | 49 kB 00:00:00 (22/37): perl-Pod-Usage-1.63-3.el7.noarch.rpm | 27 kB 00:00:00 (23/37): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm | 36 kB 00:00:00 (24/37): perl-Socket-2.010-3.el7.x86_64.rpm | 49 kB 00:00:00 (25/37): perl-Storable-2.45-3.el7.x86_64.rpm | 77 kB 00:00:00 (26/37): perl-Text-ParseWords-3.29-4.el7.noarch.rpm | 14 kB 00:00:00 (27/37): perl-Time-Local-1.2300-2.el7.noarch.rpm | 24 kB 00:00:00 (28/37): perl-constant-1.27-2.el7.noarch.rpm | 19 kB 00:00:00 (29/37): perl-macros-5.16.3-283.el7.x86_64.rpm | 42 kB 00:00:00 (30/37): perl-parent-0.225-244.el7.noarch.rpm | 12 kB 00:00:00 (31/37): perl-libs-5.16.3-283.el7.x86_64.rpm | 686 kB 00:00:00 (32/37): perl-podlators-2.5.1-3.el7.noarch.rpm | 112 kB 00:00:00 (33/37): perl-threads-1.87-4.el7.x86_64.rpm | 49 kB 00:00:00 (34/37): perl-threads-shared-1.43-6.el7.x86_64.rpm | 39 kB 00:00:00 (35/37): perl-5.16.3-283.el7.x86_64.rpm | 8.0 MB 00:00:20 (36/37): mariadb-server-5.5.37-1.el7_0.x86_64.rpm | 11 MB 00:00:24 (37/37): mariadb-5.5.37-1.el7_0.x86_64.rpm | 8.9 MB 00:01:39 ----------------------------------------------------------------------------------------------------- Total 333 kB/s | 32 MB 00:01:39 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : 1:perl-parent-0.225-244.el7.noarch 1/37 Installing : perl-HTTP-Tiny-0.033-3.el7.noarch 2/37 Installing : perl-podlators-2.5.1-3.el7.noarch 3/37 Installing : perl-Pod-Perldoc-3.20-4.el7.noarch 4/37 Installing : 1:perl-Pod-Escapes-1.04-283.el7.noarch 5/37 Installing : perl-Encode-2.51-7.el7.x86_64 6/37 Installing : perl-Text-ParseWords-3.29-4.el7.noarch 7/37 Installing : perl-Pod-Usage-1.63-3.el7.noarch 8/37 Installing : 4:perl-libs-5.16.3-283.el7.x86_64 9/37 Installing : 4:perl-macros-5.16.3-283.el7.x86_64 10/37 Installing : perl-Storable-2.45-3.el7.x86_64 11/37 Installing : perl-Exporter-5.68-3.el7.noarch 12/37 Installing : perl-constant-1.27-2.el7.noarch 13/37 Installing : perl-Time-Local-1.2300-2.el7.noarch 14/37 Installing : perl-Socket-2.010-3.el7.x86_64 15/37 Installing : perl-Carp-1.26-244.el7.noarch 16/37 Installing : perl-PathTools-3.40-5.el7.x86_64 17/37 Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64 18/37 Installing : perl-File-Temp-0.23.01-3.el7.noarch 19/37 Installing : perl-File-Path-2.09-2.el7.noarch 20/37 Installing : perl-threads-shared-1.43-6.el7.x86_64 21/37 Installing : perl-threads-1.87-4.el7.x86_64 22/37 Installing : perl-Filter-1.49-3.el7.x86_64 23/37 Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch 24/37 Installing : perl-Getopt-Long-2.40-2.el7.noarch 25/37 Installing : 4:perl-5.16.3-283.el7.x86_64 26/37 Installing : perl-Data-Dumper-2.145-3.el7.x86_64 27/37 Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 28/37 Installing : perl-Net-Daemon-0.48-5.el7.noarch 29/37 Installing : 1:mariadb-5.5.37-1.el7_0.x86_64 30/37 Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 31/37 Installing : perl-IO-Compress-2.061-2.el7.noarch 32/37 Installing : perl-PlRPC-0.2020-14.el7.noarch 33/37 Installing : perl-DBI-1.627-4.el7.x86_64 34/37 Installing : perl-DBD-MySQL-4.023-5.el7.x86_64 35/37 Installing : libaio-0.3.109-12.el7.x86_64 36/37 Installing : 1:mariadb-server-5.5.37-1.el7_0.x86_64 37/37 Verifying : perl-HTTP-Tiny-0.033-3.el7.noarch 1/37 Verifying : perl-threads-shared-1.43-6.el7.x86_64 2/37 Verifying : perl-Storable-2.45-3.el7.x86_64 3/37 Verifying : perl-IO-Compress-2.061-2.el7.noarch 4/37 Verifying : perl-Exporter-5.68-3.el7.noarch 5/37 Verifying : perl-constant-1.27-2.el7.noarch 6/37 Verifying : perl-PathTools-3.40-5.el7.x86_64 7/37 Verifying : 1:perl-Pod-Escapes-1.04-283.el7.noarch 8/37 Verifying : libaio-0.3.109-12.el7.x86_64 9/37 Verifying : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 10/37 Verifying : 1:perl-parent-0.225-244.el7.noarch 11/37 Verifying : perl-Net-Daemon-0.48-5.el7.noarch 12/37 Verifying : 1:mariadb-server-5.5.37-1.el7_0.x86_64 13/37 Verifying : perl-File-Temp-0.23.01-3.el7.noarch 14/37 Verifying : 4:perl-libs-5.16.3-283.el7.x86_64 15/37 Verifying : perl-Time-Local-1.2300-2.el7.noarch 16/37 Verifying : perl-Pod-Perldoc-3.20-4.el7.noarch 17/37 Verifying : perl-DBI-1.627-4.el7.x86_64 18/37 Verifying : perl-Socket-2.010-3.el7.x86_64 19/37 Verifying : 4:perl-macros-5.16.3-283.el7.x86_64 20/37 Verifying : 4:perl-5.16.3-283.el7.x86_64 21/37 Verifying : perl-Carp-1.26-244.el7.noarch 22/37 Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 23/37 Verifying : 1:mariadb-5.5.37-1.el7_0.x86_64 24/37 Verifying : perl-Scalar-List-Utils-1.27-248.el7.x86_64 25/37 Verifying : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 26/37 Verifying : perl-PlRPC-0.2020-14.el7.noarch 27/37 Verifying : perl-Pod-Usage-1.63-3.el7.noarch 28/37 Verifying : perl-DBD-MySQL-4.023-5.el7.x86_64 29/37 Verifying : perl-Encode-2.51-7.el7.x86_64 30/37 Verifying : perl-podlators-2.5.1-3.el7.noarch 31/37 Verifying : perl-Getopt-Long-2.40-2.el7.noarch 32/37 Verifying : perl-File-Path-2.09-2.el7.noarch 33/37 Verifying : perl-threads-1.87-4.el7.x86_64 34/37 Verifying : 1:perl-Pod-Simple-3.28-4.el7.noarch 35/37 Verifying : perl-Filter-1.49-3.el7.x86_64 36/37 Verifying : perl-Text-ParseWords-3.29-4.el7.noarch 37/37 Installed: mariadb-server.x86_64 1:5.5.37-1.el7_0 Dependency Installed: libaio.x86_64 0:0.3.109-12.el7 mariadb.x86_64 1:5.5.37-1.el7_0 perl.x86_64 4:5.16.3-283.el7 perl-Carp.noarch 0:1.26-244.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBD-MySQL.x86_64 0:4.023-5.el7 perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-Encode.x86_64 0:2.51-7.el7 perl-Exporter.noarch 0:5.68-3.el7 perl-File-Path.noarch 0:2.09-2.el7 perl-File-Temp.noarch 0:0.23.01-3.el7 perl-Filter.x86_64 0:1.49-3.el7 perl-Getopt-Long.noarch 0:2.40-2.el7 perl-HTTP-Tiny.noarch 0:0.033-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PathTools.x86_64 0:3.40-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7 perl-Pod-Escapes.noarch 1:1.04-283.el7 perl-Pod-Perldoc.noarch 0:3.20-4.el7 perl-Pod-Simple.noarch 1:3.28-4.el7 perl-Pod-Usage.noarch 0:1.63-3.el7 perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 perl-Socket.x86_64 0:2.010-3.el7 perl-Storable.x86_64 0:2.45-3.el7 perl-Text-ParseWords.noarch 0:3.29-4.el7 perl-Time-Local.noarch 0:1.2300-2.el7 perl-constant.noarch 0:1.27-2.el7 perl-libs.x86_64 4:5.16.3-283.el7 perl-macros.x86_64 4:5.16.3-283.el7 perl-parent.noarch 1:0.225-244.el7 perl-podlators.noarch 0:2.5.1-3.el7 perl-threads.x86_64 0:1.87-4.el7 perl-threads-shared.x86_64 0:1.43-6.el7 Complete!
Timezone tables
# mysql -u root mythconverg Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 7 Server version: 5.5.37-MariaDB MariaDB Server Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [mythconverg]> SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC'); +----------------------------------------+ | CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') | +----------------------------------------+ | NULL | +----------------------------------------+ 1 row in set (0.00 sec)
