Mernis DB in to Mysql

create database mernis;

use mernis;

SET CHARSET utf8;

CREATE TABLE `kimlik` (
  ID bigint(15) unsigned auto_increment
      primary key,
   TCKIMLIK bigint(11) unsigned null,
   ADI varchar(50) null,
   SOYADI varchar(50) null,
   ANAADI varchar(50) null,
   BABAADI varchar(50) null,
   CINSIYET varchar(1) null,
   DOGUMYERI varchar(50) null,
   DOGUM_TARIHI varchar(50) null,
   KIMLIK_IL varchar(50) null,
   KIMLIK_ILCE varchar(50) null,
   IL varchar(50) null,
   ILCE varchar(50) null,
   MAHALLE varchar(50) null,
   SOKAK varchar(50) null,
   KAPI_NO varchar(50) null,
   DIGER varchar(50) null
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

create index ADI
   on kimlik (ADI);

create index SOYADI
   on kimlik (SOYADI);

create index TCKIMLIK
   on kimlik (TCKIMLIK);

 LOAD DATA LOCAL INFILE '/yedek/mernis.csv' IGNORE INTO TABLE kimlik FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';