Manual:Moving a wiki

This document is about how to move a wiki to another server. This is often needed when moving to a different web server or domain (or both).

Versions and upgrading
The instructions on this page should apply more or less evenly to any given version of MediaWiki. Ensure, prior to moving, that any upgrading of the software and database schema is done. You should only move a database into another MediaWiki installation if they both run the same version. If you need to do both, make sure to upgrade before migrating to a different web server.

File transfer
Unless you have direct access to the server hosting the wiki, (and even then) you will have to choose a method for transferring files:
 * SCP or WinSCP
 * SSH File Transfer Protocol (SFTP)
 * Using a FTP client.
 * Using rsync
 * The hosting company might provide a file manager interface via the web browser, check with your provider.
 * Some other method, there is a list of these at List of file transfer protocols

Overview

 * 1) Back up the database
 * 2) Back up the MediaWiki files
 * 3) Re-create the database, user and permissions
 * 4) Import the database backup
 * 5) Import the MediaWiki files
 * 6) Check the configuration file
 * 7) Test

Backup
To move or copy your wiki, you need to start by making a backup of everything. You should probably copy at least the following:
 * The wiki's database content. See Manual:Backing up a wiki.
 * Images and other media files, i.e. the contents of the images and if modified any files from the skins directory.
 * Favicon and .htaccess files.
 * Configuration files, e.g. LocalSettings.php and (on older wiki's maybe AdminSettings.php as well).
 * The contents of the extensions directory.

Note: Before you start the backup your wiki, you may want to put it under "read-only" mode so that nobody can edit it while you are moving it. If you don't, you might lose edits/uploads/logs etc. that were made during the migration process. To do this, use  in LocalSettings.php. For example: $wgReadOnly = 'Down for maintenance, access will be restored shortly';

Set up the destination database
On the destination server, create a new MySQL database and a user, and grant that user permissions on the database. SELECT, INSERT, UPDATE and DELETE permissions should suffice. You will also need DROP, CREATE and ALTER to import the data base. You may need to consult the MySQL documentation, your hosting provider's control panel documentation, or the documentation of any other utilities you are using for information on how to do this.

Note: The destination database may have a different name, user and/or password. If that is the case, you will only have to update the configuration file on the new server (after you completed the following steps, though).

Import the database backup
The next step is to import the database backup. This will create the tables in the database and populate them with data. Duplicating the database on the other server. Importing takes a variable amount of time, depending upon the number of pages, users, edits, etc. in the wiki.

Possible methods
See Manual:Restoring a wiki from backup for the full details. Possible methods for performing the import include:
 * From the command line using mysql
 * With phpMyAdmin via a web browser (not recommended for large databases due to potential timeout problems that could leave the database only partially imported, and perhaps in an inconsistent state, e.g. with revision metadata imported but not the corresponding revision text)
 * From an xml dump
 * Using BigDump if you don't have command-line access and your MySQL administration tool has an upload size limit that is lower than the size of your database.

Import the MediaWiki files
The final "large" step in the moving process is to upload/copy the MediaWiki files (the "wiki" folder) to the destination server. If you followed the instructions above, and backed up the entire directory, this will include the images and extensions directories, plus custom skins, etc. and the configuration file.

If you backed up only portions of the directory, e.g. images, extensions, etc. then you will need to first upload/copy a fresh install of the MediaWiki files, then transfer the backed-up directories and files into the correct locations in the new filesystem.

Update the configuration file
The final step is to update the LocalSettings.php file. Certain entries in this will almost undoubtedly require changing.

Check the following configuration options:

You might also need to check the paths to diff3, ImageMagick, etc.

Test
At this point, attempt to access the wiki on the new server and use it. Log in as a sysop and a regular user and check that viewing, creating and editing pages and uploading files still works. You will need to fix any problems reported either by PHP or MediaWiki itself.

Frequent problems
After your move you might see PHP warnings stating that certain files could not be accessed. This is most likely caused by 35472: The column md_deps in the module-deps table contains absolute file paths, which are used to locate the images and LESS files that CSS depends on. These paths will break when the wiki is e.g. moved to another folder or to another server.

Until this bug is solved, you can use this workaround to manually fix wrong entries in the module_deps table:

This can be used to update wrong path segments and to fix the error.