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
Message: 9
Date: Fri, 11 Nov 2005 19:41:32 +0000
From: Rob Church <robchur(a)gmail.com>
Subject: Re: [Mediawiki-l] moving database from server
A to server B
To: MediaWiki announcements and site admin list
<mediawiki-l(a)wikimedia.org>
Message-ID:
<e92136380511111141j14c46f65y(a)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(a)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(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l