SHOW CREATE TABLE whois

whois	CREATE TABLE `whois` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(20) NOT NULL,
  `num` text,
  `domain_name` text,
  `registrar_name` text,
  `contact_email` text,
  `query_time` text,
  `create_date` text,
  `update_date` text,
  `expiry_date` text,
  `standardRegCreatedDate` text,
  `standardRegExpiresDate` text,
  `standardRegUpdatedDate` text,
  `Audit_auditUpdatedDate` text,
  `status` text,
  `whoisServer` text,
  `registrarIANAID` text,
  `domain_registrar_id` text,
  `domain_registrar_name` text,
  `domain_registrar_url` text,
  `domain_registrar_whois` text,
  `registrant_address` text,
  `registrant_city` text,
  `registrant_company` text,
  `registrant_country` text,
  `registrant_email` text,
  `registrant_fax` text,
  `registrant_faxExt` text,
  `registrant_name` text,
  `registrant_organization` text,
  `registrant_phone` text,
  `registrant_postalCode` text,
  `registrant_state` text,
  `registrant_street1` text,
  `registrant_street2` text,
  `registrant_street3` text,
  `registrant_street4` text,
  `registrant_telephone` text,
  `registrant_telephoneExt` text,
  `registrant_zip` text,
  `administrative_city` text,
  `administrative_country` text,
  `administrative_email` text,
  `administrative_fax` text,
  `administrative_faxExt` text,
  `administrative_name` text,
  `administrative_organization` text,
  `administrative_postalCode` text,
  `administrative_state` text,
  `administrative_street1` text,
  `administrative_street2` text,
  `administrative_street3` text,
  `administrative_street4` text,
  `administrative_telephone` text,
  `administrative_telephoneExt` text,
  `administrative_address` text,
  `administrative_company` text,
  `administrative_phone` text,
  `administrative_zip` text,
  `technical_city` text,
  `technical_country` text,
  `technical_email` text,
  `technical_fax` text,
  `technical_faxExt` text,
  `technical_name` text,
  `technical_organization` text,
  `technical_postalCode` text,
  `technical_state` text,
  `technical_street1` text,
  `technical_street2` text,
  `technical_street3` text,
  `technical_street4` text,
  `technical_telephone` text,
  `technical_telephoneExt` text,
  `technical_address` text,
  `technical_company` text,
  `technical_phone` text,
  `technical_zip` text,
  `billing_city` text,
  `billing_country` text,
  `billing_email` text,
  `billing_fax` text,
  `billing_faxExt` text,
  `billing_name` text,
  `billing_organization` text,
  `billing_postalCode` text,
  `billing_state` text,
  `billing_street1` text,
  `billing_street2` text,
  `billing_street3` text,
  `billing_street4` text,
  `billing_telephone` text,
  `billing_telephoneExt` text,
  `billing_address` text,
  `billing_company` text,
  `billing_phone` text,
  `billing_zip` text,
  `zone_city` text,
  `zone_country` text,
  `zone_email` text,
  `zone_fax` text,
  `zone_faxExt` text,
  `zone_name` text,
  `zone_organization` text,
  `zone_postalCode` text,
  `zone_state` text,
  `zone_street1` text,
  `zone_street2` text,
  `zone_street3` text,
  `zone_street4` text,
  `zone_telephone` text,
  `zone_telephoneExt` text,
  `name_server_1` text,
  `name_server_2` text,
  `name_server_3` text,
  `name_server_4` text,
  `domain_status_1` text,
  `domain_status_2` text,
  `domain_status_3` text,
  `domain_status_4` text,
  PRIMARY KEY (`id`),
  KEY `ref` (`ref`)
) ENGINE=InnoDB AUTO_INCREMENT=106352427 DEFAULT CHARSET=utf8

---------------
DESC whois



id	int(11)	NO	PRI		auto_increment
ref	varchar(20)	NO	MUL
num	text	YES
domain_name	text	YES
registrar_name	text	YES
contact_email	text	YES
query_time	text	YES
create_date	text	YES
update_date	text	YES
expiry_date	text	YES
standardRegCreatedDate	text	YES
standardRegExpiresDate	text	YES
standardRegUpdatedDate	text	YES
Audit_auditUpdatedDate	text	YES
status	text	YES
whoisServer	text	YES
registrarIANAID	text	YES
domain_registrar_id	text	YES
domain_registrar_name	text	YES
domain_registrar_url	text	YES
domain_registrar_whois	text	YES
registrant_address	text	YES
registrant_city	text	YES
registrant_company	text	YES
registrant_country	text	YES
registrant_email	text	YES
registrant_fax	text	YES
registrant_faxExt	text	YES
registrant_name	text	YES
registrant_organization	text	YES
registrant_phone	text	YES
registrant_postalCode	text	YES
registrant_state	text	YES
registrant_street1	text	YES
registrant_street2	text	YES
registrant_street3	text	YES
registrant_street4	text	YES
registrant_telephone	text	YES
registrant_telephoneExt	text	YES
registrant_zip	text	YES
administrative_city	text	YES
administrative_country	text	YES
administrative_email	text	YES
administrative_fax	text	YES
administrative_faxExt	text	YES
administrative_name	text	YES
administrative_organization	text	YES
administrative_postalCode	text	YES
administrative_state	text	YES
administrative_street1	text	YES
administrative_street2	text	YES
administrative_street3	text	YES
administrative_street4	text	YES
administrative_telephone	text	YES
administrative_telephoneExt	text	YES
administrative_address	text	YES
administrative_company	text	YES
administrative_phone	text	YES
administrative_zip	text	YES
technical_city	text	YES
technical_country	text	YES
technical_email	text	YES
technical_fax	text	YES
technical_faxExt	text	YES
technical_name	text	YES
technical_organization	text	YES
technical_postalCode	text	YES
technical_state	text	YES
technical_street1	text	YES
technical_street2	text	YES
technical_street3	text	YES
technical_street4	text	YES
technical_telephone	text	YES
technical_telephoneExt	text	YES
technical_address	text	YES
technical_company	text	YES
technical_phone	text	YES
technical_zip	text	YES
billing_city	text	YES
billing_country	text	YES
billing_email	text	YES
billing_fax	text	YES
billing_faxExt	text	YES
billing_name	text	YES
billing_organization	text	YES
billing_postalCode	text	YES
billing_state	text	YES
billing_street1	text	YES
billing_street2	text	YES
billing_street3	text	YES
billing_street4	text	YES
billing_telephone	text	YES
billing_telephoneExt	text	YES
billing_address	text	YES
billing_company	text	YES
billing_phone	text	YES
billing_zip	text	YES
zone_city	text	YES
zone_country	text	YES
zone_email	text	YES
zone_fax	text	YES
zone_faxExt	text	YES
zone_name	text	YES
zone_organization	text	YES
zone_postalCode	text	YES
zone_state	text	YES
zone_street1	text	YES
zone_street2	text	YES
zone_street3	text	YES
zone_street4	text	YES
zone_telephone	text	YES
zone_telephoneExt	text	YES
name_server_1	text	YES
name_server_2	text	YES
name_server_3	text	YES
name_server_4	text	YES
domain_status_1	text	YES
domain_status_2	text	YES
domain_status_3	text	YES
domain_status_4	text	YES

---------------
ANALYZE TABLE whois

capturesipbee.whois	analyze	status	OK

---------------
OPTIMIZE TABLE whois

capturesipbee.whois	optimize	note	Table does not support optimize, doing recreate + analyze instead
capturesipbee.whois	optimize	error	Error writing file './capturesipbee/#sql-4742_3ab7e.frm' (Errcode: 28 "No space left on device")
capturesipbee.whois	optimize	status	Operation failed

---------------
SELECT COUNT(*) FROM whois

106352406
---------------