[MediaWiki-l] Restoring a mediawiki site

Brian Wolff bawolff at gmail.com
Thu Jul 30 03:52:43 UTC 2020

It sounds like there was some error during the import process, and your db
wasnt fully imported (at the very least an index was missing). Its also
possible that maybe the export didnt include indicies (i dont know what
phpmyadmin does by default. It might be optional)

If possible i would suggest using the mysql command line client to do the
import, and commandline mysqldump to make the backup.

Additionally dont forget for a complete backup you also need to backup
LocalSettings.php and the images subdirectory (and maybe extensions

On Monday, July 13, 2020, Pascal GREGIS <grapos at free.fr> wrote:

> Hello,
> I have tried to restore one of my wiki sites for testing, because I've
> always learnt that a non-tested backup is a useless backup.
> I have exported my database named pascal_wikidb using phpmyadmin on my
> host site and obtained an sql file.
> Then I have tried to import this sql file on another database (on the same
> host site) named pascal_dbtest. I have had hard time doing it because the
> import function of phpmyadmin doesn't work well with lynx, but that is
> another story. Using Firefox, I managed to do it still with an error
> message (I don't remember this message and I cannot reproduce easily this
> operation); so I wasn't sure my restoration was complete.
> I then imported pascal_dbtest and it sounded complete when looking at the
> sql file, except that there are only 5 "ALTER TABLE" in it, instaed of a
> few dozens in the file exported from pascal_wikidb. Anyway it's hard to
> compare at a manual glance.
> So I changed the LocalSettings.php of my wiki site to have it pointing on
> pascal_dbtest instead of pascal_wikidb :
> $wgDBname = "pascal_dbtest";
> $wgDBuser = "pascal_testwiki";
> $wgDBpassword = "Undiscloed_password"
> I opened my wiki with the normal URL, I managed to log in, but I couldn't
> modify any page, when I try I get :
> "Alert: HTTP/1.1 500 Internal Server Error"
> then  (this is a translation back to english, sorry)
> «
> A database request error occured. It could have been caused by something
> wrong in the software.
> [1cd8b80a4379c26549677281] 2020-07-13 17:30:10: Fatal erreur of type
> "DBQueryError"
> »
> Is there any procedure to follow to restore a wiki installation from a
> database backup?
> Or is it likely to be caused by a corruption in my database backup?
> I precise that I almost eliminated the hypothesis of an error in the
> user's permissions on this database.
> Thanks in advance for any answer
> Regards
> Pascal GRÉGIS
> _______________________________________________
> MediaWiki-l mailing list
> To unsubscribe, go to:
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

More information about the MediaWiki-l mailing list