On 05/01/2015 05:14 PM, Clark, Patricia A. wrote:
> I am in the process of migrating from one bacula system to another.  In order 
> to have multiple storage daemons and autochangers, I am changing my media 
> type from LTO-5 to LTO-5-admin and the pool is changing from MYPOOL to 
> POOL5a.  We imported and updated the catalog.  I can modify the volumes and 
> give the new pool as POOL5a, but I still need to change the media type 
> without relabeling the volumes.  I've searched the documentation and the list 
> without finding a viable answer.  Is there a command that I can use or is 
> using SQL a workable option?
> 

Hi Patricia

You can use two simple SQL commands:

# mysql -u bacula -pPassword bacula

First, get the pool Id's:

> SELECT PoolId, Name FROM Pool;

Then update your moved media:
> UPDATE Media SET MediaType='LTO-5-admin' WHERE PoolId='actualPOOL5a-PoolId';


Hope this helps on a late Friday afternoon.  ;)

Bill


-- 
Bill Arlofski
Reverse Polarity, LLC
http://www.revpol.com/
-- Not responsible for anything below this line --

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users