[Mediawiki-l] moving database from server A to server B

[judi chen]

Hi Rob,

Here are the steps I followed,

1. dump db by using
mysqldump -u root -p --single-transaction mywikidb >
backup.sql

2. ftp the backup.sql over to box B with bin

3.  Create a database with the same name 'mywikidb' on
B.

 $ mysql -u root -p
  Enter root password: ****

  mysql> create database mywikidb;
  mysql> use mywikidb;

4. import database
mysql> source backup.sql;

5. Install MediaWiki as usual, but change the
database's name from the default 'wikidb' to
'mywikidb' MediaWiki will detect there is a
pre-existing database and try to upgrade it when
necessary.

Also, the language setting MUST be the same as the
original one!!


Pls help.
Thanks
jc


Message: 9
Date: Fri, 11 Nov 2005 19:41:32 +0000
From: Rob Church <robchur at gmail.com>
Subject: Re: [Mediawiki-l] moving database from server
A to server B
To: MediaWiki announcements and site admin list
	<mediawiki-l at wikimedia.org>
Message-ID:
<e92136380511111141j14c46f65y at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

That page is rather fragmented in terms of "steps" -
can you outline
more or less what you actually did, so we can spot
where the problem
lies?


Rob Church

On 10/11/05, judi chen <judi_chen at yahoo.com> wrote:
> Hi All,
> Thanks for all the previous help.
>
> I am running mediawiki 1.5.2 on Fedora Core 4.
>
> I followed the instructions from the following
article
>
> at meta.wikimedia.com to move/restore database.
>
> How to move a MediaWiki Database
>
> It looks OK at begining. But then I found that a lot
> of infomation has been lost during the restore
> process, such as articles and template.
>
> Any suggestions
>
> thanks again
> jc


		
__________________________________ 
Start your day with Yahoo! - Make it your home page! 
http://www.yahoo.com/r/hs