On Tuesday 13 December 2005 09:58, MaxxAtWork wrote: > Hello, > > I'd like to upgrade MySQL in use for Bacula from 3.23 to 5.0 (or at least > 4.1). I'm running Bacula 1.36 on RHEL3, and I've found a post by Scott > Barniger dated just one year ago that it's possible to install the > shared-compat rpm in order to avoid recompilation of Bacula. > > What would be a safe procedure to do the upgrade? > 1) stop Bacula > 2) backup mysql with e.g. mysqldump tool > 3) install mysql, mysql-server and mysql-shared-compat rpms > 4) reload the database > 5) run the mysql_fix_priviledge_tables [for MySQL 5.0] > 6) type "/etc/bacula/bacula start" with crossed fingers :-) > > Another question is: MySQL recommends to do the upgrade step by step, > i.e. 3.23 -> 4.0 -> 4.1 -> 5.0. Is that necessary and if it should be done, > does every step involve dumping and reloading again the database?
First, if you upgrade a version or more of MySQL, you will either need to rebuild Bacula from source or obtain an rpm built on the same version of MySQL to which you are migrating. When I upgraded from 3.23 to 4.1, I saved my database files, but I don't remember dumping and reloading them. Just the same, that would be a good idea because if nothing else, it will serve to compact your database. In going from 3.23 to 4.1, there was no need to use 4.0. To the best of my knowledge Bacula has not yet been tested on 5.0, so you might find some changes that create problems (MySQL has the tendancy similar to Microsoft to modify things such as the default character set encoding when upgrading version ...) > > Thanks > -- > Maxx > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_idv37&alloc_id865&opÌk > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Best regards, Kern ("> /\ V_V ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
