Very simple, I need to copy tables of SQLite data into MYSQL tables.
If the UID already exists in the MYSQL tables, then they should update and not create a record. Assume field names are identical, except for the primary key field name, this needs to be specified in the ini file.
There are x5 tables that require replicating and need to be updated every few seconds, all errors need to be logged.
I would like to configure the script using an ini file like this example.
[mysql]
MYSQL Login Info:
[sqlite]
SQLite Login Info:
[copyinfo]
tbl_sqlite1 >> tbl_mysql >> primary_key_fieldname
tbl_sqlite2 >> tbl_mysql_table2 >> primary_key_fieldname2
tbl_sqlite3 >> tbl_mysql_table3 >> primary_key_fieldname3
tbl_sqlite4 >> tbl_mysql_table4 >> primary_key_fieldname4
tbl_sqlite5 >> tbl_mysql_table5 >> primary_key_fieldname5