```
$ mysql -u admin -pABC123 db < backup.sql
ERROR 1054 (42S22) at line 365438: Unknown column 'NTLL' in 'field list'
$ grep -E -i -e 'NTLL' backup.sql || echo "NTLL IS NEVER USED"
NTLL IS NEVER USED

```

line 365438 (which is essentially the same as the three hundred thousand lines before it...) looks like

```
INSERT IGNORE INTO `tableName` (`a`, `b_u`, `c`, `d`, `e`, `f`, `g_h`, `i_j`, `k_l`, `m_n`, `o_p`, `q`, `r`)
VALUES ('s_t',1.55923,1.55434,1.55932,1.55443,1.55919,1.55429,1.55932,1.55443,1.55919,1.55429,NULL,'2015-11-15 07:12:10');

```

obviously `NTLL` is not used...

lets check the table it self:

```
$ mysql> show create table tableName;
CREATE TABLE `tableName` (
  `a` varchar(32) COLLATE utf8_bin NOT NULL,
  `b_u` decimal(16,5) DEFAULT NULL,
  `c` decimal(16,5) DEFAULT NULL,
  `d` decimal(16,5) DEFAULT NULL,
  `e` decimal(16,5) DEFAULT NULL,
  `f` decimal(16,5) DEFAULT NULL,
  `g_h` decimal(16,5) DEFAULT NULL,
  `i_j` decimal(16,5) DEFAULT NULL,
  `k_l` decimal(16,5) DEFAULT NULL,
  `m_n` decimal(16,5) DEFAULT NULL,
  `o_p` decimal(16,5) DEFAULT NULL,
  `q` bigint(20) DEFAULT NULL,
  `r` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  UNIQUE KEY `a_r_index` (`a`,`r`) USING BTREE,
  KEY `r_index` (`r`,`a`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

```

what on earth is *`NTLL`*????

 UPDATE
=======

also noticed the same issue but this time with column `b^u` which is very similar to the real column `b_u` but, it's still not the same...

```
$ grep -E -i -e 'b\^u' backup-2.sql || echo "b^u IS NEVER USED"
b^u IS NEVER USED

```

also of note is that there are no known triggers in use in the database:

```
mysql>show triggers;
Empty set (0.00 sec)

```

since `b^u` looks like `b_u`, it may be worth mentioning that `NTLL` is *almost* like `NULL`...