We don't have the Index privilege with MySQL but do have Alter Table which allows indexes to be created using an equivalent SQL instruction.
I created the following Perl program to reformat ./maintenance/tables.sql to change CREATE ... INDEX lines to ALTER TABLE equivalents.
[code=editsql.pl]
#!/usr/bin/perl
use CGI::Carp qw/fatalsToBrowser/;
use strict;
print "Content-type: text/plain\n\n";
my $path = "./maintenance";
my $file = "tables.sql";
my ($name, $ext) = split '\.', $file;
# save up to 3 old versions (as .0, .1, .2)
for (my $i=2; $i>=0; $i--) {
my $j = $i-1;
my $oldfile = $i ? "$path/$name.$j.$ext" : "$path/$file";
my $newfile = "$path/$name.$i.$ext";
rename $oldfile, $newfile if -e $oldfile;
}
my $infile = "$path/$name.0.$ext";
my $outfile = "$path/$file";
print "editing file $infile\n";
open my $in, '<', $infile or die "Can't read old file: $infile";
open my $out, '>', $outfile or die "Can't write new file: $outfile";
my $changed = 0;
my $e1 = "-- Edited to change CREATE INDEX commands to ALTER TABLE equivalents\n"
. "-- to suit assigned user privileges\n\n";
print $e1;
print $out $e1;
while( <$in> ) {
my $orig = $_;
s/CREATE +(INDEX|UNIQUE +INDEX|FULLTEXT +INDEX) +(\S+) +ON +(\S+) +([^;]+)/ALTER TABLE $3 ADD $1 $2 $4/i;
$changed++ if $orig ne $_;
print $_;
print $out $_;
}
close $out;
my $lines = $. + 3;
print "done ... output file $outfile contains $lines lines; 3 lines added, $changed lines changed\n";
[/code]
That program needs to be uploaded to the /mediawiki directory and its permissions set to 0700 (user read, write and execute). Browse to the file to run it. (111 lines in the file get changed.)
Mediawiki 1.18.5 (which is compatible with MySQL 4.1.11) installs OK on ccgi after changing that file (and setting all file and directory permissions as suggested elsewhere by Gabe). Editing the LocalSettings.php file that the installation process creates to remove /~username from $wgScriptPath will avoid the username appearing in URLs.
David
David
