Import data from XML file to MySQL without programming

Shiji Pan

8 years ago

Want to import data from XML file to MySQL ?

Using FileToDB, a native GUI tool, you can import data from XML file to MySQL (MariaDB, Percona) easily and fast.

Here’s how to.

Example of importing XML to MySQL (MariaDB, Percona)

Example source XML file

After converting, data in MySQL table

Choose MySQL and logon.

Click “Wizard – 1 File To 1 Table” at task dialog.

Select the “XML” file type.

then show the wizard.

1. Open a XML file.

2. Select a MySQL table and config fields.

3. Preview data.

4. Import XML data MySQL (MariaDB, Percona).

View imported data in MySQL table

You can save/load session to run “XML to MySQL” conversion repeatly.

1.Save Session.

Click “Save Session” button, then enter a session file name.

click “OK” button.

2.Load Session.

Click the “Open a Saved Session” in task window, select a session file.

then show the wizard form, click a few “Next” to import XML to MySQL.

You can run “XML to MySQL” conversion in command line.

When you save session, you can click “Save & Make Batch File”.

The “Save & Make Batch File” form shows.

Click “OK” button, you’ll create a batch file, in Windows, like this:

C:
cd "C:\Users\pansh\AppData\Local\Programs\FileToDB"
FileToDB task="C:\Users\pansh\Documents\test.ldr" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

You can run “XML to MySQL” conversion automatically at specific time.

On Linux/macOS, you can use Crontab.

On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.