Groups | Search | Server Info | Login | Register


Groups > comp.databases.berkeley-db > #13

Re: I have a quick question about exporting or dumping a database.

From Florian Weimer <fw@deneb.enyo.de>
Newsgroups comp.databases.berkeley-db
Subject Re: I have a quick question about exporting or dumping a database.
Date 2012-08-10 20:34 +0200
Message-ID <87mx22sijl.fsf@mid.deneb.enyo.de> (permalink)
References <nIGdnZep5Ibg7rnNnZ2dnUVZ5uadnZ2d@giganews.com>

Show all headers | View raw


* jeff:

> I have a server running Citadel which uses Berkeley DB on the back end
> and I am trying to transfer the VM that is running it to a different
> server and when I just copy the virtual hard drive and load it the
> database is corrupt and cannot be fixed.

This is odd.  Are you copying a volume which is being written to?  If
you copy a read-only snapshot, it should work.

> 1. How long should it take to dump a database? Mine is about 7.4 GB
> with about 200 MB of log files right now.

That mostly depends on fragmentation.  About an hour would not be
entirely unheard of.

> 2. What is the best way to transfer the database to a different
> system? I would prefer a method that does not involve downtime as this
> is a production email system.

You need to make the database read-only at one point, otherwise some
writes will be lost.  And if you change versions of Berkeley DB, you
have to perform environment recovery, which also requires downtime.

Back to comp.databases.berkeley-db | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

I have a quick question about exporting or dumping a database. jeff <thexder1@gmail.com> - 2012-08-09 19:32 -0700
  Re: I have a quick question about exporting or dumping a database. Florian Weimer <fw@deneb.enyo.de> - 2012-08-10 20:34 +0200
    Re: I have a quick question about exporting or dumping a database. jeff <thexder1@gmail.com> - 2012-08-10 13:20 -0700
      Re: I have a quick question about exporting or dumping a database. Florian Weimer <fw@deneb.enyo.de> - 2012-08-10 22:42 +0200

csiph-web