My php settings didn't get through, so trying to resent.
--------------------------------------------------------------------------------
<kkm9(a)cornell.edu>
Hindupedia, the Hindu Encyclopedia (
www.hindupedia.com)
--------------------------------------------------------------------------------
---------- Forwarded message ----------
From: kkm <kkm5848(a)gmail.com>
Date: Wed, Nov 18, 2015 at 9:45 PM
Subject: Re: problem following 1.16 to 1.25 conversion
To: mediawiki-l(a)lists.wikimedia.org
Hi,
My mysql settings as shown with the \s flag.
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- ----------------------------------------
auto-rehash TRUE
auto-vertical-output FALSE
character-sets-dir (No default value)
column-type-info FALSE
comments FALSE
compress FALSE
debug-check FALSE
debug-info FALSE
database (No default value)
default-character-set auto
delimiter ;
enable-cleartext-plugin FALSE
vertical FALSE
force FALSE
named-commands FALSE
ignore-spaces FALSE
init-command (No default value)
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 3306
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket /var/run/mysqld/mysqld.sock
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-verify-server-cert FALSE
table FALSE
user root
safe-updates FALSE
i-am-a-dummy FALSE
connect-timeout 0
max-allowed-packet 16777216
net-buffer-length 16384
select-limit 1000
max-join-size 1000000
secure-auth FALSE
show-warnings FALSE
plugin-dir (No default value)
default-auth (No default value)
My original mysql version (prior to the physical server migration) was:
*>SHOW VARIABLES LIKE "%version%";*
+-------------------------+------------------+
| Variable_name | Value |
+-------------------------+------------------+
| innodb_version | 5.5.44 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.44-0+deb8u1 |
| version_comment | (Debian) |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+------------------+
However, the current version of mysql is
+-------------------------+------------------+
| Variable_name | Value |
+-------------------------+------------------+
| innodb_version | 5.5.46 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.46-0+deb8u1 |
| version_comment | (Debian) |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+------------------+
This version is currently hosting v.1.16.5 of Hindupedia. The upgraded
mediawiki would remain on this version of mysql.
An alternate approach would be to dump the mediawiki contents (using the
dumpBackup.php maintenance script and to import them using
importDump.php). However, I haven't found a way to backup & restore the
images in such a way that the image links within the wiki still work (just
importing them by using importImages.php imported the images but didn't
restore the links to the images in the articles).
Krishna