On 29 May 2009, at 10:42am, elmarr...@systemcompetence.de wrote:

> My question would be, how I can resize the db file or how to check  
> if it
> is corrupted. Or what I can do to access my data.

Use the command-line tool to open it, and check it can access records  
using a few 'SELECT' statements.  If those work, you can use the  
'PRAGMA integrity_check;' statement to check for corruption.

http://www.sqlite.org/sqlite.html

http://www.sqlite.org/pragma.html

> Or is it possible to configure sqlight to not load the hole database  
> in
> the memory? Or something like that.

Unless you are specifically messing with your configuration, sqlite  
would not try to load a 2GB database into memory.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to