Is there a generic/automatic way in R or in python to parse xml files with its nodes and attributes, automatically generate mysql tables for storing that information and then populate those tables.
They're three separate operations: parsing, table creation, and data population.  You can do all three with python, but there's nothing "automatic" about it.  I don't think it's so easy.
For example, XML is hierarchical and SQL is relational, set-based.  I don't think it's always so easy to get a good relational schema for every single XML stream you can encounter.
Parsing an xml file and storing it into a database