Hi,
Tnaks Brian. Unfortunately I don't have access to the server, only via http and ftp. So I guess the best I could do in a first time would be to set up an Apache + MySQL installation on my computer to restore my wiki and test the restoration locally. I have been reluctant to do it until now because I'm not cumfortable with setting up Apache, I have some souvenirs of it being quite painful but hopefully my souvenirs have no reason to be. If it comes to work and my restoration to be all right, I would be reassured to know that my backups are valid and complete and give me time to find a solution to the restoration part. Just one thing, do you confirm that xml dumps are of no use for my backup / restore issue ?
And yes, I know there are some other elements to backup, already done for the LocalSettings, and to be done for images and extensions but it's not a big issue in my case, I have very few.
Regards
Pascal
Brian Wolff a écrit, le jeudi 30 juillet 2020 à 03:52:43 :
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@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
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l