iGarment Wiki

1. Recommend to use a dedicated computer for Data Sync server. Suggest to use SSD hard disk instead of HDD.

2. Download mariadb-10.11 from internet and install it.

3. Add/Modify below lines in my.ini.

[mysqld] sql_mode=NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER max_allowed_packet = 128M Connect_timeout = 86400

4. Unzip the data sync programs provided by iGarment.

5. Create folder \Company under \synchro folder & put your company’s id.co in this folder.

6. Run Synchro.exe & set Configuration as below:-

Company = database name Server IP = iGarment server IP (input the fastest ip no. in your factory location) Server Port = 7001 User Name = login user name for Data Sync program (cannot include Chinese character) Password = if required (cannot include Chinese character) Encrypt Key = ‘n=’ value in id.co file Local Server IP = 127.0.0.1 Local Username = root Local Password = root password (If you have set root password when installing mariadb, you need to input the password here. If no password set, just leave this field blank) Skip tables = input the tables that you do not want to sync, separate tables by commas e.g. ngattach, ngattachdtl, ngbackup, ngclicklog, ngdoclock, t_%, Need to add ‘t_%’ in order to skip all temporary tables. Verify tables = input the tables that you want to verify between local and SaaS database Log File = system will automatic update this file name e.g. db135-master-log.062 Log Position = system will automatic update this position number e.g. 318819

7. Click ‘Build’ to create the database from beginning

Message ‘Are you sure to rebuild database?’ will be shown. Click ‘Yes’.

- System will download the backup zip file (xxx.gz) to \archive folder. - After download, system will unzip the backup file (xxx.db), then init database.

8. After database initialization is completed, click ‘Replicate’ to start the data sync process.

9. If you want to verify tables, click Verify.

- System will show the tables that you have inputted in Configuration with their corresponding log file and position. - Then click ‘Replicate’ after verify tables have been set.

- System will start the verification process when verify log file is reached. - If no error found after verification, it will show ‘OK’ under ‘Note’ column. - If error found, need to ‘Build’ database from beginning.

10. Automatic upgrade data sync program

- Update.exe and update.ini are added [Configuration] Product=synchro Force=1 If Force is set to 1, it means that you must upgrade the program before you can start the data sync process.

Note:- Log file size is limited to 10M. If exceed 10M, system will automatic create a new log file e.g. synchro.log, synchro.log.187, synchro.log.186 … etc. The latest log is synchro.log   Internal Note:- For iWorkPMS customers, below error will be found when ‘Build’. Error: Table ‘pyxxxxx.nguser’ doesn’t exist Need to manually create table ‘nguser’ in iWorkPMS database because iWorkPMS user table is ‘pyuser’. Create a login user in ‘nguser’.