Topic on Project:Support desk

I have faced problems to load my mediawiki with mysql server , so i have removed mysql server and installed new mysql server. And i have lost my data and i don't have any backup files. Now my mediawiki showing blank page. Can you please let me know how to solve my problem.

Are you saying that you deleted your Wiki's MySQL database?

If your Wiki is public on the internet, can you provide a link to it?

The below errors are been displaced when i have run my wiki:

[b0613efb8b238ef5680cd55a] /mediawiki/mediawiki-1.31.0/ InvalidArgumentException from line 536 of /var/lib/mediawiki/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php: Wikimedia\Rdbms\Database::getClass no viable database extension found for type 'mysql'

Backtrace:

#0 /var/lib/mediawiki/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php(482): Wikimedia\Rdbms\Database::getClass(string, NULL)

#1 /var/lib/mediawiki/mediawiki-1.31.0/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1013): Wikimedia\Rdbms\Database::attributesFromType(string, NULL)

#2 /var/lib/mediawiki/mediawiki-1.31.0/includes/libs/rdbms/loadbalancer/LoadBalancer.php(697): Wikimedia\Rdbms\LoadBalancer->getServerAttributes(integer)

#3 /var/lib/mediawiki/mediawiki-1.31.0/includes/objectcache/SqlBagOStuff.php(184): Wikimedia\Rdbms\LoadBalancer->getConnection(integer, array, boolean, integer)

#4 /var/lib/mediawiki/mediawiki-1.31.0/includes/objectcache/SqlBagOStuff.php(267): SqlBagOStuff->getDB(integer)

#5 /var/lib/mediawiki/mediawiki-1.31.0/includes/objectcache/SqlBagOStuff.php(245): SqlBagOStuff->getMulti(array)

#6 /var/lib/mediawiki/mediawiki-1.31.0/includes/objectcache/SqlBagOStuff.php(241): SqlBagOStuff->getWithToken(string, NULL, integer)

#7 /var/lib/mediawiki/mediawiki-1.31.0/includes/libs/objectcache/CachedBagOStuff.php(56): SqlBagOStuff->doGet(string, integer)

#8 /var/lib/mediawiki/mediawiki-1.31.0/includes/libs/objectcache/BagOStuff.php(185): CachedBagOStuff->doGet(string, integer)

#9 /var/lib/mediawiki/mediawiki-1.31.0/includes/session/SessionManager.php(939): BagOStuff->get(string)

#10 /var/lib/mediawiki/mediawiki-1.31.0/includes/session/SessionInfo.php(150): MediaWiki\Session\SessionManager->generateSessionId()

#11 /var/lib/mediawiki/mediawiki-1.31.0/includes/session/SessionProvider.php(172): MediaWiki\Session\SessionInfo->__construct(integer, array)

#12 /var/lib/mediawiki/mediawiki-1.31.0/includes/session/SessionManager.php(270): MediaWiki\Session\SessionProvider->newSessionInfo(NULL)

#13 /var/lib/mediawiki/mediawiki-1.31.0/includes/session/SessionManager.php(244): MediaWiki\Session\SessionManager->getEmptySessionInternal(WebRequest)

#14 /var/lib/mediawiki/mediawiki-1.31.0/includes/session/SessionManager.php(194): MediaWiki\Session\SessionManager->getEmptySession(WebRequest)

#15 /var/lib/mediawiki/mediawiki-1.31.0/includes/WebRequest.php(736): MediaWiki\Session\SessionManager->getSessionForRequest(WebRequest)

#16 /var/lib/mediawiki/mediawiki-1.31.0/includes/session/SessionManager.php(130): WebRequest->getSession()

#17 /var/lib/mediawiki/mediawiki-1.31.0/includes/Setup.php(847): MediaWiki\Session\SessionManager::getGlobalSession()

#18 /var/lib/mediawiki/mediawiki-1.31.0/includes/WebStart.php(88): require_once(string)

#19 /var/lib/mediawiki/mediawiki-1.31.0/index.php(39): require(string)

#20 {main}

please help me out how to fix this problem

If you deleted and purged the data files of the MySQL server, I’m afraid it is lost, except if you find some backup.

Given the error, I guess you upgraded the wiki recently, and either you are on a very old server either you have a very customised configuration parameter $wgServers.

Hello Seb35,

Thank you for your response.

Can you let me know what steps to be taken for solving this issue.

Do you really have the database with data inside? You said previously you deleted the database. What did you exactly when you "delete" the database?

How re-installed you the database?

What are the following configuration parameters in LocalSettings.php:

• $wgDBtype,
• $wgDBserver,
• $wgDBservers ?

What are the version of your MySQL server and PHP ?

I don‘t have mysql data in my system. But i have all the files of mediawiki that i have installed in /var/www/html/mediawiki.

In Localsettings.php i have the following below:

$wgDBtype : "mysql“ $wgDBserver : "localhost“

Currently i am using the version of Mysql - 5.7 and php - 7.2

Hello AhmadF.Cheema,

Thank you for your response. I am sorry my wikii is not available on the internet. It is of local community one.

i have resolved the errors that i have posted above.

But now when i open my mediawiki it is showing

Sorry! This site is experiencing technical difficulties.

Try waiting a few minutes and reloading.

(Cannot access the database)

---

You can try searching via Google in the meantime.

Note that their indexes of our content may be out of date.

can you help me out in this.

> Wikimedia\Rdbms\Database::getClass no viable database extension found for type 'mysql'

This sounds like MySQL is not installed properly. At least I guess that the system currently cannot use it.

Apart from that: If you do not have a backup of the database, then I don't see a way of how to restore the wiki.

Maybe you can create a dump of the database from inside the old MySQL server. You could then restore this dump into the new server.

Thank you for your response.

Can you please let me know how can i create a dump of this database from inside the old mysql server and restore this in to the new server.

See Manual:Backing up a wiki#Database and Manual:Restoring a wiki from backup#Import the database backup

Hello Malyacko,

Thank you for your response.

I want to completely remove the mediawiki from my server and I want to install a new wiki again. I tried to install a new wiki but when i am opening in the browser its not working ( I mean it is not displaying anything ).

Can you please say me how can i remove complete mediawiki that i have in my Server, the old one and what ever files that are linked to mediawiki. And I want to remove my apache2, php7.2, mysql, mariadb Softwares too.

See Manual:Uninstallation