How to convert mysql to SQLite using PHP

Question

I have a database on mysql server. I want to convert this to sqlite3 database without using shell scripts or perl. I want some help to be converted using PHP. Any help would be appreciated.

Answer 1

Depending on the database, you should easily dump mysql (in the form of SQL it creates and inserts), and then run it in sqlite. You will probably have to change the table creation instructions, although due to the different types of columns used by each engine.