François Mehault a écrit :
> Hi Yann Cézard, Hi All
>
> I read your email and I saw that you upgraded your Bacula from 2.0.3 to 2.4.4
> like I want to do. Could you confirm me that I don't need to execute some
> script for the database ? You did just to do that to upgrade ?
>
> ./configure (your options)
> make
> make install
>
> Thanks,
>
> Regards
>
> François
>
>
Hi François,
As I said, I did a totally fresh install, I didn't kept back my volumes
nor my databases.
I just migrated my clients from the old installation to the new one day
by day,
activating each job on the new server when it was planned to be done Full.
So I am sorry, I can't say if the database really needs an update or not.
I have read your message, it seems that the difference of database
schema is just
one key that was dropped.
So I would say that it is not really important, having an unused key
will not break
your data, it will just make the insert/delete a little more slow. I think
that you can drop your key from the table, and create the new one (which
in fact
has just be renamed).
Something like :
ALTER TABLE File DROP KEY JobId;
ALTER TABLE File DROP KEY JobId_2;
ALTER TABLE File ADD KEY JobId (JobId, PathId, FilenameId);
But you should better wait for someone else to confirm before doing
this, cause I am not a MySQL expert (nor a Bacula one).
Or just test on a database copy !
Regards,
--
Yann Cézard - Administrateur Systèmes Serveurs
Centre de Ressources Informatiques - http://cri.univ-pau.fr
Université de Pau et des Pays de l'Adour - http://www.univ-pau.fr
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
