Does anyone know the difference between the following directories? [root@mon01-test mysql]# cd /usr/share/doc/icinga-idoutils-libdbi-mysql-1.11.6/db/mysql/upgrade [root@mon01-test upgrade]# ls -l total 160 -rw-r--r-- 1 root root 350 Aug 6 14:52 mysql-upgrade-0.8.3.sql -rw-r--r-- 1 root root 14391 Aug 6 14:52 mysql-upgrade-1.0.1.sql -rw-r--r-- 1 root root 19486 Aug 6 14:52 mysql-upgrade-1.0.2-fix-object-relations.sql -rw-r--r-- 1 root root 1004 Aug 6 14:52 mysql-upgrade-1.0.2.sql -rw-r--r-- 1 root root 476 Aug 6 14:52 mysql-upgrade-1.0.3.sql -rw-r--r-- 1 root root 898 Aug 6 14:52 mysql-upgrade-1.0rc.sql -rw-r--r-- 1 root root 7624 Aug 6 14:52 mysql-upgrade-1.0.sql -rw-r--r-- 1 root root 3027 Aug 6 14:52 mysql-upgrade-1.10.0.sql -rw-r--r-- 1 root root 4634 Aug 6 14:52 mysql-upgrade-1.11.0.sql -rw-r--r-- 1 root root 1330 Aug 6 14:52 mysql-upgrade-1.11.3.sql -rw-r--r-- 1 root root 887 Aug 6 14:52 mysql-upgrade-1.11.6.sql -rw-r--r-- 1 root root 1946 Aug 6 14:52 mysql-upgrade-1.3.0.sql -rw-r--r-- 1 root root 40283 Aug 6 14:52 mysql-upgrade-1.4.0.sql -rw-r--r-- 1 root root 1171 Aug 6 14:52 mysql-upgrade-1.5.0.sql -rw-r--r-- 1 root root 9090 Aug 6 14:52 mysql-upgrade-1.6.0.sql -rw-r--r-- 1 root root 5338 Aug 6 14:52 mysql-upgrade-1.7.0.sql -rw-r--r-- 1 root root 5700 Aug 6 14:52 mysql-upgrade-1.8.0.sql -rw-r--r-- 1 root root 984 Aug 6 14:52 mysql-upgrade-1.9.0.sql
[root@mon01-test upgrade]# cd /usr/share/doc/icinga-web-1.11.0/schema/updates/mysql [root@mon01-test mysql]# ls -l total 64 -rw-r--r-- 1 root root 198 Mar 13 06:24 mysql_v1-0-3_to_v1-2.sql -rw-r--r-- 1 root root 206 Mar 13 06:24 mysql_v1-10-0_to_1-10-1.sql -rw-r--r-- 1 root root 2688 Mar 13 06:24 mysql_v1-2_to_v1-3.sql -rw-r--r-- 1 root root 153 Mar 13 06:24 mysql_v1-3_to_v1-4.sql -rw-r--r-- 1 root root 167 Mar 13 06:24 mysql_v1-4_to_v1-5.sql -rw-r--r-- 1 root root 216 Mar 13 06:24 mysql_v1-5_to_v1-6.sql -rw-r--r-- 1 root root 705 Mar 13 06:24 mysql_v1-6-2_to_v1-7.sql -rw-r--r-- 1 root root 59 Mar 13 06:24 mysql_v1-6_to_v1-6-2.sql -rw-r--r-- 1 root root 103 Mar 13 06:24 mysql_v1-7-0_to_v1-7-1.sql -rw-r--r-- 1 root root 298 Mar 13 06:24 mysql_v1-7-1_to_v1-7-2.sql -rw-r--r-- 1 root root 1486 Mar 13 06:24 mysql_v1-7-2_to_v1-8-0.sql -rw-r--r-- 1 root root 237 Mar 13 06:24 mysql_v1-8-0_to_v-1-8-1.sql -rw-r--r-- 1 root root 1073 Mar 13 06:24 mysql_v1-8-1_to_v1-8-3.sql -rw-r--r-- 1 root root 496 Mar 13 06:24 mysql_v1-8-3_to_v1-9.sql -rw-r--r-- 1 root root 129 Mar 13 06:24 mysql_v1-9-0_to_1-9-1.sql -rw-r--r-- 1 root root 194 Mar 13 06:24 mysql_v1-9-1_to_1-10-0.sql I think these are for upgrading the MySQL databases for icinga and icinga web but i'm not 100% sure. Also, in the /usr/share/doc/icinga-idoutils-libdbi-mysql-1.11.6/db/mysql/upgrade dir, I assume these are to upgrade the icinga DB but which one do I use? My current icinga db version: mysql> use icinga; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from icinga_dbversion; +--------------+----------+---------+---------------------+---------------------+ | dbversion_id | name | version | create_time | modify_time | +--------------+----------+---------+---------------------+---------------------+ | 1 | idoutils | 1.8.0 | 2013-05-21 06:53:40 | 2013-05-21 06:53:40 | +--------------+----------+---------+---------------------+---------------------+ 1 row in set (0.00 sec) I have 1.8 installed so do i incrementally install all the way up to mysql-upgrade-1.11.6.sql? BTW, please see the following version of icinga installed: [root@mon01-test mysql]# rpm -qa | grep icinga icinga-idoutils-libdbi-mysql-1.11.6-0.el6.x86_64 icinga-debuginfo-1.11.6-0.el6.x86_64 icinga-doc-1.11.6-0.el6.x86_64 icinga-web-1.11.0-1.el6.noarch icinga-idoutils-1.11.6-0.el6.x86_64 icinga-gui-config-1.11.6-0.el6.x86_64 icinga-web-mysql-1.11.0-1.el6.noarch icinga-1.11.6-0.el6.x86_64 icinga-gui-1.11.6-0.el6.x86_64 icinga-devel-1.11.6-0.el6.x86_64
_______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users
