Tech:Moving a wiki to another database server

This page provides guidance if you need to move a wiki to another database server (typically relates to disk space issues/imbalances).

Moving a wiki to another database is not complicated provided you have the required rights (SRE, root on the db servers).


 * 1) Put the wiki you are moving into read-only mode (add a read-only notice if you'd like, especially if it is a large wiki, and it will take time).
 * 2) * Example: https://github.com/miraheze/mw-config/commit/497e5608d95ba148b81133d5c34ce72a046d9c43
 * 3) Connect to the server on which the database is located and as root execute:
 * Replace "nameofwiki" with the name of the wiki you want to move.
 * 1) Open the target server and unzip the file.
 * 2) Execute creation of the new database.
 * 3) Import the database.
 * 4) Change   in.
 * 5) Remove read-only mode from the wiki.
 * 6) After  you have made sure  that the wiki works on the new database server and that it has been imported correctly, you can drop the database on the initial server.
 * 1) Change   in.
 * 2) Remove read-only mode from the wiki.
 * 3) After  you have made sure  that the wiki works on the new database server and that it has been imported correctly, you can drop the database on the initial server.
 * 1) After  you have made sure  that the wiki works on the new database server and that it has been imported correctly, you can drop the database on the initial server.