Does any one know how to use SQLite? Can anyone tell me how to convert populated MySQL tables to SQLite tables without using a DBConvert software?
You could use mysqldump on the MySQL DB and create a plain SQL file from that. Then you could make this SQL file SQLite compatible using whatever text editor you like (vi, nedit, emacs, ...), this would basically be just the removal of some MySQL specials like COLLATION, the storage engine and so on. Global search / replace will do that for you.
In addition you might want to split the CREATE TABLE section and the INSERT INTO section into two separate files.
Then fire up sqlite and source the create table SQL file first and then the insert into file.
