Load AWS ELB logs to MySQL

elb_logs_create.sql

CREATE TABLE `elb_logs` (
  `type` varchar(10) DEFAULT NULL,
  `timestamp` varchar(30) DEFAULT NULL,
  `elb` varchar(50) DEFAULT NULL,
  `client:port` varchar(30) DEFAULT NULL,
  `target:port` varchar(30) DEFAULT NULL,
  `request_processing_time` varchar(10) DEFAULT NULL,
  `target_processing_time` varchar(10) DEFAULT NULL,
  `response_processing_time` varchar(10) DEFAULT NULL,
  `elb_status_code` varchar(5) DEFAULT NULL,
  `target_status_code` varchar(5) DEFAULT NULL,
  `received_bytes` varchar(10) DEFAULT NULL,
  `sent_bytes` varchar(10) DEFAULT NULL,
  `request` text,
  `user_agent` text,
  `ssl_cipher` varchar(300) DEFAULT NULL,
  `ssl_protocol` varchar(10) DEFAULT NULL,
  `target_group_arn` varchar(200) DEFAULT NULL,
  `trace_id` varchar(100) DEFAULT NULL,
  `domain_name` varchar(100) DEFAULT NULL,
  `chosen_cert_arn` varchar(300) DEFAULT NULL,
  `matched_rule_priority` varchar(10) DEFAULT NULL,
  `request_creation_time` varchar(30) DEFAULT NULL,
  `actions_executed` varchar(10) DEFAULT NULL,
  `redirect_url` varchar(10) DEFAULT NULL,
  `error_reason` varchar(10) DEFAULT NULL,
  `target:port_list` varchar(30) DEFAULT NULL,
  `target_status_code_list` varchar(10) DEFAULT NULL,
  KEY `ebl_status_code_ix` (`elb_status_code`),
  KEY `ebl_ix` (`elb`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

load_data.sql

  LOAD DATA INFILE 'logs.log'   
  INTO TABLE elb_logs   FIELDS TERMINATED BY ' '   ENCLOSED BY '"' 
  LINES TERMINATED BY '\n';