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