0

I'm trying to install MediaWiki (1.29.1 or 1.27.3) locally with a large Wiktionary dump (3GB). After converting the xml dump into an sql file and importing the latter into my DB that I create with this script, I followed the MediaWiki installation instructions in the browser to generate my specific "LocalSettings.php". I get the message

There are MediaWiki tables in this database. To upgrade them to MediaWiki 1.29.1, click Continue."

By clicking the "continue" button, the browser stays in loading state forever.

My understanding is that my DB containing the wiktionary dump has some tables that are not compatible with the version of wikimedia that I'm using. Therefore, an update of the DB is required. I tried to run install.php from the command line to avoid having timeout with the browser. The command didn't return anything (after waiting more than 2 hours).

I tried as well a workaround:

  • Create my DB with empty Tables

  • Generate "LocalSettings.php" from the browser (that was fast since the DB is small)

  • Import the wiki sql dump to my DB

  • Refresh the index.php page

I got then a blank page with this message

Exception caught inside exception handler.Set $wgShowExceptionDetails = true; and $wgShowDBErrorBacktrace = true; at the bottom of LocalSettings.php to show detailed debugging information.

All the examples and tutorials that I found online about this matter are assuming/using a small or new created DB.

Any idea what's wrong? Did really someone tried to use an existing wikimedia dump and run it locally? Why is there no such an advanced example?

user3621950
  • 25
  • 6

2 Answers2

1

You wrote "I'm trying to install Wikimedia (1.29.1 or 1.27.3)". I suppose that you are talking about Mediawiki, not Wikimedia. Am I right?

1) You can try parsed version of Wiktionary. It is a little bit old (2014) http://whinger.krc.karelia.ru/soft/wikokit/index.html

2) You can try to use my tutorial about download Wiktionary dump, uploading to MySQL, converting and parsing to something more usefull for work: Getting started Wiktionary parser.

See: MySQL import

Andrew Krizhanovsky
  • 610
  • 7
  • 11
  • Yes, I meant MediaWiki (sorry for that confusion). Thanks for the pointers but I have a specific use case where I want just to run Wiktionary locally to make some automatic queries from its GUI. I'll describe below my solution for this issue – user3621950 Nov 13 '17 at 16:54
1

The issue in a first level originates from mwdumper which seems to be outdated. An sql DB I generated using mwdumper is missing some tables which should have been though created by running update.php. It was not possible for me to run any php file neither from shell nor from the browser and I suspect the size of the dump to be the cause.

The workaround which by some magic helped to overcome this issue was:

  1. run the update.php from shell with missing db credentials. This somehow enables logs and make the execution of index.php possible through the browser
  2. add manually to the missing table columns claimed in the error messages (the column types here should be respected)
  3. place a LocalSettings.php file, generated easily from a Wiktionary DB with empty tables, in the right directory of the mediawiki installation.
  4. Run index.php from the browser

Et voila! The huge wiktionary mysql dump is queryable now throw the mediawiki interface. Not sure if such a trick could be called a solution but it solved the problem in my case. An explanation for what could have happened in background would be definitely helpful.

user3621950
  • 25
  • 6