Member Avatar for ChPravin

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?

  • 2 Contributors
  • 2 Replies
  • 76 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by ChPravin
Member Avatar for maba001

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.

Member Avatar for ChPravin

Thanks for the reply!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.