Devam Ediyor

SQLite to MYSQL Regular Data Copy

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

Beceriler: MySQL, Perl, SQLite

Daha fazlasını görün: primary data, x5, sqlite, data copy, perl login mysql, mysql update field, example mysql script, regular create, copy tables, mysql uid, script update mysql tables, perl update file, configure mysql, perl sqlite, create data copy, perl script data mysql, mysql sqlite, sqlite example, script update data mysql, copy data database mysql, sqlite file, script copy perl, perl update mysql, mysql perl script, copy data sql mysql

İşveren Hakkında:
( 22 değerlendirme ) London, United Kingdom

Proje NO: #6491412