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
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 _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l