Damaged database?

[Adam Dershowitz]

On Feb 22, 2013, at 3:55 PM, Rainer Müller wrote:

> Hello,
> 
> On 2013-02-22 19:18, Adam Dershowitz wrote:
>> Error: org.macports.deactivate for port gst-plugins-base returned:
>> sqlite error: database disk image is malformed (11) while executing
>> query: SELECT actual_path FROM registry.files WHERE id=? AND active
>> ORDER BY actual_path
> 
> Your SQLite DB was probably in an inconsistent state when your computer
> had a problem. This means the data on disk is damaged and SQLite is
> unable to recover from this by itself.
> 
> Although it might require some time to rebuild some ports, the easiest
> of your options would be to wipe the installation and start from scratch.
> 
> First check the list of requested ports to get an idea what you have
> installed and write down anything important to you:
> 
>  port echo requested and active
> 
> Then follow the instructions given in the guide for uninstalling [1].
> Ignore the first step as you cannot properly run 'port uninstall' with a
> damaged database. Afterwards reinstall from the disk image [2] and
> reinstall any ports noted down previously.
> 
> Rainer
> 
> [1] http://guide.macports.org/#installing.macports.uninstalling
> [2] https://www.macports.org/install.php
> 

Thanks.  That's what I figured.
The other thought that I had, is that I might go to an older backup.  I assume that I should only restore a full copy of the /opt/local directory?  If I were to just restore registry.db, then it could be different from some port and that would be bad.