Revision as of 17:15, 23 April 2025

Important Tables

actor
catrgory
categorylinks
content
externallinks
job
page
pagelinks
recentchanges
revision
revision_comment_temp
text
updatelog
user
watchlist

@@ Line 1: / Line 1: @@
-=== Update database by installer ===
+= Important Tables =
-# Backup old database.
-# Install the latest LTS version.
-# Apply original database settings.
-# Press continue to upgrade database by installer.
-=== Update database by maintenance tool (for SQLite) ===
+<pre>
-# Backup old wiki.
+actor
-# Install the latest LTS version.
+catrgory
-# Generate a new '''LocalSettings.php'''.
+categorylinks
-# Move SQLite file to the path of database.
+content
-# Run '''php maintenance/update.php'''.
+externallinks
+job
-=== Trouble shooting ===
+page
-If a new primary key or unique key was defined in new version.
+pagelinks
+recentchanges
-The SQL command '''INSERT INTO ... SELECT ...''' might be failed.
+revision
+revision_comment_temp
-At that time, the table cannot be migrate by updating tool.
+text
+updatelog
-# Export data of this table as SQL format.
+user
-# Run '''php maintenance/update.php'''.
+watchlist
-# Import data manually.
+</pre>
-=== 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