Thanks Simon!
We also store our critical data synchronously in flat (csv) files before
sending it in the sqlite database. When the hard reboot occured only one
of these was corrupted and only the last line.
We can always refill sqlite from these files, we use sqlite to allow us
to easily offer a
On 22 Oct 2015, at 11:16am, gunnar wrote:
> It's good to know there are so many possibilities to repair when it is really
> needed!
But it's worth noting that these are only possibilities. There is no guarentee
of repair. And trying out one possibility can corrupt your database further so
Hi Paul, thanks!
It's good to know there are so many possibilities to repair when it is
really needed!
On 10/19/2015 10:21 PM, Paul Sanderson wrote:
> Gunnar
>
> If the data is very important then don't do anything that will change
> the computer.
>
> If you have sometools that can take an image
Gunnar
If the data is very important then don't do anything that will change
the computer.
If you have sometools that can take an image copy of the disk (DD to
another drive) or maybe the free accessdata imaging software then I
would recommend doing this first - it will leave all options open
sho
Thanks a lot Simon!
We'll try it.
(BTW I also got an email from alexa, but looking in the sqlite mailing
list I can see that I'm not the only one)
On 10/19/2015 06:20 PM, Simon Slavin wrote:
> On 19 Oct 2015, at 5:13pm, gunnar wrote:
>
>> We run sqlite with PRAGMA synchronous=OFF.
>>
>> Now
Hi,
We run sqlite with PRAGMA synchronous=OFF.
Now we suffered from a 'hard reboot' because a sysadmin unplugged the
power cable :(
Is it possible to repair when you see after that:
OrderCallbackStorage::checkDatabaseIntegrity: row 1 [*** in database
main ***
On tree page 413956 cell 2: Rowid
On 19 Oct 2015, at 5:13pm, gunnar wrote:
> We run sqlite with PRAGMA synchronous=OFF.
>
> Now we suffered from a 'hard reboot' because a sysadmin unplugged the power
> cable :(
>
> Is it possible to repair
First take a copy of the database file and any other file from the same
directory wit
7 matches
Mail list logo