mysql - MySQL 可以执行压缩的 SQL 文件吗？

Question

有没有办法让mysql在执行前先解压一条sql语句？

我的用例是我有一个表，我想将其移动到不同的服务器。该表的表定义和数据是 42725 行 SQL 或大约 2.5MB。

这是一个片段:

-- --------------------------------------------------------
-- Host:                         localhost
-- Server version:               5.6.24 - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL Version:             9.3.0.5107
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping structure for table us_zip_codes
DROP TABLE IF EXISTS `us_zip_codes`;
CREATE TABLE IF NOT EXISTS `us_zip_codes` (
  `zZip` varchar(5) NOT NULL DEFAULT '',
  `zCity` varchar(50) DEFAULT NULL,
  `zState` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`zZip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table us_zip_codes: ~42,725 rows (approximately)
/*!40000 ALTER TABLE `us_zip_codes` DISABLE KEYS */;
INSERT INTO `us_zip_codes` (`zZip`, `zCity`, `zState`) VALUES
    ('00501', 'HOLTSVILLE', 'NY'),
    ('00544', 'HOLTSVILLE', 'NY'),
    ('00601', 'ADJUNTAS', 'PR'),
    ('00602', 'AGUADA', 'PR'),
    ('00603', 'AGUADILLA', 'PR'),
    ('00604', 'AGUADILLA', 'PR'),
    ('00605', 'AGUADILLA', 'PR'),
    ('00606', 'MARICAO', 'PR'),
    ('00610', 'ANASCO', 'PR'),
    ('00611', 'ANGELES', 'PR'),
    ('00612', 'ARECIBO', 'PR'),
    ('00613', 'ARECIBO', 'PR'),
    ('00614', 'ARECIBO', 'PR'),
    ('00616', 'BAJADERO', 'PR'),
    ('00617', 'BARCELONETA', 'PR'),
    ('00622', 'BOQUERON', 'PR'),
    ('00623', 'CABO ROJO', 'PR'),
    ('00624', 'PENUELAS', 'PR'),
    ('00627', 'CAMUY', 'PR'),
    ('00631', 'CASTANER', 'PR'),
    ('00636', 'ROSARIO', 'PR'),
    ('00637', 'SABANA GRANDE', 'PR'),
    ('00638', 'CIALES', 'PR'),
    ('00641', 'UTUADO', 'PR'),
    ('00646', 'DORADO', 'PR'),
    ('00647', 'ENSENADA', 'PR'),
    ('00650', 'FLORIDA', 'PR'),
    ('00652', 'GARROCHALES', 'PR'),
    ('00653', 'GUANICA', 'PR'),
    ('00656', 'GUAYANILLA', 'PR'),
    ('00659', 'HATILLO', 'PR'),
    ('00660', 'HORMIGUEROS', 'PR'),
    ('00662', 'ISABELA', 'PR'),
    ('00664', 'JAYUYA', 'PR'),
    ('00667', 'LAJAS', 'PR'),
    ('00669', 'LARES', 'PR'),
    ('00670', 'LAS MARIAS', 'PR'),
    ('00674', 'MANATI', 'PR'),
    ('00676', 'MOCA', 'PR'),
    ('00677', 'RINCON', 'PR'),
    ('00678', 'QUEBRADILLAS', 'PR'),
    ('00680', 'MAYAGUEZ', 'PR'),
    ('00681', 'MAYAGUEZ', 'PR'),
    ('00682', 'MAYAGUEZ', 'PR'),
    ('00683', 'SAN GERMAN', 'PR'),
    ('00685', 'SAN SEBASTIAN', 'PR'),
    ('00687', 'MOROVIS', 'PR'),
    ('00688', 'SABANA HOYOS', 'PR'),
    ('00690', 'SAN ANTONIO', 'PR'),
    ('00692', 'VEGA ALTA', 'PR'),
    ('00693', 'VEGA BAJA', 'PR'),
    ('00694', 'VEGA BAJA', 'PR'),
    ('00698', 'YAUCO', 'PR'),
    ('00703', 'AGUAS BUENAS', 'PR'),
    ('00704', 'AGUIRRE', 'PR'),
    ('00705', 'AIBONITO', 'PR'),
    ('00707', 'MAUNABO', 'PR'),
    ('00714', 'ARROYO', 'PR'),
    ('00715', 'MERCEDITA', 'PR'),
    ('00716', 'PONCE', 'PR'),
    ('00717', 'PONCE', 'PR'),
    ('00718', 'NAGUABO', 'PR'),
    ('00719', 'NARANJITO', 'PR'),
    ('00720', 'OROCOVIS', 'PR'),
    ('00721', 'PALMER', 'PR'),
    ('00723', 'PATILLAS', 'PR'),
    ('00725', 'CAGUAS', 'PR'),
    ('00726', 'CAGUAS', 'PR'),
    ('00727', 'CAGUAS', 'PR'),
    ('00728', 'PONCE', 'PR'),
    ('00729', 'CANOVANAS', 'PR'),
    ('00730', 'PONCE', 'PR'),
    ('00731', 'PONCE', 'PR'),
    ('00732', 'PONCE', 'PR'),
    ('00733', 'PONCE', 'PR'),
    ('00734', 'PONCE', 'PR'),
    ('00735', 'CEIBA', 'PR'),
    ('00736', 'CAYEY', 'PR'),
    ('00737', 'CAYEY', 'PR'),
    ('00738', 'FAJARDO', 'PR'),
    ('00739', 'CIDRA', 'PR'),
    ('00740', 'PUERTO REAL', 'PR'),
    ('00741', 'PUNTA SANTIAGO', 'PR'),
    ('00742', 'ROOSEVELT ROADS', 'PR'),
    ('00744', 'RIO BLANCO', 'PR'),
    ('00745', 'RIO GRANDE', 'PR'),
    ('00751', 'SALINAS', 'PR'),
    ('00754', 'SAN LORENZO', 'PR'),
    ('00757', 'SANTA ISABEL', 'PR'),
    ('00765', 'VIEQUES', 'PR'),
    ('00766', 'VILLALBA', 'PR'),
    ('00767', 'YABUCOA', 'PR'),
    ('00769', 'COAMO', 'PR'),
    ('00771', 'LAS PIEDRAS', 'PR'),
    ('00772', 'LOIZA', 'PR'),
    ('00773', 'LUQUILLO', 'PR'),
    ('00775', 'CULEBRA', 'PR'),
    ('00777', 'JUNCOS', 'PR'),
    ('00778', 'GURABO', 'PR'),
    ('00780', 'COTO LAUREL', 'PR'),
    ('00782', 'COMERIO', 'PR'),
    ('00783', 'COROZAL', 'PR'),
    ('00784', 'GUAYAMA', 'PR'),
    ('00785', 'GUAYAMA', 'PR'),
    ('00786', 'LA PLATA', 'PR'),
    ('00791', 'HUMACAO', 'PR'),
    ('00792', 'HUMACAO', 'PR'),
    ('00794', 'BARRANQUITAS', 'PR'),
    ('00795', 'JUANA DIAZ', 'PR'),
    ('00801', 'ST THOMAS', 'VI'),
    ('00802', 'ST THOMAS', 'VI'),
    ('00803', 'ST THOMAS', 'VI'),
    ('00804', 'ST THOMAS', 'VI'),
    ('00805', 'ST THOMAS', 'VI'),
    ('00820', 'CHRISTIANSTED', 'VI'),
    ('00821', 'CHRISTIANSTED', 'VI'),
    ('00822', 'CHRISTIANSTED', 'VI'),
    ('00823', 'CHRISTIANSTED', 'VI'),
    ('00824', 'CHRISTIANSTED', 'VI'),
    ('00830', 'ST JOHN', 'VI'),
    ('00831', 'ST JOHN', 'VI'),
    ('00840', 'FREDERIKSTED', 'VI'),
    ('00841', 'FREDERIKSTED', 'VI'),
    ('00850', 'KINGSHILL', 'VI'),
    ('00851', 'KINGSHILL', 'VI'),
    ('00901', 'SAN JUAN', 'PR'),
    ('00902', 'SAN JUAN', 'PR'),
    ('00906', 'SAN JUAN', 'PR'),
    ('00907', 'SAN JUAN', 'PR'),
    ('00908', 'SAN JUAN', 'PR'),
    ('00909', 'SAN JUAN', 'PR'),
    ('00910', 'SAN JUAN', 'PR'),
    ('00911', 'SAN JUAN', 'PR'),
    ('00912', 'SAN JUAN', 'PR'),
    ('00913', 'SAN JUAN', 'PR'),
    ('00914', 'SAN JUAN', 'PR'),
    ('00915', 'SAN JUAN', 'PR'),
    ('00916', 'SAN JUAN', 'PR'),
    ('00917', 'SAN JUAN', 'PR'),
    ('00918', 'SAN JUAN', 'PR'),
    ('00919', 'SAN JUAN', 'PR'),
    ('00920', 'SAN JUAN', 'PR'),
    ('00921', 'SAN JUAN', 'PR'),
    ('00922', 'SAN JUAN', 'PR'),
    ('00923', 'SAN JUAN', 'PR'),
    ('00924', 'SAN JUAN', 'PR'),
    ('00925', 'SAN JUAN', 'PR'),
    ('00926', 'SAN JUAN', 'PR'),
    ('00927', 'SAN JUAN', 'PR'),
    ('00928', 'SAN JUAN', 'PR'),
    ('00929', 'SAN JUAN', 'PR'),
    ('00930', 'SAN JUAN', 'PR'),
    ('00931', 'SAN JUAN', 'PR'),
    ('00933', 'SAN JUAN', 'PR'),
    ('00934', 'FORT BUCHANAN', 'PR'),
    ('00935', 'SAN JUAN', 'PR'),
    ('00936', 'SAN JUAN', 'PR'),
    ('00937', 'SAN JUAN', 'PR'),
    ('00939', 'SAN JUAN', 'PR'),
    ('00940', 'SAN JUAN', 'PR'),
    ('00949', 'TOA BAJA', 'PR'),
    ('00950', 'TOA BAJA', 'PR'),
    ('00951', 'TOA BAJA', 'PR'),
    ('00952', 'SABANA SECA', 'PR'),
    ('00953', 'TOA ALTA', 'PR'),
    ('00954', 'TOA ALTA', 'PR'),
    ('00955', 'SAN JUAN', 'PR'),
    ('00956', 'BAYAMON', 'PR'),
    ('00957', 'BAYAMON', 'PR'),
    ('00958', 'BAYAMON', 'PR'),
    ('00959', 'BAYAMON', 'PR'),
    ('00960', 'BAYAMON', 'PR'),
    ('00961', 'BAYAMON', 'PR'),
    ('00962', 'CATANO', 'PR'),
    ('00963', 'CATANO', 'PR'),
    ('00965', 'GUAYNABO', 'PR'),
    ('00966', 'GUAYNABO', 'PR'),
    ('00968', 'GUAYNABO', 'PR'),
    ('00969', 'GUAYNABO', 'PR'),
    ('00970', 'GUAYNABO', 'PR'),
    ('00971', 'GUAYNABO', 'PR'),
    ('00975', 'SAN JUAN', 'PR'),
    ('00976', 'TRUJILLO ALTO', 'PR'),
    ('00977', 'TRUJILLO ALTO', 'PR'),
    ('00978', 'SAINT JUST', 'PR'),
    ('00979', 'CAROLINA', 'PR'),
    ('00981', 'CAROLINA', 'PR'),
    ('00982', 'CAROLINA', 'PR'),
    ('00983', 'CAROLINA', 'PR'),
    ('00984', 'CAROLINA', 'PR'),
    ('00985', 'CAROLINA', 'PR'),
    ('00986', 'CAROLINA', 'PR'),
    ('00987', 'CAROLINA', 'PR'),
    ('00988', 'CAROLINA', 'PR'),
    ('01001', 'AGAWAM', 'MA'),
    ('01002', 'AMHERST', 'MA'),
    ('01003', 'AMHERST', 'MA'),
    ('01004', 'AMHERST', 'MA'),
    ('01005', 'BARRE', 'MA'),
    ('01007', 'BELCHERTOWN', 'MA'),
    ('01008', 'BLANDFORD', 'MA'),
    ('01009', 'BONDSVILLE', 'MA'),
    ('01010', 'BRIMFIELD', 'MA'),
    ('01011', 'CHESTER', 'MA'),
    ('01012', 'CHESTERFIELD', 'MA'),
    ('01013', 'CHICOPEE', 'MA'),
    ('01014', 'CHICOPEE', 'MA'),
    ('01020', 'CHICOPEE', 'MA'),
    ('01021', 'CHICOPEE', 'MA'),
    ('01022', 'CHICOPEE', 'MA'),
    ('01026', 'CUMMINGTON', 'MA'),
    ('01027', 'EASTHAMPTON', 'MA'),
    ('01028', 'EAST LONGMEADOW', 'MA'),
    ('01029', 'EAST OTIS', 'MA'),
    ('01030', 'FEEDING HILLS', 'MA'),
    ('01031', 'GILBERTVILLE', 'MA'),
    ('01032', 'GOSHEN', 'MA'),
    ('01033', 'GRANBY', 'MA'),
    ('01034', 'GRANVILLE', 'MA'),
    ('01035', 'HADLEY', 'MA'),
    ('01036', 'HAMPDEN', 'MA'),
    ('01037', 'HARDWICK', 'MA'),
    ('01038', 'HATFIELD', 'MA'),
    ('01039', 'HAYDENVILLE', 'MA'),
    ('01040', 'HOLYOKE', 'MA'),
    ('01041', 'HOLYOKE', 'MA'),
    ('01050', 'HUNTINGTON', 'MA'),
    ('01053', 'LEEDS', 'MA'),
    ('01054', 'LEVERETT', 'MA'),
    ('01056', 'LUDLOW', 'MA'),
    ('01057', 'MONSON', 'MA'),
    ('01059', 'NORTH AMHERST', 'MA'),
    ('01060', 'NORTHAMPTON', 'MA'),
    ('01061', 'NORTHAMPTON', 'MA'),
    ('01062', 'FLORENCE', 'MA'),
    ('01063', 'NORTHAMPTON', 'MA'),
    ('01066', 'NORTH HATFIELD', 'MA'),
    ('01068', 'OAKHAM', 'MA'),
    ('01069', 'PALMER', 'MA'),
    ('01070', 'PLAINFIELD', 'MA'),
    ('01071', 'RUSSELL', 'MA'),
    ('01072', 'SHUTESBURY', 'MA'),
    ('01073', 'SOUTHAMPTON', 'MA'),
    ('01074', 'SOUTH BARRE', 'MA'),
    ('01075', 'SOUTH HADLEY', 'MA'),
    ('01077', 'SOUTHWICK', 'MA'),
    ('01079', 'THORNDIKE', 'MA'),
    ('01080', 'THREE RIVERS', 'MA'),
    ('01081', 'WALES', 'MA'),
    ('01082', 'WARE', 'MA'),
    ('01083', 'WARREN', 'MA'),
    ('01084', 'WEST CHESTERFIELD', 'MA'),
    ('01085', 'WESTFIELD', 'MA'),
    ('01086', 'WESTFIELD', 'MA'),
    ('01088', 'WEST HATFIELD', 'MA'),
    ('01089', 'WEST SPRINGFIELD', 'MA'),
    ('01090', 'WEST SPRINGFIELD', 'MA'),
    ('01092', 'WEST WARREN', 'MA'),
    ('01093', 'WHATELY', 'MA'),
    ('01094', 'WHEELWRIGHT', 'MA'),
    ('01095', 'WILBRAHAM', 'MA'),
    ('01096', 'WILLIAMSBURG', 'MA'),
    ('01097', 'WORONOCO', 'MA'),
    ('01098', 'WORTHINGTON', 'MA'),
    ('01101', 'SPRINGFIELD', 'MA'),
    ('01102', 'SPRINGFIELD', 'MA'),
    ('01103', 'SPRINGFIELD', 'MA'),
    ('01104', 'SPRINGFIELD', 'MA'),
    ('01105', 'SPRINGFIELD', 'MA'),
    ('01106', 'LONGMEADOW', 'MA'),
    ('01107', 'SPRINGFIELD', 'MA'),
    ('01108', 'SPRINGFIELD', 'MA'),
    ('01109', 'SPRINGFIELD', 'MA'),
    ('01111', 'SPRINGFIELD', 'MA'),
    ('01115', 'SPRINGFIELD', 'MA'),
    ('01116', 'LONGMEADOW', 'MA'),
    ('01118', 'SPRINGFIELD', 'MA'),
    ('01119', 'SPRINGFIELD', 'MA'),
    ('01128', 'SPRINGFIELD', 'MA'),
    ('01129', 'SPRINGFIELD', 'MA'),
    ('01133', 'SPRINGFIELD', 'MA'),
    ('01138', 'SPRINGFIELD', 'MA'),
    ('01139', 'SPRINGFIELD', 'MA'),
    ('01144', 'SPRINGFIELD', 'MA'),
    ('01151', 'INDIAN ORCHARD', 'MA'),
    ('01152', 'SPRINGFIELD', 'MA'),
    ('01195', 'SPRINGFIELD', 'MA'),
    ('01199', 'SPRINGFIELD', 'MA'),
    ('01201', 'PITTSFIELD', 'MA'),
    ('01202', 'PITTSFIELD', 'MA'),
    ('01203', 'PITTSFIELD', 'MA'),
    ('01220', 'ADAMS', 'MA'),
    ('01222', 'ASHLEY FALLS', 'MA'),
    ('01223', 'BECKET', 'MA'),
    ('01224', 'BERKSHIRE', 'MA'),
    ('01225', 'CHESHIRE', 'MA'),
    ('01226', 'DALTON', 'MA'),
    ('01227', 'DALTON', 'MA'),
    ('01229', 'GLENDALE', 'MA'),
    ('01230', 'GREAT BARRINGTON', 'MA'),
    ('01235', 'HINSDALE', 'MA'),
    ('01236', 'HOUSATONIC', 'MA'),
    ('01237', 'LANESBORO', 'MA'),
    ('01238', 'LEE', 'MA'),
    ('01240', 'LENOX', 'MA'),
    ('01242', 'LENOX DALE', 'MA'),
    ('01243', 'MIDDLEFIELD', 'MA'),
    ('01244', 'MILL RIVER', 'MA'),
    ('01245', 'MONTEREY', 'MA'),
    ('01247', 'NORTH ADAMS', 'MA'),
    ('01252', 'NORTH EGREMONT', 'MA'),
    ('01253', 'OTIS', 'MA'),
    ('01254', 'RICHMOND', 'MA'),
    ('01255', 'SANDISFIELD', 'MA'),
    ('01256', 'SAVOY', 'MA'),
    ('01257', 'SHEFFIELD', 'MA'),
    ('01258', 'SOUTH EGREMONT', 'MA'),
    ('01259', 'SOUTHFIELD', 'MA'),
    ('01260', 'SOUTH LEE', 'MA'),
    ('01262', 'STOCKBRIDGE', 'MA'),
    ('01263', 'STOCKBRIDGE', 'MA'),
    ('01264', 'TYRINGHAM', 'MA'),
    ('01266', 'WEST STOCKBRIDGE', 'MA'),
    ('01267', 'WILLIAMSTOWN', 'MA'),
    ('01270', 'WINDSOR', 'MA'),
    ('01301', 'GREENFIELD', 'MA'),
    ('01302', 'GREENFIELD', 'MA'),
    ('01330', 'ASHFIELD', 'MA'),
    ('01331', 'ATHOL', 'MA'),
    ('01337', 'BERNARDSTON', 'MA'),
    ('01338', 'BUCKLAND', 'MA'),
    ('01339', 'CHARLEMONT', 'MA'),
    ('01340', 'COLRAIN', 'MA'),
    ('01341', 'CONWAY', 'MA'),
    ('01342', 'DEERFIELD', 'MA'),
    ('01343', 'DRURY', 'MA'),
    ('01344', 'ERVING', 'MA'),
    ('01346', 'HEATH', 'MA'),
    ('01347', 'LAKE PLEASANT', 'MA'),
    ('01349', 'MILLERS FALLS', 'MA'),
    ('01350', 'MONROE BRIDGE', 'MA'),
    ('01351', 'MONTAGUE', 'MA'),
    ('01354', 'GILL', 'MA'),
    ('01355', 'NEW SALEM', 'MA'),
    ('01360', 'NORTHFIELD', 'MA'),
    ('01364', 'ORANGE', 'MA'),
    ('01366', 'PETERSHAM', 'MA'),
    ('01367', 'ROWE', 'MA'),
    ('01368', 'ROYALSTON', 'MA'),
    ('01370', 'SHELBURNE FALLS', 'MA'),
    ('01373', 'SOUTH DEERFIELD', 'MA'),
    ('01375', 'SUNDERLAND', 'MA'),
    ('01376', 'TURNERS FALLS', 'MA'),
    ('01378', 'WARWICK', 'MA'),
    ('01379', 'WENDELL', 'MA'),
    ('01380', 'WENDELL DEPOT', 'MA'),
    ('01420', 'FITCHBURG', 'MA'),
    ('01430', 'ASHBURNHAM', 'MA'),
    ('01431', 'ASHBY', 'MA'),
    ('01432', 'AYER', 'MA'),
    ('01434', 'DEVENS', 'MA'),
    ('01436', 'BALDWINVILLE', 'MA'),
    ('01438', 'EAST TEMPLETON', 'MA'),
    ('01440', 'GARDNER', 'MA'),
    ('01441', 'WESTMINSTER', 'MA'),
    ('01450', 'GROTON', 'MA'),
    ('01451', 'HARVARD', 'MA'),
    ('01452', 'HUBBARDSTON', 'MA'),
    ('01453', 'LEOMINSTER', 'MA'),
    ('01460', 'LITTLETON', 'MA'),
    ('01462', 'LUNENBURG', 'MA'),
    ('01463', 'PEPPERELL', 'MA'),
    ('01464', 'SHIRLEY', 'MA'),
    ('01467', 'STILL RIVER', 'MA'),
    ('01468', 'TEMPLETON', 'MA'),
    ('01469', 'TOWNSEND', 'MA'),
    ('01470', 'GROTON', 'MA'),
    ('01471', 'GROTON', 'MA'),
    ('01472', 'WEST GROTON', 'MA'),
    ('01473', 'WESTMINSTER', 'MA'),
    ('01474', 'WEST TOWNSEND', 'MA'),
    ('01475', 'WINCHENDON', 'MA'),
    ('01477', 'WINCHENDON SPRINGS', 'MA'),
    ('01501', 'AUBURN', 'MA'),
    ('01503', 'BERLIN', 'MA'),
    ('01504', 'BLACKSTONE', 'MA'),
    ('01505', 'BOYLSTON', 'MA'),
    ('01506', 'BROOKFIELD', 'MA'),
    ('01507', 'CHARLTON', 'MA'),
    ('01508', 'CHARLTON CITY', 'MA'),
    ('01509', 'CHARLTON DEPOT', 'MA'),
    ('01510', 'CLINTON', 'MA'),
    ('01515', 'EAST BROOKFIELD', 'MA'),
    ('01516', 'DOUGLAS', 'MA'),
    ('01517', 'EAST PRINCETON', 'MA'),
    ('01518', 'FISKDALE', 'MA'),
    ('01519', 'GRAFTON', 'MA'),
    ('01520', 'HOLDEN', 'MA'),
    ('01521', 'HOLLAND', 'MA'),
    ('01522', 'JEFFERSON', 'MA'),
    ('01523', 'LANCASTER', 'MA'),
    ('01524', 'LEICESTER', 'MA'),
    ('01525', 'LINWOOD', 'MA'),
    ('01526', 'MANCHAUG', 'MA'),
    ('01527', 'MILLBURY', 'MA'),
    ('01529', 'MILLVILLE', 'MA'),
    ('01531', 'NEW BRAINTREE', 'MA'),
    ('01532', 'NORTHBOROUGH', 'MA'),
    ('01534', 'NORTHBRIDGE', 'MA'),
    ('01535', 'NORTH BROOKFIELD', 'MA'),
    ('01536', 'NORTH GRAFTON', 'MA'),
    ('01537', 'NORTH OXFORD', 'MA'),
    ('01538', 'NORTH UXBRIDGE', 'MA'),
    ('01540', 'OXFORD', 'MA'),
    ('01541', 'PRINCETON', 'MA'),
    ('01542', 'ROCHDALE', 'MA'),
    ('01543', 'RUTLAND', 'MA'),
    ('01545', 'SHREWSBURY', 'MA'),
    ('01546', 'SHREWSBURY', 'MA'),
    ('01550', 'SOUTHBRIDGE', 'MA'),
    ('01560', 'SOUTH GRAFTON', 'MA'),
    ('01561', 'SOUTH LANCASTER', 'MA'),
    ('01562', 'SPENCER', 'MA'),
    ('01564', 'STERLING', 'MA'),
    ('01566', 'STURBRIDGE', 'MA'),
    ('01568', 'UPTON', 'MA'),
    ('01569', 'UXBRIDGE', 'MA'),
    ('01570', 'WEBSTER', 'MA'),
    ('01571', 'DUDLEY', 'MA'),
    ('01580', 'WESTBOROUGH', 'MA'),
    ('01581', 'WESTBOROUGH', 'MA'),
    ('01582', 'WESTBOROUGH', 'MA'),
    ('01583', 'WEST BOYLSTON', 'MA'),
    ('01585', 'WEST BROOKFIELD', 'MA'),
    ('01586', 'WEST MILLBURY', 'MA'),
    ('01588', 'WHITINSVILLE', 'MA'),
    ('01590', 'SUTTON', 'MA'),
    ('01601', 'WORCESTER', 'MA'),
    ('01602', 'WORCESTER', 'MA'),
    ('01603', 'WORCESTER', 'MA'),
    ('01604', 'WORCESTER', 'MA'),
    ('01605', 'WORCESTER', 'MA'),
    ('01606', 'WORCESTER', 'MA'),
    ('01607', 'WORCESTER', 'MA'),
    ('01608', 'WORCESTER', 'MA'),
    ('01609', 'WORCESTER', 'MA'),
    ('01610', 'WORCESTER', 'MA'),
    ('01611', 'CHERRY VALLEY', 'MA'),
    ('01612', 'PAXTON', 'MA'),
    ('01613', 'WORCESTER', 'MA'),
    ('01614', 'WORCESTER', 'MA'),
    ('01615', 'WORCESTER', 'MA'),
    ('01653', 'WORCESTER', 'MA'),
    ('01654', 'WORCESTER', 'MA'),
    ('01655', 'WORCESTER', 'MA'),
    ('01701', 'FRAMINGHAM', 'MA'),
    ('01702', 'FRAMINGHAM', 'MA'),
    ('01703', 'FRAMINGHAM', 'MA'),
    ('01704', 'FRAMINGHAM', 'MA'),
    ('01705', 'FRAMINGHAM', 'MA'),
    ('01718', 'VILLAGE OF NAGOG WOO', 'MA'),
    ('01719', 'BOXBOROUGH', 'MA'),
    ('01720', 'ACTON', 'MA'),
    ('01721', 'ASHLAND', 'MA'),
    ('01730', 'BEDFORD', 'MA'),
    ('01731', 'HANSCOM AFB', 'MA'),
    ('01740', 'BOLTON', 'MA'),
    ('01741', 'CARLISLE', 'MA'),
    ('01742', 'CONCORD', 'MA'),
    ('01745', 'FAYVILLE', 'MA'),
    ('01746', 'HOLLISTON', 'MA'),
    ('01747', 'HOPEDALE', 'MA'),
    ('01748', 'HOPKINTON', 'MA'),
    ('01749', 'HUDSON', 'MA'),
    ('01752', 'MARLBOROUGH', 'MA'),
    ('01754', 'MAYNARD', 'MA'),
    ('01756', 'MENDON', 'MA'),
    ('01757', 'MILFORD', 'MA'),
    ('01760', 'NATICK', 'MA'),
    ('01770', 'SHERBORN', 'MA'),
    ('01772', 'SOUTHBOROUGH', 'MA'),
    ('01773', 'LINCOLN', 'MA'),
    ('01775', 'STOW', 'MA'),
    ('01776', 'SUDBURY', 'MA'),
    ('01778', 'WAYLAND', 'MA'),
    ('01784', 'WOODVILLE', 'MA'),
    ('01801', 'WOBURN', 'MA'),
    ('01803', 'BURLINGTON', 'MA'),
    ('01805', 'BURLINGTON', 'MA'),
    ('01806', 'WOBURN', 'MA'),
    ('01807', 'WOBURN', 'MA'),
    ('01808', 'WOBURN', 'MA'),
    ('01810', 'ANDOVER', 'MA'),
    ('01812', 'ANDOVER', 'MA'),
    ('01813', 'WOBURN', 'MA'),
    ('01815', 'WOBURN', 'MA'),
    ('01821', 'BILLERICA', 'MA'),
    ('01822', 'BILLERICA', 'MA'),
    ('01824', 'CHELMSFORD', 'MA'),
    ('01826', 'DRACUT', 'MA'),
    ('01827', 'DUNSTABLE', 'MA'),
    ('01830', 'HAVERHILL', 'MA'),
    ('01831', 'HAVERHILL', 'MA'),
    ('01832', 'HAVERHILL', 'MA'),
    ('01833', 'GEORGETOWN', 'MA'),
    ('01834', 'GROVELAND', 'MA'),
    ('01835', 'HAVERHILL', 'MA'),
    ('01840', 'LAWRENCE', 'MA'),
    ('01841', 'LAWRENCE', 'MA'),
    ('01842', 'LAWRENCE', 'MA'),
    ('01843', 'LAWRENCE', 'MA'),
    ('01844', 'METHUEN', 'MA'),
    ('01845', 'NORTH ANDOVER', 'MA'),
    ('01850', 'LOWELL', 'MA'),
    ('01851', 'LOWELL', 'MA'),
    ('01852', 'LOWELL', 'MA'),
    ('01853', 'LOWELL', 'MA'),
    ('01854', 'LOWELL', 'MA'),
    ('01860', 'MERRIMAC', 'MA'),
    ('01862', 'NORTH BILLERICA', 'MA'),
    ('01863', 'NORTH CHELMSFORD', 'MA'),
    ('01864', 'NORTH READING', 'MA'),
    ('01865', 'NUTTING LAKE', 'MA'),
    ('01866', 'PINEHURST', 'MA'),
    ('01867', 'READING', 'MA'),
    ('01876', 'TEWKSBURY', 'MA'),
    ('01879', 'TYNGSBORO', 'MA'),
    ('01880', 'WAKEFIELD', 'MA'),
    ('01885', 'WEST BOXFORD', 'MA'),
    ('01886', 'WESTFORD', 'MA'),
    ('01887', 'WILMINGTON', 'MA'),
    ('01888', 'WOBURN', 'MA'),
    ('01889', 'NORTH READING', 'MA'),
    ('01890', 'WINCHESTER', 'MA'),
    ('01899', 'ANDOVER', 'MA'),
    ('01901', 'LYNN', 'MA'),
    ('01902', 'LYNN', 'MA'),
    ('01903', 'LYNN', 'MA'),
    ('01904', 'LYNN', 'MA'),
    ('01905', 'LYNN', 'MA'),
    ('01906', 'SAUGUS', 'MA'),
    ('01907', 'SWAMPSCOTT', 'MA'),
    ('01908', 'NAHANT', 'MA'),
    ('01910', 'LYNN', 'MA'),
    ('01913', 'AMESBURY', 'MA'),
    ('01915', 'BEVERLY', 'MA'),
    ('01921', 'BOXFORD', 'MA'),
    ('01922', 'BYFIELD', 'MA'),
    ('01923', 'DANVERS', 'MA'),
    ('01929', 'ESSEX', 'MA'),
    ('01930', 'GLOUCESTER', 'MA'),
    ('01931', 'GLOUCESTER', 'MA'),
    ('01936', 'HAMILTON', 'MA'),
    ('01937', 'HATHORNE', 'MA'),
    ('01938', 'IPSWICH', 'MA'),
    ('01940', 'LYNNFIELD', 'MA'),
    ('01944', 'MANCHESTER', 'MA'),
    ('01945', 'MARBLEHEAD', 'MA'),
    ('01949', 'MIDDLETON', 'MA'),
    ('01950', 'NEWBURYPORT', 'MA'),
    ('01951', 'NEWBURY', 'MA'),
    ('01952', 'SALISBURY', 'MA'),
    ('01960', 'PEABODY', 'MA'),
    ('01961', 'PEABODY', 'MA'),
    ('01965', 'PRIDES CROSSING', 'MA'),
    ('01966', 'ROCKPORT', 'MA'),
    ('01969', 'ROWLEY', 'MA'),
    ('01970', 'SALEM', 'MA'),
    ('01971', 'SALEM', 'MA'),
    ('01982', 'SOUTH HAMILTON', 'MA'),
    ('01983', 'TOPSFIELD', 'MA'),
    ('01984', 'WENHAM', 'MA'),
    ('01985', 'WEST NEWBURY', 'MA'),
    ('02018', 'ACCORD', 'MA'),
    ('02019', 'BELLINGHAM', 'MA'),
    ('02020', 'BRANT ROCK', 'MA'),
    ('02021', 'CANTON', 'MA'),
    ('02025', 'COHASSET', 'MA'),
    ('02026', 'DEDHAM', 'MA'),
    ('02027', 'DEDHAM', 'MA'),
    ('02030', 'DOVER', 'MA'),
    ('02031', 'EAST MANSFIELD', 'MA'),
    ('02032', 'EAST WALPOLE', 'MA'),
    ('02035', 'FOXBORO', 'MA'),
    ('02038', 'FRANKLIN', 'MA'),
    ('02040', 'GREENBUSH', 'MA'),
    ('02041', 'GREEN HARBOR', 'MA'),
    ('02043', 'HINGHAM', 'MA'),
    ('02044', 'HINGHAM', 'MA'),
    ('02045', 'HULL', 'MA'),
    ('02047', 'HUMAROCK', 'MA'),
    ('02048', 'MANSFIELD', 'MA'),
    ('02050', 'MARSHFIELD', 'MA'),
    ('02051', 'MARSHFIELD HILLS', 'MA'),
    ('02052', 'MEDFIELD', 'MA'),
    ('02053', 'MEDWAY', 'MA'),
    ('02054', 'MILLIS', 'MA'),
    ('02055', 'MINOT', 'MA'),
    ('02056', 'NORFOLK', 'MA'),
    ('02059', 'NORTH MARSHFIELD', 'MA'),
    ('02060', 'NORTH SCITUATE', 'MA'),
    ('02061', 'NORWELL', 'MA'),
    ('02062', 'NORWOOD', 'MA'),
    ('02065', 'OCEAN BLUFF', 'MA'),
    ('02066', 'SCITUATE', 'MA'),
    ('02067', 'SHARON', 'MA'),
    ('02070', 'SHELDONVILLE', 'MA'),
    ('02071', 'SOUTH WALPOLE', 'MA'),
    ('02072', 'STOUGHTON', 'MA'),
    ('02081', 'WALPOLE', 'MA'),
    ('02090', 'WESTWOOD', 'MA'),
    ('02093', 'WRENTHAM', 'MA'),
    ('02108', 'BOSTON', 'MA'),
    ('02109', 'BOSTON', 'MA'),
    ('02110', 'BOSTON', 'MA'),
    ('02111', 'BOSTON', 'MA'),
    ('02112', 'BOSTON', 'MA');

/*!40000 ALTER TABLE `us_zip_codes` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

压缩此数据会将 2.5mb 的文件变成 273kb。

有没有办法将压缩查询发送到 MySql？

Answer 1

不幸的是，无法将压缩查询发送到mysql服务器，

但是

对于长字符串查询，您可以增加数据包的大小。

要增加 max_allowed_pa​​cket，打开

[mysqld] 部分下的 my.ini/my.cnf。

更改完成后，您必须重新启动服务器。

它应该是下面这样的东西。你必须设置 3mb 而不是 2mb

max_allowed_packet=1048576 or 1mb