Re: [Phpwiki-talk] db file too humungous

[Reini U. <ru...@x-...>]

Ale Fernandez schrieb:
> 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?

The sqlite extension might work with such a file handle once opened,
but the PHP is_file() obviously cannot handle > 2GB.

I would try to despam it up on the commandline. Or work with a smaller 
backup.
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/