Migration tips: Difference between revisions

From Fundamental Ramen
Jump to navigation Jump to search
Line 5: Line 5:
# Press continue to upgrade database by installer.
# Press continue to upgrade database by installer.


=== Update database by maintenance tool ===
=== Update database by maintenance tool (for SQLite) ===
# Backup old wiki.
# Backup old wiki.
# Install the latest LTS version.
# Install the latest LTS version.

Revision as of 12:57, 19 February 2019

Update database by installer

  1. Backup old database.
  2. Install the latest LTS version.
  3. Apply original database settings.
  4. Press continue to upgrade database by installer.

Update database by maintenance tool (for SQLite)

  1. Backup old wiki.
  2. Install the latest LTS version.
  3. Generate a new LocalSettings.php.
  4. Move SQLite file to the path of database.
  5. Run php maintenance/update.php.

Trouble shooting

If a new primary key or unique key was defined in new version.

The SQL command INSERT INTO ... SELECT ... might be failed.

At that time, the table cannot be migrate by updating tool.

  1. Export data of this table as SQL format.
  2. Run php maintenance/update.php.
  3. Import data manually.

Using Docker

It's easy to maintain requirements of MediaWiki by docker.

It's better to place some files and directories in volumes like:

  • LocalSettings.php
  • mywiki.sqlite
  • images directory
  • custom extensions
  • php error log
  • php-fpm error log
  • nginx error log
  • nginx access log