Re: [Bacula-users] Corrupted catalog on bad drive - please help!
2013-02-20 04:21:29
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
|
|
|