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