3,240
edits
Changes
From SME Server
Jump to navigationJump to search→Upgrading 4.4 to 5.0
* migrate your db from mariadb 5.5 to mariadb 10.5 with its user if not already done
* migrate your db from mariadb 5.5 to mariadb 10.5 with its user if not already done
* fix the row format to dynamic<syntaxhighlight lang="mysql">
* fix the row format to dynamic<syntaxhighlight lang="bash">
USE zabbixdb;
echo "USE $(config getprop zabbix-server DbName); alter table hosts row_format = dynamic; "|mysql105
alter table hosts row_format = dynamic;
</syntaxhighlight>
</syntaxhighlight>
* fix ENGINE if forgotten before
* fix ENGINE if forgotten before (y'''ou better doing it before importing it''', converting the history table could take days (yes days not hours)
<syntaxhighlight lang="bash">
<syntaxhighlight lang="bash">
echo "SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;') FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='MyISAM' AND table_schema = 'zabbixdb';" |mysql105 -s|mysql105 zabbixdb
echo "SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;') FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='MyISAM' AND table_schema = 'zabbixdb';" |mysql105 -s|mysql105 zabbixdb
drop procedure zbx_convert_utf8;"|mysql105 `config getprop zabbix-server DbName`
drop procedure zbx_convert_utf8;"|mysql105 `config getprop zabbix-server DbName`
</syntaxhighlight>
</syntaxhighlight>
* fix the table with database/mysql/double.sql
* fix the table with database/mysql/double.sql<syntaxhighlight lang="mysql">
cat /usr/share/doc/zabbix-server-mysql-5.0.30/double.sql |mysql105 `config getprop zabbix-server DbName`
</syntaxhighlight>
* install 5.0 using rpms<syntaxhighlight lang="bash">
* install 5.0 using rpms<syntaxhighlight lang="bash">
db yum_repositories setprop zabbix44 status disabled
db yum_repositories setprop zabbix44 status disabled
rpm -e --nodeps zabbix-web-mysql zabbix-web smeserver-zabbix-server
rpm -e --nodeps zabbix-web-mysql zabbix-web smeserver-zabbix-server
yum install smeserver-zabbix-server-z50 --enablerepo=smecontribs,smetest,smedev
yum install smeserver-zabbix-server-z50 --enablerepo=smecontribs,smetest,smedev
</syntaxhighlight>
</syntaxhighlight>
