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@yahoo.com Subject: [Mediawiki-l] moving database from server A to server B To: mediawiki-l@Wikimedia.org Message-ID: 20051112002324.39906.qmail@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@gmail.com Subject: Re: [Mediawiki-l] moving database from server A to server B To: MediaWiki announcements and site admin list mediawiki-l@wikimedia.org Message-ID: e92136380511111141j14c46f65y@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@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@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@Wikimedia.org Message-ID: 43753C40.2090004@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,
- dump db by using
mysqldump -u root -p --single-transaction mywikidb > backup.sql
ftp the backup.sql over to box B with bin
Create a database with the same name 'mywikidb'
on
B.
$ mysql -u root -p Enter root password: ****
mysql> create database mywikidb; mysql> use mywikidb;
- import database
mysql> source backup.sql;
- 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