[Mediawiki-l] Delete Histories, with multiple wikis and indiv databases

Wed Dec 27 03:09:01 UTC 2006

My wikis are hosted at Dreamhost. They said to run php 5 from the  
command line I had to do this, which I did:

[cognac]$ /usr/local/php5/bin/php deleteOldRevisions.php --delete
X-Powered-By: PHP/5.1.2
Content-type: text/html

Delete Old Revisions

Searching for active revisions...done.
Searching for inactive revisions...done.
1 old revisions found.
Deleting...done.
Searching for active text records in revisions table...done.
Searching for active text records in archive table...done.
Searching for inactive text records...done.
1 inactive items found.
Deleting...done.

But it didn't delete the old histories, just one record. As I have  
mentioned I made the settings in AdminSettings.php:

$wgDBserver         = "mysql.mydomain.com";
$wgDBname           = "mydatabase";
$wgDBuser           = "myusername";
$wgDBpassword       = "mypassword";
$wgDBprefix         = "wiki_";
$wgDBtype           = "mysql";
$wgDBport           = "5432";

Weird.

Tim

Thanks Rob.

On 27/12/06, Rob Church wrote:
 > I then changed the name of that file to AdminSettings.pgp

That would have to be .php

OK.

> > X-Powered-By: PHP/4.4.4
> > Content-type: text/html
>
> >From the command line, what's being run is an old PHP 4.4 CGI, not  
> the
> PHP 5 that MediaWiki needs. You need to use the PHP 5 CLI to execute
> the script.
>
I'm not a strong command line guy. How do I execute a "PHP5 CLI"?
> I don't remember for sure, but I don't think deleteOldRevisions.php
> uses $wgDBadminuser &c - I suspect it falls back to the existing
> database settings, since those are all that's required.
>
> IIRC, maintenance scripts can be told to use a specific
> LocalSettings.php with the --config option at runtime.
>
Well, I'm not sure what a lot of that means, but I guess the command  
line would look like this:

php deleteOldRevisions.php  --delete --config LocalSettings-1.php

where I would create a LocalSettings-1.php and just include the  
settings for the db I want to delete histories for? In my  
LocalSettings I use php to check what subdomain the user is calling,  
then point to the settings for that wiki.

OK, I'm a bit confused.

Tim

> *Please* back up everything. :)

Rob Church