On 9/15/08, Giorgio Sironi <[EMAIL PROTECTED]> wrote: > 2008/9/15 P Kishor <[EMAIL PROTECTED]>: > > > What is wrong with SQL? Dump the db in SQL, and import it into SQLite. > > > I'm not talking about the data, since once the database is in place > there's no need to change it; the problem is the structure: column > types, indexes, auto_increment and so on...
the SQL dump is a plain text file... open it in a text editor and delete the data INSERT statements. Can't be easier than that. Else, duplicate the db in MySQL, delete all the data from the dupe, dump the empty db, and voila! Hopefully you don't have to do this everyday, so this shouldn't be too much of a bear. Keep in mind, funky MySQL things may not be supported in SQLite. > > > > -- > > 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
