MediaWiki - Advice on Upgrade/Migration

hotwired007

Member
Sep 19, 2011
533
7
16
UK
Hi Guys, not really a proxmox issue, but maybe you can help?

I have a W2k3 Server running iis and mediawiki, i want to move it to a proxmox hosted version of MediaWiki, i have found the OpenVZ appliance and downloaded it, but i want to upgrade it to the 1.17 release and then transfer the existing DB and files from the windows box.

Whats the best way to do this? I have PUTTY installed and have used the PSFTP utility in the past for moving files from windows to linux boxes. What do I need to do?

Cheers
 
the Debian version of MediaWiki is still 1.15. so if you want to run a newer one, you cannot use the Debian packages/appliance, you need to install manually, using the tar.gz download from mediawiki.

using the Debian packages is very convenient, but some times you have to live with older versions, but stable ones.
 
Cheers, I'll stick with the 1.15 version then :)

I ahve installed phpmyadmin on the box and managed to transfer my DB across BUT i'm not sure what files to move from my windows mediawiki install... i have copied the images folder and LocalSettings.php files off of the server to move but not sure the best way to transfer them to the VM.
 
I am quit unsure that you can migrate a mediawiki 1.17 database into a 1.15.
 
The version i have installed is 1.8, just tring to work out the command to get the images folder and the LocalSettings.php folder to copy to the correct location... i believe its: /var/lib/mediawiki/ any tips for using PSFTP? :)
 
Written a quick guide:

Migrating MediaWiki Server:


Download Proxmox Appliance (Debian 6 Media Wiki 1.15)
Configure IP address, Password, DNS server etc
Change SQL password (admin): (Open VNC Connection)
sqladmin -u root -p password newpassword
Run updates:
aptitude update
aptitude upgrade
install phpmyadmin:
aptitude install phpmyadmin
edit php.ini to allow larger uploads to the server:
vi /etc/php5/apache2/php.ini
(Move to section:)
:/2M
highlight 2 and press r, press 8 and then press :x <return> to quit
reboot
Export original wikidb from SQL server (Zipped SQL)
Open URL mediawikiip/phpmyadmin and login using root
import exported SQL db
Open URL mediawikiip
follow install instructions using OLD mediawiki settings from LocalSettings.php file.
Move LocalSettings.php from /var/lib/mediawiki/config to /var/lib/mediawiki/
cd /var/lib/mediawiki/config
mv LocalSettings.php ../
ls -a (confirm file has moved)
cd ../
ls -a (confirm file has moved) (Look at setting access permissions to this)
reboot
Copy images folder
Connect using PSFTP to copy images folder to new MediaWiki Server
create a zip file of the images folder called images.zip
Open PSFTP
set local working directory to folder where your backup copy of mediawiki is
lcd C:\wikibackup\old
lpwd (Use lpwd to find out what it is currently set to)
open mediawikiip
cd /var/lib/mediawiki
put images.zip
aptitude install unzip
unzip images
Open URL mediawikiip ( and check images)
rm /var/lib/mediawiki/images.zip
 
Now having an issue getting the $wgLogo to work - if I have the line uncommented it the whole wiki goes offline... the paths fine when i put it into my browser and shows the image perfectly