> Message: 14
> Date: Wed, 20 Feb 2013 10:17:08 +0100
> From: Uwe Schuerkamp <uwe.schuerkamp AT nionex DOT net>
> Subject: Re: [Bacula-users] Corrupted catalog on bad drive - please
>       help!
>
> 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.
> 

So if I'm making a new empty database using the setup script in bacula, then
I'll do this step - right?

> > 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 ;)

OK, thanks very much, I'll let you know.

-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