On 9/15/08, Giorgio Sironi <[EMAIL PROTECTED]> wrote: > Hello, > I use a mysql db for my web application and I'd like to support sqlite > (also for testing purposes). > Does a standard way exist to import the table structure from mysql? > (phpmyadmin can export but in what format?) > Or maybe a database-agnostic language to write the schema with so that > mysql/sqlite tables could be generated from.
What is wrong with SQL? Dump the db in SQL, and import it into SQLite. As long as you don't have any funky MySQL specific stuff that is not supported in SQLite, you should get a SQLite db. You can compare the two to determine what was lost in translation. > Greetings, > > > -- > Giorgio Sironi > Piccolo Principe & Ossigeno Scripter > http://www.sourceforge.net/projects/ossigeno > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
