Migration tips: Difference between revisions

From Fundamental Ramen
Jump to navigation Jump to search
No edit summary
No edit summary
 
(4 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
revision_comment_temp
text
updatelog
user
watchlist
</pre>

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