How to convert mysql to sqlite3 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.

Um What do you need converted? Table structure? PHP Code? How to export from MySQL to SQLite 3? — Phill Pafford
– Phill Pafford, Commented May 19, 2011 at 14:18
I want the entire structure and data from my mysql database to sqlite3 database. I want to do this using PHP. Thanks — aToz
– aToz, Commented May 19, 2011 at 14:23

Community · Accepted Answer · 2023-11-17 20:08:53Z

2

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

edited Nov 17, 2023 at 20:08

CommunityBot

11 silver badge

answered May 19, 2011 at 14:21

Jeroen

13.3k4 gold badges45 silver badges63 bronze badges

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

2 Comments

aToz Over a year ago

Hey Jefroen, Thanks for that.. I want to do it using PHP because I am hosting my website on a Yahoo small business server and apparently we cannot run system commands on that.

aToz Over a year ago

Hey Guys, Thanks for the response.. But I have found a link which solved my problem. Solution Link

Collectives™ on Stack Overflow

How to convert mysql to sqlite3 using PHP

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related