Hi I did the following steps to test the mediawiki backup and restore process. But I cannot fully restored the mediawiki, some template lost and some articles lost too.
The steps I did are as following,
1. I dump the database. mysqldump -u root -p --single-transaction chpwikidb > backup.sql
2. Then I ftp the backup.sql in the BINARY mode from server A to server B
3. Create a database with the same name 'chpwikidb' on server B.
$ mysql -u root -p Enter root password: ****
mysql> create database chpwikidb; mysql> use chpwikidb;
4. Import 'chpwikidb' from A on B by executing the dumped sql script, make sure it is located in the current directory.
mysql> source backup.sql;
5. Install MediaWiki as usual, but change the database's name from the default 'wikidb' to 'chpwikidb' 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!!
But Finally, the new mediawiki I restored on server B does not have all the info of the mediawiki on Server A
Would you pls kindly let me know what I did wrong.
Thanks jc
__________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com
judi chen wrote:
- Install MediaWiki as usual, but change the
database's name from the default 'wikidb' to 'chpwikidb' 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!!
But Finally, the new mediawiki I restored on server B does not have all the info of the mediawiki on Server A
Would you pls kindly let me know what I did wrong.
First, you didn't say what was wrong. "does not have all the info" doesn't tell us anything specific.
Second, you didn't say if you have any customizations or custom configurations. These may very likely make a difference.
Copy your old LocalSettings.php and fix up the paths to be correct. Check for differences between the prior and the new one.
-- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org