Re: [sqlite] Database corruption

[Mrs. Brisby]

On 2005-10-07 at 11:11, <a 
href="http://tick/%7Egeocar/netmail/ws.cgi?action=v2;[EMAIL PROTECTED]">[EMAIL 
PROTECTED]</a> wrote:
&nbsp;<br>
&gt; "Mrs. Brisby" &lt;<a 
href="http://tick/%7Egeocar/netmail/ws.cgi?action=v2;[EMAIL PROTECTED]">[EMAIL 
PROTECTED]</a>&gt; wrote:
&nbsp;<br>
&gt; 
&nbsp;<br>
&gt; &gt; I had some MacOSX systems suffer a power failure, when they came back
&nbsp;<br>
&gt; &gt;  I made some copies of the database and: [integrity_check failed]
&nbsp;<br>
&gt; 
&nbsp;<br>
&gt; 
&nbsp;<br>
&gt; This suggests that you copied only the database file itself and not its
&nbsp;<br>
&gt; rollback journal.  That can lead to corruption.
&nbsp;<br>
<br>
There was no rollback journal.&nbsp; This is why I'm worried.<br>
<br>
&gt; Failing that, you can try to do a ".dump" of the database into a fresh
&nbsp;<br>
&gt; database.  If ".dump" gives problems, try running it separately for
&nbsp;<br>
&gt; each table in the database file.  You should be able to recover most of
&nbsp;<br>
&gt; your data that way, but some patching and fixing will still likely be
&nbsp;<br>
&gt; necessary once you are done.<br>
<br>
.dump appears to work for most data. I'm using this.<br>