Reputation: 2464
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.
Upvotes: 3
Views: 3766
Reputation: 13257
Using PHP only would be rather troublesome, you'd have to get all the records from your mysql table, create the appropriate tables in sqlite3 and insert the records.
As far as I can tell you just want to to it automatically, so I would'nt see the harm in using shell programs. You could quite easily do this using the exec
function: https://www.php.net/manual/en/function.exec.php
Upvotes: 2