Migration tips: Difference between revisions

Revision as of 12:40, 19 February 2019

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.

@@ Line 1: / Line 1: @@
 === Update database by installer. ===
+# Backup old database.
+# Install the latest LTS version.
+# Apply original database settings.
+# Press continue to upgrade database by installer.
 === Update database by maintenance tool. ===
+# Backup old wiki.
+# Install the latest LTS version.
+# Generate a new '''LocalSettings.php'''.
+# Move SQLite file to the path of database.
+# 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.
+# Export data of this table as SQL format.
+# Run '''php maintenance/update.php'''.
+# Import data manually.