On 12/15/2010 08:29 PM, Martin Simmons wrote:
>>>>>> On Wed, 15 Dec 2010 08:19:02 -0200, Rodrigo N de Castro Fernandes said:
>>
>> I would like to know how to change the MediaId from a VolumeName.
>> Just for backup Media/Volume sort organization.
>>
>> Can somebody help me? Is it possible? Is it recommended?
> 
> It isn't recommended, but you could do it with some SQL commands if you are
> very careful.
> 
> Purge the volume first, otherwise you will need to update the jobmedia table
> as well.  You may need to adjust the SQL sequence that controls the automatic
> numbering of new volumes as well, if you new MediaId is higher.  There may be
> other problems that I haven't though about...
> 
> __Martin
> 

If the name can be changed, bcopy could be an option oldname -> newname and so 
new id
but I, like Martin said, wouldn't touch the id in the database.


-- 

Bruno Friedmann (irc:tigerfoot)
Ioda-Net Sàrl www.ioda-net.ch
 openSUSE Member
    User www.ioda.net/r/osu
    Blog www.ioda.net/r/blog
  fsfe fellowship www.fsfe.org
GPG KEY : D5C9B751C4653227
vcard : http://it.ioda-net.ch/ioda-net.vcf

------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users