also, I found that they gave me the equivalent data in a .sql file.... would that be understood by DAL?
thanks again, Mart :) On Jun 21, 9:14 pm, mart <[email protected]> wrote: > 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 :)
