E
E
EvgenyJozef30002019-02-23 16:30:29
MySQL
EvgenyJozef3000, 2019-02-23 16:30:29

How to prepare an exported XML file from a MySQL database for import into Highload infoblocks?

Good evening.
What we do:
1) Export the MySQL database (with tables: akb, makes, models, modifications and vehicles) to an XML file. Each table has different columns!
2) In the XML file, you must make such a structure that the import will work correctly.
So. With the first task, I already solved the issue by exporting each table through PhpMyAdmin. The result is one of several files (for example, let's take the makes table ) : https://pastebin.com/raw/CMFhCrkq
Among the tables there is a fairly large one, consisting of 200,000 entries. After looking at all this, I realized that I needed to somehow automate the process of setting up the structure, so I am turning to you for suggestions. What do you think?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question