Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Wikipedia: Mediawiki

Migrating to a new server

 

 

Wikipedia mediawiki RSS feed   Index | Next | Previous | View Threaded


sdekock at za

Aug 21, 2008, 5:47 AM

Post #1 of 9 (2349 views)
Permalink
Migrating to a new server

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?


Email Confidentiality Notice and Disclaimer-This email message contains information which may be confidential and/or legally privileged. Unless you are the intended recipient (or have been authorized to receive on behalf of the intended recipient), you may not use, copy or disclose to anyone the message or any information contained in the message or from any attachments that were sent with this email. If you have received this email message in error, please advise the sender by email and delete the message. Thank you.


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


rob at colorist

Aug 21, 2008, 5:55 AM

Post #2 of 9 (2310 views)
Permalink
Re: Migrating to a new server [In reply to]

Hello Stefan, I'm doing the same thing and if you get any private
advice,
I'd be interested.

I already tried without success to move my wiki from Fedora to CentOS;
I first tarred up the entire wiki file structure, and then with a
fresh dump of
the mysql db tried just reloading the db with the dump, but I had a
problem
running PHP - (installed via yum as php-mysql) - where the logs showed
that the PCRE libs were not built to support UTF-8 encoding; however,
a check of PCRE showed no problem. Then (it was late at night) I did
a stupid thing and tried removing and reinstalling PCRE using yum. That
basically took out so many system tools that I had to reload the OS, and
presently (OS just reloaded today) I'll be ready to try again, perhaps
with
a different strategy.

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?

--
Rob Lingelbach
rob [at] colorist http://www.colorist.org/robhome.html




_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


s.vanslyck at spamcop

Aug 21, 2008, 6:02 AM

Post #3 of 9 (2314 views)
Permalink
Re: Migrating to a new server [In reply to]

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
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


wolkwitz at fh-swf

Aug 21, 2008, 7:18 AM

Post #4 of 9 (2311 views)
Permalink
Re: Migrating to a new server [In reply to]

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
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


s.vanslyck at spamcop

Aug 21, 2008, 7:46 AM

Post #5 of 9 (2314 views)
Permalink
Re: Migrating to a new server [In reply to]

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 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
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


cameronem at gmail

Aug 21, 2008, 7:56 PM

Post #6 of 9 (2298 views)
Permalink
Re: Migrating to a new server [In reply to]

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;
Exit
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
file!';
Grant privileges to wikiuser on wikidb database
Mysql –u root –p
GRANT ALL ON wikidb.* TO wikiuser [at] localhos IDENTIFIED BY 'password to be
used';
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


HTH

Cameron



On Fri, Aug 22, 2008 at 2:46 AM, Steve VanSlyck <s.vanslyck [at] spamcop>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 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
> > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> >
>
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l [at] lists
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


rommel at mi

Aug 22, 2008, 7:03 AM

Post #7 of 9 (2294 views)
Permalink
Re: Migrating to a new server [In reply to]

Señores
Lamentable es que hablo Castellano y No hablo Ingles asi que no puedo entender
los E-mail que e recivido
Saludos
Rommel
Chile
Stgo.


On Fri, 22 Aug 2008 14:56:54 +1200

Cameron <cameronem [at] gmail> wrote:
> 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;
> Exit
> 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
> file!';
> Grant privileges to wikiuser on wikidb database
> Mysql –u root –p
> GRANT ALL ON wikidb.* TO wikiuser [at] localhos IDENTIFIED BY 'password to be
> used';
>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
>
>
> HTH
>
> Cameron
>
>
>
> On Fri, Aug 22, 2008 at 2:46 AM, Steve VanSlyck
><s.vanslyck [at] spamcop>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 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
>> > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>> >
>>
>>
>> _______________________________________________
>> MediaWiki-l mailing list
>> MediaWiki-l [at] lists
>> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l [at] lists
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


rob at colorist

Aug 23, 2008, 4:51 PM

Post #8 of 9 (2293 views)
Permalink
Re: Migrating to a new server [In reply to]

On Aug 21, 2008, at 5:18 PM, Katharina Wolkwitz wrote:

> 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...

it was indeed. I've migrated my wiki to a new OS and server
successfully, though
there are a few extensions I may have to tweak.

thanks for the pointer Katharina.
Rob
--
Rob Lingelbach
rob [at] colorist http://www.colorist.org/robhome.html




_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


Platonides at gmail

Aug 27, 2008, 3:37 PM

Post #9 of 9 (2223 views)
Permalink
Re: Migrating to a new server [In reply to]

claudio von muhlenbrock pinto escribió:
> Señores
> Lamentable es que hablo Castellano y No hablo Ingles asi que no puedo entender
> los E-mail que e recivido
> Saludos
> Rommel
> Chile
> Stgo.

En tal caso seguramente te interesa desuscribirte de esta lista de correo.
Ve a https://lists.wikimedia.org/mailman/listinfo/mediawiki-l introduce
tu email en el último recuadro y dale a 'Unsubscribe or edit options'.
En la siguiente pantalla das a Unsubscribe y te llegará un email con un
enlace para darte de baja.


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Wikipedia mediawiki RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.