[Bacula-users] Database corruption problems

2006-03-20 Thread Dan Rich
I've run into an odd problem where my database has become corrupted. 
I've decided that this is a good time to migrate my database from sqlite
to mysql, but have a problem.

Since the old database is corrupted sqlite3 won't read anything from
it.  Does anyone have tools to scan the existing volumes and rebuild the
database?  I can probably build some scripts to do part of the job, but
I'm not sure what all of the table interdependencies are, so it's a bit
risky.

-- 
Dan Rich [EMAIL PROTECTED] |   http://www.employees.org/~drich/
   |  Step up to red alert!  Are you sure, sir?
   |   It means changing the bulb in the sign...
   |  - Red Dwarf (BBC)




signature.asc
Description: OpenPGP digital signature


[Bacula-users] Database corruption problems

2006-03-20 Thread Dan Rich
I've run into an odd problem where my database has become corrupted. 
I've decided that this is a good time to migrate my database from sqlite
to mysql, but have a problem.

Since the old database is corrupted sqlite3 won't read anything from
it.  Does anyone have tools to scan the existing volumes and rebuild the
database?  I can probably build some scripts to do part of the job, but
I'm not sure what all of the table interdependencies are, so it's a bit
risky.

-- 
Dan Rich [EMAIL PROTECTED] |   http://www.employees.org/~drich/
   |  Step up to red alert!  Are you sure, sir?
   |   It means changing the bulb in the sign...
   |  - Red Dwarf (BBC)




signature.asc
Description: OpenPGP digital signature


[Bacula-users] Database corruption problems

2006-03-20 Thread Dan Rich
I've run into an odd problem where my database has become corrupted. 
I've decided that this is a good time to migrate my database from sqlite
to mysql, but have a problem.

Since the old database is corrupted sqlite3 won't read anything from
it.  Does anyone have tools to scan the existing volumes and rebuild the
database?  I can probably build some scripts to do part of the job, but
I'm not sure what all of the table interdependencies are, so it's a bit
risky.

-- 
Dan Rich [EMAIL PROTECTED] |   http://www.employees.org/~drich/
   |  Step up to red alert!  Are you sure, sir?
   |   It means changing the bulb in the sign...
   |  - Red Dwarf (BBC)




signature.asc
Description: OpenPGP digital signature


Re: [Bacula-users] Database corruption problems

2006-03-20 Thread Dan Rich
Dan Rich wrote:
 I've run into an odd problem where my database has become corrupted. 
 I've decided that this is a good time to migrate my database from sqlite
 to mysql, but have a problem.

 Since the old database is corrupted sqlite3 won't read anything from
 it.  Does anyone have tools to scan the existing volumes and rebuild the
 database?  I can probably build some scripts to do part of the job, but
 I'm not sure what all of the table interdependencies are, so it's a bit
 risky.

   
(Sorry about the multiple messages - my mail server refused the mail and
then apparently sent it anyway).

-- 
Dan Rich [EMAIL PROTECTED] |   http://www.employees.org/~drich/
   |  Step up to red alert!  Are you sure, sir?
   |   It means changing the bulb in the sign...
   |  - Red Dwarf (BBC)




signature.asc
Description: OpenPGP digital signature


Re: [Bacula-users] Database corruption problems

2006-03-20 Thread Jason Martin
On Mon, Mar 20, 2006 at 04:22:58PM -0800, Dan Rich wrote:
 it.  Does anyone have tools to scan the existing volumes and rebuild the
 database?  I can probably build some scripts to do part of the job, but
Check out 'bscan' in the documentation, it does that.

-Jason Martin

-- 
If winning isn't important then why keep score?
This message is PGP/MIME signed.


pgpIpvFDsBlIU.pgp
Description: PGP signature