Re: [MediaWiki-l] Restoring a mediawiki site

Hello, Thank you for your suggestions, and sorry for the delay, I haven't been able to test earlier. First I have read the doc pages you sent me, the 2 first : How_to_backup_a_wiki and How_to_restore_a_wiki_backup, and my attention has been focused on a few points : - on the backup doc page I read : "Optionally check Add DROP TABLE to delete existing references when importing." and on the restore doc page : "Depending on timeout settings and the size of the SQL file, it may take multiple attempts to import everything. Failure to complete the import may leave the database in an inconsistent state, e.g. with missing revisions." I'm nnot sure to understand, if my restoration is incomplete due to timeout, my second attempt shouldn't wipe the tables already restored ? The problem being that the restoration process doesn't seem to be fully reentrant, that's why my second attempt failed : a primary key already set or something like that. - on the backup doc page : "Make sure all items under Export are highlighted, and make sure Structure is highlighted [...] Make sure Data is checked." things are rendered such differently with lynx that I'm not sure of the relevance of what follows : I have at some places a 3-choice-box with the alternatives : "structure, "data", "data and structure" the 1st of these boxes, which is placed after a header "export table", "data" is checked for the others, wich are placed after headers like "opendocument text" ot "LaTex", "data and structure" is checked I really don't think there is any problem with it, because my resulting sql file seems to contain all the tables and their content, bu should I chekc "data and structure" in the first box ? - I discovered the possibility of XML dumps, but some pages insisted on the fact that they are not backups, do you confirm that it's not what I'm looking for ? Then I enabled the 4 variables you gave me in LocalSettings.php. I logged in on my wiki, opened a page and clicked on "history", and I got the followin error : « An error occured ... [33ddc7b2dc654e161e321974] /andrapal/index.php?title=R%C3%A9cit_de_l%27%C3%A9pop%C3%A9e_des_Hilhio te&action=history DBQueryError from line 1054 of /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/libs/ rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev _user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_con tent_format,rev_content_model,user_name,(SELECT GROUP_CONCAT(ct_tag SEPARATOR ',') FROM `andrapalchange_tag` WHERE ct_rev_id=rev_id ) AS `ts_tags` FROM `andrapalrevision` FORCE INDEX (page_timestamp) LEFT JOIN `andrapaluser` ON ((rev_user != 0) AND (user_id = rev_user)) WHERE rev_page = '2' ORDER BY rev_timestamp DESC LIMIT 51 Function: IndexPager::buildQueryInfo (history page unfiltered) Error: 1176 Key 'page_timestamp' doesn't exist in table 'andrapalrevision' (sql.lautre.net) Backtrace: #0 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/libs/ rdbms/database/Database.php(912): Database->reportQueryError(string, integer, string, string, boolean) #1 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/libs/ rdbms/database/Database.php(1254): Database->query(string, string) #2 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/pager /IndexPager.php(365): Database->select(array, array, array, string, array, array) #3 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/pager /IndexPager.php(222): IndexPager->reallyDoQuery(string, integer, boolean) #4 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/pager /IndexPager.php(605): IndexPager->doQuery() #5 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/pager /ReverseChronologicalPager.php(35): IndexPager->isNavigationBarShown() #6 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/actio ns/HistoryAction.php(216): ReverseChronologicalPager->getNavigationBar() #7 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/actio ns/FormlessAction.php(43): HistoryAction->onView() #8 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/Media Wiki.php(495): FormlessAction->show() #9 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/Media Wiki.php(289): MediaWiki->performAction(Article, Title) #10 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/Media Wiki.php(851): MediaWiki->performRequest() #11 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/includes/Media Wiki.php(512): MediaWiki->main() #12 /var/www/alternc/p/pascal/www/pascal.lautre.net/andrapal/index.php(43): MediaWiki->run() #13 {main} » This gave me the idea to go look in an export of my test database (the one who fails, on which I had restored), if andrapalrevision existed and if the key page_timestamp existed. I discovered that page_timestamp was in the 261 missing ALTER TABLE (which are in the primary database but not in the text database). So I guess the restoration is incomplete, maybe only these ALTER TABLE are missing, taht would be why the pages are ok but the history is corrupt. Halas I wasn't able to execute by hand these ALTER TABLE requests. I isolated them in a file, and imported that file, but I got, after a very long time processing : « Error SQL Request: ALTER TABLE `andrapalexternallinks` ADD PRIMARY KEY (`el_id`), ADD KEY `el_from` (`el_from`,`el_to`(40)), ADD KEY `el_to` (`el_to`(60),`el_from`), ADD KEY `el_index` (`el_index`(60)); MYSQL replied: Documentation #1062 - Duplicate entry '1' for key 'PRIMARY' » I precise that this request is the first of the 261 requests in my file. Well, I hope I wasn't too long. If you have any answers on this issue, I'm all ears opened. Regards Pascal Robert Vogel a écrit, le mardi 14 juillet 2020 à 05:59:36 :