(sorry about the topic drift, Craig -- this will be the last message from me in this sub-thread :-)
"James Harper" <james.har...@bendigoit.com.au> writes: >> oh, sure -- I'm only worried about the database schema update. I >> currently have 350M rows in File (90 days retention -- I'd like to >> increase that, but ...). > > Never tried this before, but you could create a new, empty catalog > and start using that after the upgrade. You can then upgrade the old > catalog and then swap back to the old one once the upgrade is > finished, or just keep using the new one and keep the old one for > restoring from in the event that it is required. good idea, but if I start with an empty catalog, the MediaId for existing media will be wrong. same goes for PathId, FilenameId, ClientId etc. I think I'll use a similar technique to how I'm currently doing the MyISAM -> InnoDB conversion: create a copy of the old File table, convert it at leisure. when done, add the jobs which has run in the interim. repeat if needed. when in sync, do the switch to 3.0. I haven't looked into how much tweaking I'll have to do of the conversion procedure, but if it's significant, I'll post my patches. -- Kjetil T. Homme Redpill Linpro AS - Changing the game ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
