How to tansfer sqlite local DB to the MySQL DB using web service with PHP

Question

I want to write web service which gets sqlite database from client device (i-phone app) and sync with server mysql DB. both sqlite and mysql has same DB table structure.

Should i accept json string from client for each table and parse it on the server end and get store the data in mysql DB. is it the right solution or is there any other solution for syncing both client and server DB ?

Community · Accepted Answer · 2017-05-23 12:13:00Z

0

SQLite has an option to dump the DB into a text file containing SQL commands. See Exporting from SQLite to SQL Server and http://sqlite.org/sqlite.html.

You can dump the SQLite into a file, have your program tweak the SQL a bit (remove table creation, triggers and other irrelevant stuff) and run it on the MySQL DB.

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Jul 26, 2013 at 5:27

Vadim

2,86517 silver badges18 bronze badges

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

2 Comments

Vidyadhar Mandke Over a year ago

Do you have a clue how to write web service for it in PHP ?

Vadim Over a year ago

I'm not familiar with PHP, but working with SQLite looks the same - php.net/manual/en/book.sqlite3.php

Collectives™ on Stack Overflow

How to tansfer sqlite local DB to the MySQL DB using web service with 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