Hi,
First of all thanks for providing in-depth detail of your project work. It really helps us to estimate correctly and providing the right solution.
I have reviewed your requirement and can import your data into MySQL according to the need by parsing the XMLs. I have few query/suggestion especially for the bigger file python will be a better fit as the processing will be fast. Because for smaller files php can perform better as their native mysql connections handling is good. But in case of big data I always prefer to use python as it is very fast.
I have more than 10 years of experince in PHP, Python, Big Data Engineering, Amazon Cloud, Mysql, HTML, CSS.
I have handled more than 200 GB of MySQL database in a single application.
Can we have a quick chat? I can start work right away. I will only charge after you will be completely satisfied.
Thanks