[Mediawiki-l] Migrating to a new server

Cameron cameronem at gmail.com
Fri Aug 22 02:56:54 UTC 2008

Not sure if this is the kind of level you are after but this is what I wrote
up for use in my organisation if we need to perform a complete disaster
recovery of our wiki. This has been tested numerous times for both recovery
on the same server, as well as migrating to another server. I haven't tried
between OS though but don't see there would be any issues with that.

Before doing this, Apache2 needs to be configured in the same manner (ie
same directory root etc), correct php version installed and compiled, etc.

A couple of things: wikidb.servername.$DAY is just a gzipped mysql dump of
the database. wikifiles.$DAY.tbz is simply a tar of the entire directory
structure. I have a cron job run daily to backup both.

Create Database
Mysql –u root –p
Create database wikidb;
Restore Database files
Cd /<backup location>
Gunzip wikidb.servername.$DAY.gz
Mysql –u root –p wikidb < wikidb.servername.$DAY

Ensure database restored
mysql -u root -p wikidb
show tables;
<list of tables (about 35 should appear).

Create Wiki User account in MYSQL
Mysql –u root -p
create user 'wikiuser'@'localhost' IDENTIFIED BY 'password to be used:
IMPORTANT make sure this is also the same as in the LocalSettings.php
Grant privileges to wikiuser on wikidb database
Mysql –u root –p
GRANT ALL ON wikidb.* TO wikiuser at localhost IDENTIFIED BY 'password to be
Flush privileges;

Restore wiki config files and images
Cd /
Tar –xvjf /<backup location>/wikifiles.$DAY.tbz
Complete restore process complete – to make sure, perform test plan again

Potential things that ** may ** be required are:
/<wiki install>/maintenance/php5 rebuildall.php
Double double check the correct database, username, password are used in the
/<wiki install>/LocalSettings.php file
Make sure apache is set up correctly, and the wiki location set
appropriately in the LocalSettings.php file



On Fri, Aug 22, 2008 at 2:46 AM, Steve VanSlyck <s.vanslyck at spamcop.net>wrote:

> Realizing the article is there, I've seen a ton of questions raised
> about the process as that page directs, issues coming up, doesn't
> work, etc. The "manual" I'm talking about would be something tested at
> every stage and the doesn't assume any user knowledge at all.
> wolkwitz at fh-swf.de wrote:
> > Hi all,
> >
> > have you tried this page?
> >
> > http://www.mediawiki.org/wiki/Manual:Moving_a_wiki
> >
> > Not sure as to how helpfull this is, but it might be a good starting
> point...
> >
> > Good luck with the move!
> >
> > Katharina
> >
> > Steve VanSlyck schrieb am 21.08.2008 15:02:
> >> Seems this question comes up a lot, as well as the question as to all
> >> the various steps needed, doorknob to doorknob as they say, to back up
> >> and restore an entire DB. Maybe an exhaustive how-to manual of these
> >> two items would be a good idea. Anyone? Bueller? Anyone?
> >>
> >>> On Aug 21, 2008, at 3:47 PM, De Kock, Stefan wrote:
> >>>
> >>>> What would the easiest way be to move a MediaWiki installation from
> >>>> one server to another? I have installed MySQL and PHP already on
> >>>> the new server. What I had in mind was to setup the latest MediaWiki
> >>>> installation on the new server, export all the pages and import them
> >>>> on the new server. Is there an easier way?
> >
> > _______________________________________________
> > MediaWiki-l mailing list
> > MediaWiki-l at lists.wikimedia.org
> > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> >
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

More information about the MediaWiki-l mailing list