Topic on Project:Support desk

hi guys!

I was sure I'd find something quickly on this, but getting stuck it seems - and cannot find exactly the same error which is weird

basically trying to restore my old wiki XML dump on newer wiki, which is running on Synology

• MediaWiki 1.39.2
• PHP 8.0.28 (fpm-fcgi)
• MariaDB 10.11.2-MariaDB
• ICU 64.2

the file is quite big and has multiple languages in it (mostly english, but also Russian and Japanese etc).

what else can I try? I am hoping that I can import it like this (without having to restore older files & try to match MySQL version for mysqldump which I also have etc etc).

appreciate any tips !

user@Syn:/var/services/web_packages/mediawiki/maintenance$ php74 importDump.php --conf ../LocalSettings.php < /volume1/Syn/User/mediawiki_backups/wikidb_20140913.xml

MWException from line 724 of /volume1/web_packages/mediawiki/includes/import/WikiImporter.php: Expected <mediawiki> tag, got mysqldump

#0 /volume1/web_packages/mediawiki/maintenance/importDump.php(364): WikiImporter->doImport()

#1 /volume1/web_packages/mediawiki/maintenance/importDump.php(305): BackupReader->importFromHandle(Resource id #760)

#2 /volume1/web_packages/mediawiki/maintenance/importDump.php(139): BackupReader->importFromStdin()

#3 /volume1/web_packages/mediawiki/maintenance/includes/MaintenanceRunner.php(309): BackupReader->execute()

#4 /volume1/web_packages/mediawiki/maintenance/doMaintenance.php(85): MediaWiki\Maintenance\MaintenanceRunner->run()

#5 /volume1/web_packages/mediawiki/maintenance/importDump.php(369): require_once('/volume1/web_pa...')

#6 {main}

just for reference beginning of this XML file is

<?xml version="1.0"?>

<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<database name="wikidb">

<table_structure name="mw_archive">

<field Field="ar_id" Type="int(10) unsigned" Null="NO" Key="PRI" Extra="auto_increment" Comment="" />

<field Field="ar_namespace" Type="int(11)" Null="NO" Key="MUL" Default="0" Extra="" Comment="" />

<field Field="ar_title" Type="varbinary(255)" Null="NO" Key="" Default="" Extra="" Comment="" />

<field Field="ar_text" Type="mediumblob" Null="NO" Key="" Extra="" Comment="" />

<field Field="ar_comment" Type="tinyblob" Null="NO" Key="" Extra="" Comment="" />

<field Field="ar_user" Type="int(10) unsigned" Null="NO" Key="" Default="0" Extra="" Comment="" />

<field Field="ar_user_text" Type="varbinary(255)" Null="NO" Key="MUL" Extra="" Comment="" />

<field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="" Extra="" Comment="" />

<field Field="ar_minor_edit" Type="tinyint(4)" Null="NO" Key="" Default="0" Extra="" Comment="" />

<field Field="ar_flags" Type="tinyblob" Null="NO" Key="" Extra="" Comment="" />

<field Field="ar_rev_id" Type="int(10) unsigned" Null="YES" Key="MUL" Extra="" Comment="" />

<field Field="ar_text_id" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_deleted" Type="tinyint(3) unsigned" Null="NO" Key="" Default="0" Extra="" Comment="" />

<field Field="ar_len" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_page_id" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_parent_id" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_sha1" Type="varbinary(32)" Null="NO" Key="" Default="" Extra="" Comment="" />

<field Field="ar_content_format" Type="varbinary(64)" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_content_model" Type="varbinary(32)" Null="YES" Key="" Extra="" Comment="" />

<key Table="mw_archive" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="ar_id" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="name_title_timestamp" Seq_in_index="1" Column_name="ar_namespace" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="name_title_timestamp" Seq_in_index="2" Column_name="ar_title" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="name_title_timestamp" Seq_in_index="3" Column_name="ar_timestamp" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="usertext_timestamp" Seq_in_index="1" Column_name="ar_user_text" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="usertext_timestamp" Seq_in_index="2" Column_name="ar_timestamp" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="ar_revid" Seq_in_index="1" Column_name="ar_rev_id" Collation="A" Cardinality="0" Null="YES" Index_type="BTREE" Comment="" Index_comment="" />

<options Name="mw_archive" Engine="InnoDB" Version="10" Row_format="Compact" Rows="0" Avg_row_length="0" Data_length="16384" Max_data_length="0" Index_length="49152" Data_free="5242880" Auto_increment="1" Create_time="2014-09-13 02:23:19" Collation="binary" Create_options="" Comment="" />

</table_structure>

<table_data name="mw_archive">

</table_data>

<table_structure name="mw_category">

<field Field="cat_id" Type="int(10) unsigned" Null="NO" Key="PRI" Extra="auto_increment" Comment="" />

<field Field="cat_title" Type="varbinary(255)" Null="NO" Key="UNI" Extra="" Comment="" />

<field Field="cat_pages" Type="int(11)" Null="NO" Key="MUL" Default="0" Extra="" Comment="" />

<field Field="cat_subcats" Type="int(11)" Null="NO" Key="" Default="0" Extra="" Comment="" />

<field Field="cat_files" Type="int(11)" Null="NO" Key="" Default="0" Extra="" Comment="" />

<key Table="mw_category" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="cat_id" Collation="A" Cardinality="40" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_category" Non_unique="0" Key_name="cat_title" Seq_in_index="1" Column_name="cat_title" Collation="A" Cardinality="40" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_category" Non_unique="1" Key_name="cat_pages" Seq_in_index="1" Column_name="cat_pages" Collation="A" Cardinality="40" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<options Name="mw_category" Engine="InnoDB" Version="10" Row_format="Compact" Rows="40" Avg_row_length="409" Data_length="16384" Max_data_length="0" Index_length="32768" Data_free="5242880" Auto_increment="41" Create_time="2014-09-13 02:23:19" Collation="binary" Create_options="" Comment="" />

</table_structure>

<table_data name="mw_category">

<row>

<field name="cat_id">1</field>

<field name="cat_title">Debian</field>

<field name="cat_pages">18</field>

<field name="cat_subcats">0</field>

<field name="cat_files">0</field>

importDump.php only accepts XML dumps generated from Special:Export or Manual:dumpBackup.php

Your XML dump seems to be a *database* dump, which is more low-level than MediaWiki's dumps. You should import it directly to the mysql/mariadb database, not with MediaWiki.

thanks @Ciencia Al Poder !

I just checked what script I used, it seems like it was dumpBackup.php indeed

I do have a second set of pure .sql files as well, those are indeed created by mysqldump (and those I am trying not to use due to old version)

php /usr/share/mediawiki/maintenance/dumpBackup.php --full --output=bzip2:wikixml-$(date '+%Y%m%d').tar.bz2

dumpBackup.php doesn't generate this kind of XML, that's why you're getting the error in the first place.

See https://stackoverflow.com/questions/43699791/import-mysql-xml-dump for more information regarding importing your XML (mysql) dump

@Ciencia Al Poder thanks ! indeed yes, I get that the format is wrong

however I am pretty sure that this was the command which generated the file (unless I'm mixing something up)

my only guess now is that it is some very ancient version - I think that MediaWiki version was 1.18.1 or something like that

I'll have to do via a MySQL restoration indeed, cheers