Hi All ! I want to upgrade my Bacula (currently in v 2.0.3) in 2.4.4. So, I install the Bacula v 2.4.4 on another OS just to see the difference. Then I realized a dump of the catalogue database in my Bacula v 2.0.3 and 2.4.4 to compare. I did a diff on my two dump and there is one thing which is strange
Bacula 2.0.3 DROP TABLE IF EXISTS `File`; CREATE TABLE `File` ( `FileId` int(10) unsigned NOT NULL auto_increment, `FileIndex` int(10) unsigned default '0', `JobId` int(10) unsigned NOT NULL, `PathId` int(10) unsigned NOT NULL, `FilenameId` int(10) unsigned NOT NULL, `MarkId` int(10) unsigned default '0', `LStat` tinyblob NOT NULL, `MD5` tinyblob, PRIMARY KEY (`FileId`), KEY `JobId` (`JobId`), KEY `JobId_2` (`JobId`,`PathId`,`FilenameId`) ) ENGINE=MyISAM AUTO_INCREMENT=785251836 DEFAULT CHARSET=latin1; Bacula 2.4.4 DROP TABLE IF EXISTS `File`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `File` ( `FileId` int(10) unsigned NOT NULL auto_increment, `FileIndex` int(10) unsigned default '0', `JobId` int(10) unsigned NOT NULL, `PathId` int(10) unsigned NOT NULL, `FilenameId` int(10) unsigned NOT NULL, `MarkId` int(10) unsigned default '0', `LStat` tinyblob NOT NULL, `MD5` tinyblob, PRIMARY KEY (`FileId`), KEY `JobId` (`JobId`,`PathId`,`FilenameId`) ) ENGINE=MyISAM AUTO_INCREMENT=199415 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; More precisely: Bacula 2.0.3 PRIMARY KEY (`FileId`), KEY `JobId` (`JobId`), KEY `JobId_2` (`JobId`,`PathId`,`FilenameId`) Bacula 2.4.4 PRIMARY KEY (`FileId`), KEY `JobId` (`JobId`,`PathId`,`FilenameId`) The two Bacula are on FreeBSD 7, for each I look in /usr/ports/sysutils/bacula-server/work/bacula-2.0.3/updatedb And /usr/ports/sysutils/bacula-server/work/bacula-2.4.4/updatedb For the first, about mysql I can see: -rwxr-xr-x 1 root wheel 3.2K Nov 3 2005 update_mysql_tables_8_to_9 And for the second -rwxr-xr-x 1 root wheel 2.4K Apr 1 2007 update_mysql_tables_9_to_10 I opened update_mysql_tables_9_to_10 and can read echo "This script will update a Bacula MySQL database from version 9 to 10" echo " which is needed to convert from Bacula version 1.38.x to 2.0.x or higher" echo "Depending on the size of your database," echo "this script may take several minutes to run." So I conclude I don't need to execute any script to upgrade my catalogue database to pass in 2.4.4, but there is the first thing that I find strange :s It could raise problem? Thanks François
------------------------------------------------------------------------------
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
