How to convert mysql to SQLite using PHP

Question

I have a database on mysql server. I want to convert that to sqlite3 database without using shell or perl scripts. I want some help converting the same using PHP. Any Help would be appreciated.

jpimentel · Accepted Answer · 2012-04-19 10:32:51Z

0

Depending on the the database, you should easily create a mysql dump (in the form of SQL creates and inserts) and then run it in sqlite. You'll probably need to change the table creation statements though, because of different column datatypes used by each engine.

answered Apr 19, 2012 at 10:32

jpimentel

7041 gold badge7 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sadek Hassan Over a year ago

Thank you again for your help. i was doing some research on this subject and i find a code which allow me to this but i think there's some problem somewhere. This is the link : blog.jembe.fr/convertir-mysql-en-sqlite-en-php

Collectives™ on Stack Overflow

How to convert mysql to SQLite using PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related