On Wed, Feb 20, 2013 at 12:17:30AM -0500, Michael Stauffer _g wrote:
> 
> How do I setup the DB using InnoDB? I'm not seeing that in the docs. (I'm
> sticking with bacula 3.0 for now, until I can get the catalog back and do
> another full backup). 
> 

Hello Michael, 

I can only answer this question: Create a dump of your old mysql
database using the -d option, this will only dump the table
definitions, then search replace 

Engine=MyISAM 

with 

Engine=InnoDB 

or do it in one fell swoop: 

mysqldump -u root -pXXXX -d bacula | sed
's/Engine=MyISAM/Engine=InnoDB/g' > dump.sql 

Also make sure you have the innodb_tables_as_files option set,
otherwise you db will be one huge unmanageable blob that can't be
reduced in size after a while by dumping / importing again. 


> What does it mean to retune MySQL for InnoDB?

Check the list archives, there's been a recent discussion about wether
it's worthwile tuning innodb or migrating to postgres outright ;) 

Good luck with your bscan, let us know how it goes (and how long it
took ;) 

All the best, Uwe 

> 
> Thanks!!
> 
> -M
> 
> 
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_feb
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 

NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA



------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users