Teg <[EMAIL PROTECTED]> wrote:
> I have a 15 gig database that I'm trying to "vacuum", the table
> structure's butt simple but, after running most of the night it tells
> me "Database is Full". Not sure exactly what that means.
> 
> I have 24 gigs of disk space free on the disk so, I don't think I ran
> out.

It takes a little over 30GiB of free disk space to vacuum
a 15GiB file.

If you don't have that much space, you can vacuum this way:

   sqlite3 olddb .dump | sqlite3 newdb
   rm olddb
   mv newdb olddb

That only takes about 15GiB of disk space, but is not atomic.

> 
> SQlite3.exe is 3.2.2
> 
> It's telling me the "database disk image is malformed" now too.

This bug was fixed in 3.2.6.  See the first bullet on the release
notes.

--
D. Richard Hipp   <[EMAIL PROTECTED]>

Reply via email to