0

I have just exported a data table in XML format from phpPgAdmin. I want to load this file into my local mysql database. The table structure is the same for both databases.

I know that mysql allows import of xml data using the example xml structure below:

<row>
<field name='column1'>value1</field>

My problem is that phpPgAdmin has exported the data in this format:

 <row>
    <column name='column1'>value1</column>

Is there a way to map or SET the column name so I can import using LOAD XML LOCAL INFILE?

Franc
  • 1
  • 2

1 Answers1

2

You've probably long since figured this out, but this answer from SO: LOAD XML LOCAL INFILE with Inconsistent Column Names should show you how if you have not. I'm new to MySQL and working with a very similar problem to yours. Hopefully this will help someone else if not you.

Community
  • 1
  • 1
delliottg
  • 3,950
  • 3
  • 38
  • 52