I tried playing with $wgDBTableOptions but it didn't help.
Is there a way to import images into mediawiki and preserve existing file
links to those images? e.g., restore all content--both text & images.
Best Regards,
Krishna
--------------------------------------------------------------------------------
Krishna Maheshwari
kmaheshwari(a)mba2007.hbs.edu
kkm9(a)cornell.edu
Hindupedia, the Hindu Encyclopedia (
)
--------------------------------------------------------------------------------
On Fri, Nov 20, 2015 at 1:45 PM, kkm <kkm5848(a)gmail.com> wrote:
I downloaded MySQL Workbench and started looking at
the tables using this
tool instead of the CLI.
It looks like the article titles in the page table themselves aren't
stored properly...yet they are presented properly in mediawiki....anyone
know what is going on?
BTW, if I dump the mediawiki articles and than import the dump, the
articles w/ titles that require UTF8 are added to the mediawiki w/ correct
UTF8 characters in the db...
Do I need to go back and manually delete all the articles w/ the messed up
titles or is there a way to fix this? Or better yet, is there a way to fix
the tables since the correct encoding is available somewhere...
Best Regards,
Krishna
--------------------------------------------------------------------------------
Krishna Maheshwari
kmaheshwari(a)mba2007.hbs.edu
kkm9(a)cornell.edu
Hindupedia, the Hindu Encyclopedia (
www.hindupedia.com)
--------------------------------------------------------------------------------
On Thu, Nov 19, 2015 at 9:27 PM, kkm <kkm5848(a)gmail.com> wrote:
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