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=/