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
subdirectory)
--
Brian
On Monday, July 13, 2020, Pascal GREGIS <grapos(a)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