Withdata Software

Import data from multiple XML files to a single MySQL table

Want to import multiple XML files into a single MySQL table?

Using Withdata software File To DB, a XML importer for MySQL on Windows, MacOS, and Linux, you can import multiple XML files into a single MySQL (MariaDB, Percona) table in one go.

Download FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import multiple XML files into a single MySQL (MariaDB, Percona) table

Login to MySQL -> Choose XML files -> Set MySQL table -> Import XML files to MySQL table

Choose MySQL and logon.

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

Select the “XML” file type.

then show the wizard.

1. Select a folder that constains XML files.

Support large ( > 4GB ) XML file.

2. Config first XML file importing options.

3. Select a MySQL table and config fields.

4. Preview data will be in MySQL table.

5. Import multiple XML files to the MySQL table.

View imported data in MySQL table

You can schedule and automate this converting task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS)

2) Set scheduled task.

FAQ

How long does it take to import XML data to MySQL?
FileToDB works fast. It convert millions of rows within a minute.
Is it safe to import XML data to MySQL using FileToDB?
Of course! FileToDB import XML data to MySQL locally, absolutely safe.
Can I import XML data to MySQL on Linux, Mac OS?
Yes, you can. FileToDB has Linux, Mac OS, and Windows version.
Can I import XML data to MySQL in command line?
Yes, you can. FileToDB can running in command line, on Linux, Mac OS, and Windows.


More about FileToDBXML to MySQL converter