rpbouman / mysqldump-x-restore Goto Github PK

The error message arise on using current mysqldump-xml-to-sql.xslt on a 5 
gigabyte xml dump.

Inside the dump are a lot of loglines (rsyslog) and binary data.

The xz compressed dump has 63Mb and can be provided on a confidential channel.

It would be great do get some assistance to recover as much of the data as 
possible (especially the gallery3 database).

What steps will reproduce the problem?
1. Run the mysqldump-x-restore stylesheet against a mysql dump file with 
apostrophes in the data between tags.
2.
3.

What is the expected output? What do you see instead?
I get a warning from xsltproc that there is a possible infinite recursion, even 
if I only have 1 row of data with a few hundred characters of text.
This is the error I get:
runtime error: file test.xslt line 385 element param
xsltApplyXSLTTemplate: A potential infinite template recursion was detected.
You can adjust xsltMaxDepth (--maxdepth) in order to raise the maximum number 
of nested template calls and variables/params (curre
ntly set to 3000).
Templates:
#0 name escape-quotes
#1 name escape-quotes
#2 name escape-quotes
#3 name escape-quotes
#4 name escape-quotes
#5 name escape-quotes
#6 name escape-quotes
#7 name escape-quotes
#8 name escape-quotes
#9 name escape-quotes
#10 name escape-quotes
#11 name escape-quotes
#12 name escape-quotes
#13 name escape-quotes
#14 name escape-quotes
Variables:
#0
value
#1
value
#2
value
#3
value
#4
value
#5
value
#6
value
#7
value
#8
value
#9
value
#10
value
#11
value
#12
value
#13
value
#14
value
no result for gives_infinite_recursion.xml

C:\Users\dschiller\Downloads\libxslt-1.1.26.win32\bin>xsltproc.exe mysqldump-xml-to-sql.xslt db_backup.xml
db_backup.xml:24: parser error : Char 0x0 out of allowed range
                <field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="
                                                                                        ^
db_backup.xml:24: parser error : AttValue: ' expected
                <field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="
                                                                                        ^
db_backup.xml:24: parser error : attributes construct error
                <field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="
                                                                                        ^
db_backup.xml:24: parser error : Couldn't find end of Start Tag field line 24
                <field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="
                                                                                        ^
db_backup.xml:24: parser error : Premature end of data in tag table_structure line 15
                <field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="
                                                                                        ^
db_backup.xml:24: parser error : Premature end of data in tag database line 3
                <field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="
                                                                                        ^
db_backup.xml:24: parser error : Premature end of data in tag mysqldump line 2
                <field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="
                                                                                        ^
unable to parse db_backup.xml

db_backup.xml:195342: parser error : PCDATA invalid Char value 5
???*2???↨?9j?Z?{,w?+?‼¦┐↨M??6hH'??&??%M▄àt????▬<??|???i?5?W{s?w▲=Y???p???
                                                                               ^

db_backup.xml:195347: parser error : PCDATA invalid Char value 6
                <field name="value">+?2?R241U?♠</field>
                                              ^
db_backup.xml:195352: parser error : PCDATA invalid Char value 6
                <field name="value">+?2?R2461U?♠</field>
                                               ^
db_backup.xml:195357: parser error : PCDATA invalid Char value 6
                <field name="value">+?2?R?P?♠</field>
                                            ^
db_backup.xml:195362: parser error : PCDATA invalid Char value 6
                <field name="value">+?2?R242T?♠</field>
                                              ^
db_backup.xml:195365: parser error : Opening and ending tag mismatch: row line 194332 and table_data
        </table_data>
                     ^
db_backup.xml:1594525: error: xmlSAX2Characters: huge text node: out of memory
# Uncheck &quot;Use SSL&quot; and &quot;Use TLS&quot;
                                                     ^
db_backup.xml:1594526: parser error : Extra content at the end of the document
# Publish &lt;nowiki&gt;email.ou&lt;/nowiki&gt;tboundmessenger
^
unable to parse db_backup.xml