MySQL Forums
Forum List  »  MySQL Workbench

Difference in load .sql data files
Posted by: Thomas Stieve
Date: April 24, 2019 03:20PM

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
Difference in load .sql data files
402
April 24, 2019 03:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.