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 ?

score 0 · Answer 1 · edited May 23 '17 at 12:13

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 '17 at 12:13

Community

1
1

answered Jul 26 '13 at 05:27

Vadim

2,847
15
18

Do you have a clue how to write web service for it in PHP ? – Vee Mandke Jul 26 '13 at 05:35
I'm not familiar with PHP, but working with SQLite looks the same - http://php.net/manual/en/book.sqlite3.php – Vadim Jul 26 '13 at 05:38

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

1 Answers1