db file too humungous

Ale Fernandez <[email protected]> Thu, 18 Sep 2008 13:05:55 +0100
Newsgroups gmane.comp.web.wiki.phpwiki.talk
Message-ID <[email protected]>
Hi,

I have a problem that an old phpwiki site I used to run has got spammed 
into a spam sandwich that would have scooby doo sweating. It's 2 gb or 
so in size.

Here's the error I get on most pages:

----------------
Fatal Error:

lib/WikiDB/backend/PearDB.php:59: Error: Can't connect to database: 
wikidb_backend_peardb_sqlite: fatal database error

     * DB Error: invalid
     * ( ** ** sqlite:////var/lib/phpwiki/phpwiki_pagedb.db)
     *

/usr/share/php/DB/sqlite.php:134: Warning: is_file(): Stat failed for 
/var/lib/phpwiki/phpwiki_pagedb.db (errno=75 - Value too large for 
defined data type)

lib/WikiDB/backend/PearDB.php:59: Error: Can't connect to database: 
wikidb_backend_peardb_sqlite: fatal database error

     * DB Error: invalid
     * ( ** ** sqlite:////var/lib/phpwiki/phpwiki_pagedb.db)

-------------------

Is there a way to fix this, or a way to connect directly to the db file 
so as to delete the masses of spam comments?

Thanks,

Ale


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/