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

Sat Nov 12 17:46:30 UTC 2005

Hi all
thanks

I use the binary mode to ftp the file from one server
to another server.

I did exactly steps as I described.

Can someone give me the detailed steps that I should
follow including the query.
Thanks
jc

Message: 3
Date: Fri, 11 Nov 2005 16:23:24 -0800 (PST)
From: judi chen <judi_chen at yahoo.com>
Subject: [Mediawiki-l] moving database from server A
to server B
To: mediawiki-l at Wikimedia.org
Message-ID:
<20051112002324.39906.qmail at web52307.mail.yahoo.com>
Content-Type: text/plain; charset=iso-8859-1

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

------------------------------

Message: 4
Date: Sat, 12 Nov 2005 00:50:08 +0000
From: Vinayak Nagaraj <v.nagaraj at econwiki.lse.ac.uk>
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: <43753C40.2090004 at econwiki.lse.ac.uk>
Content-Type: text/plain; charset=ISO-8859-1;
format=flowed

Stupid question, but did you use the right mode when
FTPing?

I do this pretty often as we're constantly moving to
different servers. 
What I do is get PhpMyAdmin to export the database
into an SQL query, 
and then just copy and paste that query into the
PhpMyadmin in the new 
server and execute. It creates the database for you,
and everything. 
The 
important rule (I think) is that the directory
structure etc needs to 
be 
kept the same... and it works like a charm. The new
installation picks 
it up and upgrades the database (if I'm upgrading
version etc).

Vinayak

judi chen wrote:
> 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
>

__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com