V vdudukov Member Licensed User Longtime User May 29, 2015 #1 Hello everyone. I am trying to sync my internal SQLite database with my MySQL database. I can download all records into SQLite from MySQL based on web, but i dont know how to upload all my records from SQLite to MySQL. I saw many posts here, but nothing about this. Anyway Is it possible ? Example: I use httpjob to insert one record into MySQL. insert.download2("http://servername/server.php", Array As String ("action", "insert", "name", name.text, "lastname", lastname.text, "age", age.text)) Thanks. Last edited: May 29, 2015
Hello everyone. I am trying to sync my internal SQLite database with my MySQL database. I can download all records into SQLite from MySQL based on web, but i dont know how to upload all my records from SQLite to MySQL. I saw many posts here, but nothing about this. Anyway Is it possible ? Example: I use httpjob to insert one record into MySQL. insert.download2("http://servername/server.php", Array As String ("action", "insert", "name", name.text, "lastname", lastname.text, "age", age.text)) Thanks.
Erel B4X founder Staff member Licensed User Longtime User Jun 1, 2015 #2 If you can switch to RDC then it will be simpler and faster. The other option is to modify the php script to get all the records data and insert it into the database. Upvote 0
If you can switch to RDC then it will be simpler and faster. The other option is to modify the php script to get all the records data and insert it into the database.