Topic on Project:Support desk

Restore MediaWiki when only web part is broken

10
185.46.212.164 (talkcontribs)

Dear Support desk,


We have MediaWiki deployed in IIS and it's DB is running on MariaDB.

Unfortunately the web part is broken and we had to restore web part from a backup. But now we cannot "connect" the web part to the database.

I've also tried to install a new MediaWiki page but I did not find an option to build the web park based on an existing database.


Could you please suggest if it is possible to somehow rebuild the website based on an existing database (MariaDB)?


Best Regards,

Marton

Malyacko (talkcontribs)
185.46.212.164 (talkcontribs)

Hello,


I've just reinstalled the Wiki site and selected the same database but nothing happened. I'm just having an empty mediaWiki site but nothing from the database is getting read. I mean we had hundreds of pages, images, etc. but nothing is available. Also the users which are in the database cannot be used on the website.


Any other idea please?

Malyacko (talkcontribs)

See Manual:How to debug and Manual:Errors and symptoms#You see a Blank Page for the MediaWiki part; also check the error log of the webserver software that you use. Please post relevant database related errors here.

Please also mention your previous MediaWiki version, the current MediaWiki version that you try to make work, and your MariaDB version.

185.46.212.164 (talkcontribs)

Hello,


There's no any error after the installation. It's just a brand new mediawiki site. For example if I click on "Random page" it's just loading the main page, as no other can be found. However in the database there are hundreds of them.


MariaDB version: 10.2.12

Previous MediaWiki version: Unknown, but i'm sure it was 1.27 or newer

Current MediaWiki version: tried with 1.32

Ciencia Al Poder (talkcontribs)

Can you connect to the database and check if the tables are there?

Even if you choose the same database, if your original installation has a different table prefix than your new installation, the installer will create new tables with the different prefix and cause MediaWiki to not find the old tables.

185.46.212.164 (talkcontribs)

Hello,


Yes, I can connect to the database which was dedicated to this site so no prefixes were used. Every data is in the database and I can access them.

Ciencia Al Poder (talkcontribs)

I think that, at this stage, is obvious you're not using the same database server, port number and/or database name when you connect to it through the wiki and when you manually inspect table data

185.46.212.164 (talkcontribs)

Hello,


I've just realized that when I'm selecting the existing database at installation it runs into error when dropping / creating indexes (maintenance\archives\patch-change_tag-indexes.sql file). I've commented out indexing and it successfully ran.


However the result is the same. I've got a new Wiki site with no content.

Malyacko (talkcontribs)

See my previous comment and tell us which exact logs, located where, you checked.

Reply to "Restore MediaWiki when only web part is broken"