[web2py] mySQL DB dumped to xml format --> import using DAL ?

[mart]

Hi,

let's say someone gave me a dump of a mySQL DB in xml format...
something that looks like this:


    <pma:structure_schemas>
        <pma:database name="test" collation="latin1_swedish_ci"
charset="latin1">
            <pma:table name="bitmap">
                CREATE TABLE `bitmap` (
                  `bitmap_id` int(11) NOT NULL AUTO_INCREMENT,
                  `filename` varchar(100) NOT NULL,
                  `kdb_id` int(11) NOT NULL,
                  `isDeleted` tinyint(1) NOT NULL DEFAULT '0',
                  PRIMARY KEY (`bitmap_id`),
                  KEY `kdb_id` (`kdb_id`),
                  CONSTRAINT `bitmap_ibfk_1` FOREIGN KEY (`kdb_id`)
REFERENCES `kdb` (`kdb_id`) ON DELETE CASCADE ON UPDATE CASCADE
                ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT
CHARSET=latin1;
            </pma:table>


what would be the best way to migrate this to an SQLite DB, something
that web2py could use?

I know that DAL can export to xml, but does it also import from xml as
well? Perhaps, this can be converted to CSV?

As usual, any help is much appreciated,

thanks,
Mart :)