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