Difference in load .sql data files
hello all,
I am loading data files in .sql format into the same database. I'm trying to automate this. I have loaded the same file through the GUI and through a command prompt. The GUI produces no errors, but the command prompt method produces several (see below). When I check both tables, there are no unmatched records, so it appears fine. Should I be concerned? Thanks! Tom
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.10 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 27656 rows affected (0.62 sec)
Records: 27656 Duplicates: 0 Warnings: 0
Query OK, 21727 rows affected (0.31 sec)
Records: 21727 Duplicates: 0 Warnings: 0
Query OK, 29228 rows affected, 1 warning (0.65 sec)
Records: 29228 Duplicates: 0 Warnings: 1
Query OK, 28637 rows affected (3.01 sec)
Records: 28637 Duplicates: 0 Warnings: 0
Query OK, 28613 rows affected, 147 warnings (10.07 sec)
Records: 28613 Duplicates: 0 Warnings: 147
Query OK, 29126 rows affected (15.59 sec)
Records: 29126 Duplicates: 0 Warnings: 0
Query OK, 25131 rows affected (16.53 sec)
Records: 25131 Duplicates: 0 Warnings: 0
Query OK, 27265 rows affected (21.40 sec)
Records: 27265 Duplicates: 0 Warnings: 0
Query OK, 23988 rows affected (18.94 sec)
Records: 23988 Duplicates: 0 Warnings: 0
Query OK, 29046 rows affected (26.84 sec)
Records: 29046 Duplicates: 0 Warnings: 0
Query OK, 26750 rows affected (29.07 sec)
Records: 26750 Duplicates: 0 Warnings: 0
Query OK, 27725 rows affected (28.08 sec)
Records: 27725 Duplicates: 0 Warnings: 0
Query OK, 23672 rows affected (22.41 sec)
Records: 23672 Duplicates: 0 Warnings: 0
Query OK, 27298 rows affected (25.43 sec)
Records: 27298 Duplicates: 0 Warnings: 0
Query OK, 8791 rows affected, 2 warnings (7.95 sec)
Records: 8791 Duplicates: 0 Warnings: 2
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)