RestoreInstructions

From PLplotWiki

Restore file backup

Unzip the file backup into a directory.

Restore database

• On the server, create a new mySQL database.
• Create also a user, and grant that user permissions on the database. SELECT, INSERT, UPDATE and DELETE permissions should suffice.
• Import the database backup into the new database.

Check the configuration file

The final, real task is to tweak the LocalSettings.php file. Certain entries in this will almost undoubtedly require changing, and you may need to change the database connection information as well.

Check the following configuration options:

$IP	Needs to be correct for the paths on the new server
$wgScriptPath	Needs to be correct for the path on the new server
$wgDBserver	Check the database server name is correct
$wgDBname	This might have changed in a shared hosting environment
$wgDBuser	This might have changed in a shared hosting environment
$wgDBpassword	Check this is correct for the new user

These instructions are taken from http://meta.wikimedia.org/wiki/How_to_move_a_MediaWiki_Database