Migration tips

From Fundamental Ramen
Revision as of 12:40, 19 February 2019 by Tacoball (talk | contribs)
Jump to navigation Jump to search

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.

  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.
Retrieved from "https://wiki.fundamental-ramen.com/index.php?title=Migration_tips&oldid=374"