Migration tips: Difference between revisions

From Fundamental Ramen
Jump to navigation Jump to search
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
=== Update database by installer ===
= Create Docker Image =
# Backup old database.
# Install the latest LTS version.
# Apply original database settings.
# Press continue to upgrade database by installer.


=== Update database by maintenance tool ===
= Important Tables =
# 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 ===
<pre>
If a new primary key or unique key was defined in new version.
actor
 
catrgory
The SQL command '''INSERT INTO ... SELECT ...''' might be failed.
categorylinks
 
content
At that time, the table cannot be migrate by updating tool.
externallinks
 
job
# Export data of this table as SQL format.
page
# Run '''php maintenance/update.php'''.
pagelinks
# Import data manually.
recentchanges
 
revision
=== Using Docker ===
revision_comment_temp
It's easy to maintain requirements of MediaWiki by docker.
text
 
updatelog
It's better to place some files and directories in volumes like:
user
 
watchlist
* LocalSettings.php
</pre>
* mywiki.sqlite
* images directory
* custom extensions
* php error log
* php-fpm error log
* nginx error log
* nginx access log

Latest revision as of 17:15, 23 April 2025

Create Docker Image

Important Tables

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