Mediawiki references and how tos

- 2017-07-26 Wednesday -

Ted having trouble restoring a Mediawiki 1.19.2 database dump to a back-up server, where Mediawiki ___ version is installed. Not sure whether updating the database schema on the newer versioned back-up server will work. Here is a Mediawiki reference to an update script which is part of this open source wiki project:

  *  https://www.mediawiki.org/wiki/Manual:Update.php

Detailed version information, original wiki to back up and restore on left column, and target back-up server component versions right column:

Product Version MediaWiki 1.19.2 PHP 5.3.5-1ubuntu7.11 (apache2handler) MySQL 5.1.54-1ubuntu4

Example Output Of Mediawiki Update PHP Script

veris@alta-spare-2u:/var/www/html/alta-wiki/maintenance$ sudo ./update.php 
[sudo] password for veris: 
MediaWiki 1.28.0 Updater

Your composer.lock file is up to date with current dependencies!
Going to run database updates for alta_wiki
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0
Turning off Content Handler DB fields for this part of upgrade.
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...already have interwiki table
...indexes seem up to 20031107 standards.
...have rc_type field in recentchanges table.
...index new_name_timestamp already set on recentchanges table.
...have user_real_name field in user table.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...have pagelinks; skipping old links table updates
...il_from OK
...have rc_ip field in recentchanges table.
...index PRIMARY already set on image table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...logging table already exists.
...have user_token field in user table.
...have wl_notificationtimestamp field in watchlist table.
...watchlist talk page rows already present.
...user table does not contain user_emailauthenticationtimestamp field.
...page table already exists.
...have log_params field in logging table.
...logging table has correct log_title encoding.
...have ar_rev_id field in archive table.
...have page_len field in page table.
...revision table does not contain inverse_timestamp field.
...have rev_text_id field in revision table.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have user_email_token field in user table.
...have ar_text_id field in archive table.
...page_namespace is already a full int (int(11)).
...ar_namespace is already a full int (int(11)).
...rc_namespace is already a full int (int(11)).
...wl_namespace is already a full int (int(11)).
...qc_namespace is already a full int (int(11)).
...log_namespace is already a full int (int(11)).
...have img_media_type field in image table.
...already have pagelinks table.
...image table does not contain img_type field.
...already have unique user_name index.
...user_groups table exists and is in current format.
...have ss_total_pages field in site_stats table.
...user_newtalk table already exists.
...transcache table already exists.
...have iw_trans field in interwiki table.
...wl_notificationtimestamp is already nullable.
...index times already set on logging table.
...have ipb_range_start field in ipblocks table.
...no page_random rows needed to be set
...have user_registration field in user table.
...templatelinks table already exists
...externallinks table already exists.
...job table already exists.
...have ss_images field in site_stats table.
...langlinks table already exists.
...querycache_info table already exists.
...filearchive table already exists.
...have ipb_anon_only field in ipblocks table.
...index rc_ns_usertext already set on recentchanges table.
...index rc_user_text already set on recentchanges table.
...have user_newpass_time field in user table.
...redirect table already exists.
...querycachetwo table already exists.
...have ipb_enable_autoblock field in ipblocks table.
...index pl_namespace on table pagelinks includes field pl_from.
...index tl_namespace on table templatelinks includes field tl_from.
...index il_to on table imagelinks includes field il_from.
...have rc_old_len field in recentchanges table.
...have user_editcount field in user table.
...page_restrictions table already exists.
...have log_id field in logging table.
...have rev_parent_id field in revision table.
...have pr_id field in page_restrictions table.
...have rev_len field in revision table.
...have rc_deleted field in recentchanges table.
...have log_deleted field in logging table.
...have ar_deleted field in archive table.
...have ipb_deleted field in ipblocks table.
...have fa_deleted field in filearchive table.
...have ar_len field in archive table.
...have ipb_block_email field in ipblocks table.
...index cl_sortkey on table categorylinks includes field cl_from.
...have oi_metadata field in oldimage table.
...index usertext_timestamp already set on archive table.
...index img_usertext_timestamp already set on image table.
...index oi_usertext_timestamp already set on oldimage table.
...have ar_page_id field in archive table.
...have img_sha1 field in image table.
...protected_titles table already exists.
...have ipb_by_text field in ipblocks table.
...page_props table already exists.
...updatelog table already exists.
...category table already exists.
...category table already populated.
...have ar_parent_id field in archive table.
...have user_last_timestamp field in user_newtalk table.
...protected_titles table has correct pt_title encoding.
...have ss_active_users field in site_stats table.
...ss_active_users user count set...
...have ipb_allow_usertalk field in ipblocks table.
...change_tag table already exists.
...tag_summary table already exists.
...valid_tag table already exists.
...user_properties table already exists.
...log_search table already exists.
...have log_user_text field in logging table.
...l10n_cache table already exists.
...index ls_field_val already set on log_search table.
...index change_tag_rc_tag already set on change_tag table.
...have rd_interwiki field in redirect table.
...transcache tc_time already converted.
...*_mime_minor fields are already long enough.
...iwlinks table already exists.
...index iwl_prefix_title_from already set on iwlinks table.
...have ul_value field in updatelog table.
...have iw_api field in interwiki table.
...iwl_prefix key doesn't exist.
...have cl_collation field in categorylinks table.
...categorylinks up-to-date.
...module_deps table already exists.
...ar_page_revid key doesn't exist.
...index ar_revid already set on archive table.
...ll_lang is up-to-date.
...user_last_timestamp is already nullable.
...index user_email already set on user table.
...up_property in table user_properties already modified by patch patch-up_property.sql.
...uploadstash table already exists.
...user_former_groups table already exists.
...index type_action already set on logging table.
...have rev_sha1 field in revision table.
...batch conversion of user_options: nothing to migrate. done.
...user table does not contain user_options field.
...have ar_sha1 field in archive table.
...index page_redirect_namespace_len already set on page table.
...have us_chunk_inx field in uploadstash table.
...have job_timestamp field in job table.
Adding index page_user_timestamp to table revision ...done.
Adding ipb_parent_block_id field to table ipblocks ...done.
Adding index ipb_parent_block_id to table ipblocks ...done.
Table category contains cat_hidden field. Dropping ...done.
Adding rev_content_format field to table revision ...done.
Adding rev_content_model field to table revision ...done.
Adding ar_content_format field to table archive ...done.
Adding ar_content_model field to table archive ...done.
Adding page_content_model field to table page ...done.
Content Handler DB fields should be usable now.
Table site_stats contains ss_admins field. Dropping ...done.
Table recentchanges contains rc_moved_to_title field. Dropping ...done.
...sites table already exists.
Adding fa_sha1 field to table filearchive ...done.
Adding job_token field to table job ...done.
Adding job_attempts field to table job ...done.
Adding us_props field to table uploadstash ...done.
Modifying ug_group field of table user_groups ...done.
Modifying ufg_group field of table user_former_groups ...done.
Adding index pp_propname_page to table page_props ...done.
Adding index img_media_mime to table image ...done.
Making iwl_prefix_title_from index non-UNIQUE ...done.
Adding index iwl_prefix_from_title to table iwlinks ...done.
Adding ar_id field to table archive ...done.
Adding el_id field to table externallinks ...done.
Adding rc_source field to table recentchanges ...done.
Adding index log_user_text_type_time to table logging ...done.
Adding index log_user_text_time to table logging ...done.
Adding page_links_updated field to table page ...done.
Adding user_password_expires field to table user ...done.
Adding pp_sortkey field to table page_props ...done.
Table recentchanges contains rc_cur_time field. Dropping ...done.
Adding index wl_user_notificationtimestamp to table watchlist ...done.
Adding page_lang field to table page ...done.
Adding pl_from_namespace field to table pagelinks ...done.
Adding tl_from_namespace field to table templatelinks ...done.
Adding il_from_namespace field to table imagelinks ...done.
Modifying img_major_mime field of table image ...done.
Modifying oi_major_mime field of table oldimage ...done.
Modifying fa_major_mime field of table filearchive ...done.
Making user_id unsigned int ...done.
Modifying rc_comment field of table recentchanges ...done.
Dropping table hitcounter ...done.
Table site_stats contains ss_total_views field. Dropping ...done.
Table page contains page_counter field. Dropping ...done.
Dropping table msg_resource_links ...done.
Dropping table msg_resource ...done.
...bot_passwords table already exists.
Adding wl_id field to table watchlist ...done.
Dropping cl_collation index from table categorylinks ...done.
Adding index cl_collation_ext to table categorylinks ...done.
...collations up-to-date.
Adding index rc_name_type_patrolled_timestamp to table recentchanges ...done.
...rev_page_id index not found on revision.
Making pl_namespace, tl_namespace and il_to indices non-UNIQUE ...done.
Adding ct_id field to table change_tag ...done.
Adding ts_id field to table tag_summary ...done.
Modifying rc_ip field of table recentchanges ...done.
...site_stats is populated...done.
Populating rev_len column
...doing rev_id from 1 to 200
...doing rev_id from 201 to 400
...doing rev_id from 401 to 600
...doing rev_id from 601 to 800
...doing rev_id from 801 to 1000
...doing rev_id from 1001 to 1200
...doing rev_id from 1201 to 1400
...doing rev_id from 1401 to 1600
...doing rev_id from 1601 to 1800
...doing rev_id from 1801 to 2000
...doing rev_id from 2001 to 2200
...doing rev_id from 2201 to 2400
...doing rev_id from 2401 to 2600
...doing rev_id from 2601 to 2800
...doing rev_id from 2801 to 3000
...doing rev_id from 3001 to 3200
...doing rev_id from 3201 to 3400
...doing rev_id from 3401 to 3600
...doing rev_id from 3601 to 3800
...doing rev_id from 3801 to 4000
...doing rev_id from 4001 to 4200
...doing rev_id from 4201 to 4400
...doing rev_id from 4401 to 4600
...doing rev_id from 4601 to 4800
...doing rev_id from 4801 to 5000
...doing rev_id from 5001 to 5200
...doing rev_id from 5201 to 5400
...doing rev_id from 5401 to 5600
...doing rev_id from 5601 to 5800
...doing rev_id from 5801 to 6000
...doing rev_id from 6001 to 6200
...doing rev_id from 6201 to 6400
...doing rev_id from 6401 to 6600
...doing rev_id from 6601 to 6800
...doing rev_id from 6801 to 7000
...doing rev_id from 7001 to 7200
...doing rev_id from 7201 to 7400
...doing rev_id from 7401 to 7600
...doing rev_id from 7601 to 7800
...doing rev_id from 7801 to 8000
...doing rev_id from 8001 to 8200
...doing rev_id from 8201 to 8400
...doing rev_id from 8401 to 8600
...doing rev_id from 8601 to 8800
...doing rev_id from 8801 to 9000
Populating ar_len column
...doing ar_id from 1 to 200
...doing ar_id from 201 to 400
...doing ar_id from 401 to 600
...doing ar_id from 601 to 800
...doing ar_id from 801 to 1000
...doing ar_id from 1001 to 1200
...doing ar_id from 1201 to 1400
...doing ar_id from 1401 to 1600
rev_len and ar_len population complete [7 revision rows, 1573 archive rows].
...Update 'populate rev_sha1' already logged as completed.
Populating img_sha1 field

Done 0 files in 0.0 seconds
...protocol-relative URLs in externallinks table already fixed.
Populating fa_sha1 field from fa_storage_key

Done 40 files in 0.1 seconds
Updating *_from_namespace fields in links tables.
...doing page_id from 1 to 200
...doing page_id from 200 to 399
...doing page_id from 399 to 598
...doing page_id from 598 to 797
...doing page_id from 797 to 996
...doing page_id from 996 to 1195
...doing page_id from 1195 to 1394
...doing page_id from 1394 to 1593
...doing page_id from 1593 to 1792
...doing page_id from 1792 to 1991
...doing page_id from 1991 to 2190
...doing page_id from 2190 to 2389
...doing page_id from 2389 to 2588
...doing page_id from 2588 to 2787
Adding empty categories with description pages...
--mode=both --begin=Testing
Removing empty categories without description pages...
--mode=remove --begin=Testsets
Category cleanup complete.
Set the local repo temp zone container to be private.
Purging caches...done.

Done in 24 s.
veris@alta-spare-2u:/var/www/html/alta-wiki/maintenance$