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 <[email protected]> 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 _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
