Re: db file too humungous

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/

------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you.  Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/