blob: 17568b4a04012848e24e1e05d3589f1ca4dc5eb4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
<?php
/**
* Run this script to after changing $wgDBPrefix on a wiki.
* The wiki will have to get downtime to do this correctly.
*
* @file
* @ingroup Maintenance
*/
$optionsWithArgs = array('old','new','help');
require_once( 'commandLine.inc' );
if( @$options['help'] || !isset($options['old']) || !isset($options['new']) ) {
print "usage:updateSpecialPages.php [--help] [--old x] [new y]\n";
print " --help : this help message\n";
print " --old x : old db prefix x\n";
print " --old 0 : EMPTY old db prefix x\n";
print " --new y : new db prefix y\n";
print " --new 0 : EMPTY new db prefix\n";
wfDie();
}
// Allow for no old prefix
if( $options['old'] === '0' ) {
$old = '';
} else {
// Use nice safe, sane, prefixes
preg_match( '/^[a-zA-Z]+_$/', $options['old'], $m );
$old = isset($m[0]) ? $m[0] : false;
}
// Allow for no new prefix
if( $options['new'] === '0' ) {
$new = '';
} else {
// Use nice safe, sane, prefixes
preg_match( '/^[a-zA-Z]+_$/', $options['new'], $m );
$new = isset($m[0]) ? $m[0] : false;
}
if( $old===false || $new===false ) {
print "Invalid prefix!\n";
wfDie();
}
if( $old === $new ) {
print "Same prefix. Nothing to rename!\n";
wfDie();
}
print "Renaming DB prefix for tables of $wgDBname from '$old' to '$new'\n";
$count = 0;
$dbw = wfGetDB( DB_MASTER );
$res = $dbw->query( "SHOW TABLES LIKE '".$dbw->escapeLike($old)."%'" );
foreach( $res as $row ) {
// XXX: odd syntax. MySQL outputs an oddly cased "Tables of X"
// sort of message. Best not to try $row->x stuff...
$fields = get_object_vars( $row );
// Silly for loop over one field...
foreach( $fields as $resName => $table ) {
// $old should be regexp safe ([a-zA-Z_])
$newTable = preg_replace( '/^'.$old.'/',$new,$table);
print "Renaming table $table to $newTable\n";
$dbw->query( "RENAME TABLE $table TO $newTable" );
}
$count++;
}
print "Done! [$count tables]\n";
|
