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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
