Ich habe das Modul bereits seit Jahren in unzähligen Shops ohne Probleme drin und ein solches Problem konnte ich noch nie feststellen. Wenn es mal nicht funktioniert, dann auch komplett nicht, weil der Provider notwendige Befehle nicht zulässt.
Also sieht der Export z.B. bei der Tabelle zones statt so (alles in einer Zeile ohne Umbrüche):
INSERT INTO `zones` VALUES (1,223,'AL','Alabama'),(2,223,'AK','Alaska'),(3,223,'AS','American Samoa'),(4,223,'AZ','Arizona'),(5,223,'AR','Arkansas'),(6,223,'AF','Armed Forces Africa'),(7,223,'AA','Armed Forces Americas'),(8,223,'AC','Armed Forces Canada'),(9,223,'AE','Armed Forces Europe'),(10,223,'AM','Armed Forces Middle East'),(11,223,'AP','Armed Forces Pacific'),(12,223,'CA','California'),(13,223,'CO','Colorado'),(14,223,'CT','Connecticut'),(15,223,'DE','Delaware'),(16,223,'DC','District of Columbia'),(17,223,'FM','Federated States Of Micronesia'),(18,223,'FL','Florida'),(19,223,'GA','Georgia'),(20,223,'GU','Guam'),(21,223,'HI','Hawaii'),(22,223,'ID','Idaho'),(23,223,'IL','Illinois'),(24,223,'IN','Indiana'),(25,223,'IA','Iowa'),(26,223,'KS','Kansas'),(27,223,'KY','Kentucky'),(28,223,'LA','Louisiana'),(29,223,'ME','Maine'),(30,223,'MH','Marshall Islands'),(31,223,'MD','Maryland'),(32,223,'MA','Massachusetts'),(33,223,'MI','Michigan'),(34,223,'MN','Minnesota'),(35,223,'MS','Mississippi'),(36,223,'MO','Missouri'),(37,223,'MT','Montana'),(38,223,'NE','Nebraska'),(39,223,'NV','Nevada'),(40,223,'NH','New Hampshire'),(41,223,'NJ','New Jersey'),(42,223,'NM','New Mexico'),(43,223,'NY','New York'),(44,223,'NC','North Carolina'),(45,223,'ND','North Dakota'),(46,223,'MP','Northern Mariana Islands'),(47,223,'OH','Ohio'),(48,223,'OK','Oklahoma'),(49,223,'OR','Oregon'),(50,223,'PW','Palau'),(51,223,'PA','Pennsylvania'),(52,223,'PR','Puerto Rico'),(53,223,'RI','Rhode Island'),(54,223,'SC','South Carolina'),(55,223,'SD','South Dakota'),(56,223,'TN','Tennessee'),(57,223,'TX','Texas'),(58,223,'UT','Utah'),(59,223,'VT','Vermont'),(60,223,'VI','Virgin Islands'),(61,223,'VA','Virginia'),(62,223,'WA','Washington'),(63,223,'WV','West Virginia'),(64,223,'WI','Wisconsin'),(65,223,'WY','Wyoming'),(66,38,'AB','Alberta'),(67,38,'BC','British Columbia'),(68,38,'MB','Manitoba'),(69,38,'NF','Newfoundland'),(70,38,'NB','New Brunswick'),(71,38,'NS','Nova Scotia'),(72,38,'NT','Northwest Territories'),(73,38,'NU','Nunavut'),(74,38,'ON','Ontario'),(75,38,'PE','Prince Edward Island'),(76,38,'QC','Quebec'),(77,38,'SK','Saskatchewan'),(78,38,'YT','Yukon Territory'),(79,81,'NI','Niedersachsen'),(80,81,'BW','Baden-Württemberg'),(81,81,'BY','Bayern'),(82,81,'BE','Berlin'),(83,81,'BR','Brandenburg'),(84,81,'HB','Bremen'),(85,81,'HH','Hamburg'),(86,81,'HE','Hessen'),(87,81,'MV','Mecklenburg-Vorpommern'),(88,81,'NW','Nordrhein-Westfalen'),(89,81,'RP','Rheinland-Pfalz'),(90,81,'SL','Saarland'),(91,81,'SN','Sachsen'),(92,81,'ST','Sachsen-Anhalt'),(93,81,'SH','Schleswig-Holstein'),(94,81,'TH','Thüringen'),(95,14,'WI','Wien'),(96,14,'NO','Niederösterreich'),(97,14,'OO','Oberösterreich'),(98,14,'SB','Salzburg'),(99,14,'KN','Kärnten'),(100,14,'ST','Steiermark'),(101,14,'TI','Tirol'),(102,14,'BL','Burgenland'),(103,14,'VB','Voralberg'),(104,204,'AG','Aargau'),(105,204,'AI','Appenzell Innerrhoden'),(106,204,'AR','Appenzell Ausserrhoden'),(107,204,'BE','Bern'),(108,204,'BL','Basel-Landschaft'),(109,204,'BS','Basel-Stadt'),(110,204,'FR','Freiburg'),(111,204,'GE','Genf'),(112,204,'GL','Glarus'),(113,204,'GR','Graubünden'),(114,204,'JU','Jura'),(115,204,'LU','Luzern'),(116,204,'NE','Neuenburg'),(117,204,'NW','Nidwalden'),(118,204,'OW','Obwalden'),(119,204,'SG','St. Gallen'),(120,204,'SH','Schaffhausen'),(121,204,'SO','Solothurn'),(122,204,'SZ','Schwyz'),(123,204,'TG','Thurgau'),(124,204,'TI','Tessin'),(125,204,'UR','Uri'),(126,204,'VD','Waadt'),(127,204,'VS','Wallis'),(128,204,'ZG','Zug'),(129,204,'ZH','Zürich'),(130,195,'ES-C','A Coruña'),(131,195,'ES-VI','Álava'),(132,195,'ES-AB','Albacete'),(133,195,'ES-A','Alicante'),(134,195,'ES-AL','Almería'),(135,195,'ES-O','Asturias'),(136,195,'ES-AV','Ávila'),(137,195,'ES-BA','Badajoz'),(138,195,'ES-PM','Balears'),(139,195,'ES-B','Barcelona'),(140,195,'ES-BU','Burgos'),(141,195,'ES-CC','Cáceres'),(142,195,'ES-CA','Cádiz'),(143,195,'ES-S','Cantabria'),(144,195,'ES-CS','Castellón'),(145,195,'ES-CE','Ceuta'),(146,195,'ES-CR','Ciudad Real'),(147,195,'ES-CO','Córdoba'),(148,195,'ES-CU','Cuenca'),(149,195,'ES-GI','Girona'),(150,195,'ES-GR','Granada'),(151,195,'ES-GU','Guadalajara'),(152,195,'ES-SS','Guipúzcoa'),(153,195,'ES-H','Huelva'),(154,195,'ES-HU','Huesca'),(155,195,'ES-J','Jaén'),(156,195,'ES-LO','La Rioja'),(157,195,'ES-GC','Las Palmas'),(158,195,'ES-LE','León'),(159,195,'ES-L','Lleida'),(160,195,'ES-LU','Lugo'),(161,195,'ES-M','Madrid'),(162,195,'ES-MA','Malaga'),(163,195,'ES-ML','Melilla'),(164,195,'ES-MU','Murcia'),(165,195,'ES-NA','Navarra'),(166,195,'ES-OR','Ourense'),(167,195,'ES-P','Palencia'),(168,195,'ES-PO','Pontevedra'),(169,195,'ES-SA','Salamanca'),(170,195,'ES-TF','Santa Cruz de Tenerife'),(171,195,'ES-SG','Segovia'),(172,195,'ES-SE','Sevilla'),(173,195,'ES-SO','Soria'),(174,195,'ES-T','Tarragona'),(175,195,'ES-TE','Teruel'),(176,195,'ES-TO','Toledo'),(177,195,'ES-V','Valencia'),(178,195,'ES-VA','Valladolid'),(179,195,'ES-BI','Vizcaya'),(180,195,'ES-ZA','Zamora'),(181,195,'ES-Z','Zaragoza'),(182,13,'NSW','New South Wales'),(183,13,'VIC','Victoria'),(184,13,'QLD','Queensland'),(185,13,'NT','Northern Territory'),(186,13,'WA','Western Australia'),(187,13,'SA','South Australia'),(188,13,'TAS','Tasmania'),(189,13,'ACT','Australian Capital Territory'),(190,153,'Northland','Northland'),(191,153,'Auckland','Auckland'),(192,153,'Waikato','Waikato'),(193,153,'Bay of Plenty','Bay of Plenty'),(194,153,'Gisborne','Gisborne'),(195,153,'Hawkes Bay','Hawkes Bay'),(196,153,'Taranaki','Taranaki'),(197,153,'Manawatu-Wanganui','Manawatu-Wanganui'),(198,153,'Wellington','Wellington'),(199,153,'West Coast','West Coast'),(200,153,'Canterbury','Canterbury'),(201,153,'Otago','Otago'),(202,153,'Southland','Southland'),(203,153,'Tasman','Tasman'),(204,153,'Nelson','Nelson'),(205,153,'Marlborough','Marlborough'),(206,30,'SP','São Paulo'),(207,30,'RJ','Rio de Janeiro'),(208,30,'PE','Pernanbuco'),(209,30,'BA','Bahia'),(210,30,'AM','Amazonas'),(211,30,'MG','Minas Gerais'),(212,30,'ES','Espirito Santo'),(213,30,'RS','Rio Grande do Sul'),(214,30,'PR','Paraná'),(215,30,'SC','Santa Catarina'),(216,30,'RG','Rio Grande do Norte'),(217,30,'MS','Mato Grosso do Sul'),(218,30,'MT','Mato Grosso'),(219,30,'GO','Goias'),(220,30,'TO','Tocantins'),(221,30,'DF','Distrito Federal'),(222,30,'RO','Rondonia'),(223,30,'AC','Acre'),(224,30,'AP','Amapa'),(225,30,'RR','Roraima'),(226,30,'AL','Alagoas'),(227,30,'CE','Ceará'),(228,30,'MA','Maranhão'),(229,30,'PA','Pará'),(230,30,'PB','Paraíba'),(231,30,'PI','Piauí'),(232,30,'SE','Sergipe'),(233,43,'I','I Región de Tarapacá'),(234,43,'II','II Región de Antofagasta'),(235,43,'III','III Región de Atacama'),(236,43,'IV','IV Región de Coquimbo'),(237,43,'V','V Región de Valaparaíso'),(238,43,'RM','Región Metropolitana'),(239,43,'VI','VI Región de L. B. O´higgins'),(240,43,'VII','VII Región del Maule'),(241,43,'VIII','VIII Región del Bío Bío'),(242,43,'IX','IX Región de la Araucanía'),(243,43,'X','X Región de los Lagos'),(244,43,'XI','XI Región de Aysén'),(245,43,'XII','XII Región de Magallanes'),(246,47,'AMA','Amazonas'),(247,47,'ANT','Antioquia'),(248,47,'ARA','Arauca'),(249,47,'ATL','Atlantico'),(250,47,'BOL','Bolivar'),(251,47,'BOY','Boyaca'),(252,47,'CAL','Caldas'),(253,47,'CAQ','Caqueta'),(254,47,'CAS','Casanare'),(255,47,'CAU','Cauca'),(256,47,'CES','Cesar'),(257,47,'CHO','Choco'),(258,47,'COR','Cordoba'),(259,47,'CUN','Cundinamarca'),(260,47,'HUI','Huila'),(261,47,'GUA','Guainia'),(262,47,'LAG','Guajira'),(263,47,'GUV','Guaviare'),(264,47,'MAG','Magdalena'),(265,47,'MET','Meta'),(266,47,'NAR','Narino'),(267,47,'NDS','Norte de Santander'),(268,47,'PUT','Putumayo'),(269,47,'QUI','Quindio'),(270,47,'RIS','Risaralda'),(271,47,'SAI','San Andres Islas'),(272,47,'SAN','Santander'),(273,47,'SUC','Sucre'),(274,47,'TOL','Tolima'),(275,47,'VAL','Valle'),(276,47,'VAU','Vaupes'),(277,47,'VIC','Vichada'),(278,73,'Et','Etranger'),(279,73,'01','Ain'),(280,73,'02','Aisne'),(281,73,'03','Allier'),(282,73,'04','Alpes de Haute Provence'),(283,73,'05','Hautes-Alpes'),(284,73,'06','Alpes Maritimes'),(285,73,'07','Ardèche'),(286,73,'08','Ardennes'),(287,73,'09','Ariège'),(288,73,'10','Aube'),(289,73,'11','Aude'),(290,73,'12','Aveyron'),(291,73,'13','Bouches-du-Rhône'),(292,73,'14','Calvados'),(293,73,'15','Cantal'),(294,73,'16','Charente'),(295,73,'17','Charente Maritime'),(296,73,'18','Cher'),(297,73,'19','Corrèze'),(298,73,'2A','Corse du Sud'),(299,73,'2B','Haute Corse'),(300,73,'21','Côte-d\'Or'),(301,73,'22','Côtes-d\'Armor'),(302,73,'23','Creuse'),(303,73,'24','Dordogne'),(304,73,'25','Doubs'),(305,73,'26','Drôme'),(306,73,'27','Eure'),(307,73,'28','Eure et Loir'),(308,73,'29','Finistère'),(309,73,'30','Gard'),(310,73,'31','Haute Garonne'),(311,73,'32','Gers'),(312,73,'33','Gironde'),(313,73,'34','Hérault'),(314,73,'35','Ille et Vilaine'),(315,73,'36','Indre'),(316,73,'37','Indre et Loire'),(317,73,'38','Isère'),(318,73,'39','Jura'),(319,73,'40','Landes'),(320,73,'41','Loir et Cher'),(321,73,'42','Loire'),(322,73,'43','Haute Loire'),(323,73,'44','Loire Atlantique'),(324,73,'45','Loiret'),(325,73,'46','Lot'),(326,73,'47','Lot et Garonne'),(327,73,'48','Lozère'),(328,73,'49','Maine et Loire'),(329,73,'50','Manche'),(330,73,'51','Marne'),(331,73,'52','Haute Marne'),(332,73,'53','Mayenne'),(333,73,'54','Meurthe et Moselle'),(334,73,'55','Meuse'),(335,73,'56','Morbihan'),(336,73,'57','Moselle'),(337,73,'58','Nièvre'),(338,73,'59','Nord'),(339,73,'60','Oise'),(340,73,'61','Orne'),(341,73,'62','Pas de Calais'),(342,73,'63','Puy-de-Dôme'),(343,73,'64','Pyrénées-Atlantiques'),(344,73,'65','Hautes-Pyrénées'),(345,73,'66','Pyrénées-Orientales'),(346,73,'67','Bas Rhin'),(347,73,'68','Haut Rhin'),(348,73,'69','Rhône'),(349,73,'70','Haute-Saône'),(350,73,'71','Saône-et-Loire'),(351,73,'72','Sarthe'),(352,73,'73','Savoie'),(353,73,'74','Haute Savoie'),(354,73,'75','Paris'),(355,73,'76','Seine Maritime'),(356,73,'77','Seine et Marne'),(357,73,'78','Yvelines'),(358,73,'79','Deux-Sèvres'),(359,73,'80','Somme'),(360,73,'81','Tarn'),(361,73,'82','Tarn et Garonne'),(362,73,'83','Var'),(363,73,'84','Vaucluse'),(364,73,'85','Vendée'),(365,73,'86','Vienne'),(366,73,'87','Haute Vienne'),(367,73,'88','Vosges'),(368,73,'89','Yonne'),(369,73,'90','Territoire de Belfort'),(370,73,'91','Essonne'),(371,73,'92','Hauts de Seine'),(372,73,'93','Seine St-Denis'),(373,73,'94','Val de Marne'),(374,73,'95','Val d\'Oise'),(375,73,'971 (DOM)','Guadeloupe'),(376,73,'972 (DOM)','Martinique'),(377,73,'973 (DOM)','Guyane'),(378,73,'974 (DOM)','Saint Denis'),(379,73,'975 (DOM)','St-Pierre de Miquelon'),(380,73,'976 (TOM)','Mayotte'),(381,73,'984 (TOM)','Terres australes et Antartiques françaises'),(382,73,'985 (TOM)','Nouvelle Calédonie'),(383,73,'986 (TOM)','Wallis et Futuna'),(384,73,'987 (TOM)','Polynésie française'),(385,99,'DL','Delhi'),(386,99,'MH','Maharashtra'),(387,99,'TN','Tamil Nadu'),(388,99,'KL','Kerala'),(389,99,'AP','Andhra Pradesh'),(390,99,'KA','Karnataka'),(391,99,'GA','Goa'),(392,99,'MP','Madhya Pradesh'),(393,99,'PY','Pondicherry'),(394,99,'GJ','Gujarat'),(395,99,'OR','Orrisa'),(396,99,'CA','Chhatisgarh'),(397,99,'JH','Jharkhand'),(398,99,'BR','Bihar'),(399,99,'WB','West Bengal'),(400,99,'UP','Uttar Pradesh'),(401,99,'RJ','Rajasthan'),(402,99,'PB','Punjab'),(403,99,'HR','Haryana'),(404,99,'CH','Chandigarh'),(405,99,'JK','Jammu & Kashmir'),(406,99,'HP','Himachal Pradesh'),(407,99,'UA','Uttaranchal'),(408,99,'LK','Lakshadweep'),(409,99,'AN','Andaman & Nicobar'),(410,99,'MG','Meghalaya'),(411,99,'AS','Assam'),(412,99,'DR','Dadra & Nagar Haveli'),(413,99,'DN','Daman & Diu'),(414,99,'SK','Sikkim'),(415,99,'TR','Tripura'),(416,99,'MZ','Mizoram'),(417,99,'MN','Manipur'),(418,99,'NL','Nagaland'),(419,99,'AR','Arunachal Pradesh'),(420,105,'AG','Agrigento'),(421,105,'AL','Alessandria'),(422,105,'AN','Ancona'),(423,105,'AO','Aosta'),(424,105,'AR','Arezzo'),(425,105,'AP','Ascoli Piceno'),(426,105,'AT','Asti'),(427,105,'AV','Avellino'),(428,105,'BA','Bari'),(429,105,'BT','Barletta-Andria-Trani'),(430,105,'BL','Belluno'),(431,105,'BN','Benevento'),(432,105,'BG','Bergamo'),(433,105,'BI','Biella'),(434,105,'BO','Bologna'),(435,105,'BZ','Bolzano'),(436,105,'BS','Brescia'),(437,105,'BR','Brindisi'),(438,105,'CA','Cagliari'),(439,105,'CL','Caltanissetta'),(440,105,'CB','Campobasso'),(441,105,'CI','Carbonia-Iglesias'),(442,105,'CE','Caserta'),(443,105,'CT','Catania'),(444,105,'CZ','Catanzaro'),(445,105,'CH','Chieti'),(446,105,'CO','Como'),(447,105,'CS','Cosenza'),(448,105,'CR','Cremona'),(449,105,'KR','Crotone'),(450,105,'CN','Cuneo'),(451,105,'EN','Enna'),(452,105,'FM','Fermo'),(453,105,'FE','Ferrara'),(454,105,'FI','Firenze'),(455,105,'FG','Foggia'),(456,105,'FC','Forlì-Cesena'),(457,105,'FR','Frosinone'),(458,105,'GE','Genova'),(459,105,'GO','Gorizia'),(460,105,'GR','Grosseto'),(461,105,'IM','Imperia'),(462,105,'IS','Isernia'),(463,105,'SP','La Spezia'),(464,105,'AQ','Aquila'),(465,105,'LT','Latina'),(466,105,'LE','Lecce'),(467,105,'LC','Lecco'),(468,105,'LI','Livorno'),(469,105,'LO','Lodi'),(470,105,'LU','Lucca'),(471,105,'MC','Macerata'),(472,105,'MN','Mantova'),(473,105,'MS','Massa-Carrara'),(474,105,'MT','Matera'),(475,105,'ME','Messina'),(476,105,'MI','Milano'),(477,105,'MO','Modena'),(478,105,'MB','Monza e della Brianza'),(479,105,'NA','Napoli'),(480,105,'NO','Novara'),(481,105,'NU','Nuoro'),(482,105,'OT','Olbia-Tempio'),(483,105,'OR','Oristano'),(484,105,'PD','Padova'),(485,105,'PA','Palermo'),(486,105,'PR','Parma'),(487,105,'PV','Pavia'),(488,105,'PG','Perugia'),(489,105,'PU','Pesaro e Urbino'),(490,105,'PE','Pescara'),(491,105,'PC','Piacenza'),(492,105,'PI','Pisa'),(493,105,'PT','Pistoia'),(494,105,'PN','Pordenone'),(495,105,'PZ','Potenza'),(496,105,'PO','Prato'),(497,105,'RG','Ragusa'),(498,105,'RA','Ravenna'),(499,105,'RC','Reggio di Calabria'),(500,105,'RE','Reggio Emilia'),(501,105,'RI','Rieti'),(502,105,'RN','Rimini'),(503,105,'RM','Roma'),(504,105,'RO','Rovigo'),(505,105,'SA','Salerno'),(506,105,'VS','Medio Campidano'),(507,105,'SS','Sassari'),(508,105,'SV','Savona'),(509,105,'SI','Siena'),(510,105,'SR','Siracusa'),(511,105,'SO','Sondrio'),(512,105,'TA','Taranto'),(513,105,'TE','Teramo'),(514,105,'TR','Terni'),(515,105,'TO','Torino'),(516,105,'OG','Ogliastra'),(517,105,'TP','Trapani'),(518,105,'TN','Trento'),(519,105,'TV','Treviso'),(520,105,'TS','Trieste'),(521,105,'UD','Udine'),(522,105,'VA','Varese'),(523,105,'VE','Venezia'),(524,105,'VB','Verbania'),(525,105,'VC','Vercelli'),(526,105,'VR','Verona'),(527,105,'VV','Vibo Valentia'),(528,105,'VI','Vicenza'),(529,105,'VT','Viterbo'),(530,107,'Niigata','Niigata'),(531,107,'Toyama','Toyama'),(532,107,'Ishikawa','Ishikawa'),(533,107,'Fukui','Fukui'),(534,107,'Yamanashi','Yamanashi'),(535,107,'Nagano','Nagano'),(536,107,'Gifu','Gifu'),(537,107,'Shizuoka','Shizuoka'),(538,107,'Aichi','Aichi'),(539,107,'Mie','Mie'),(540,107,'Shiga','Shiga'),(541,107,'Kyoto','Kyoto'),(542,107,'Osaka','Osaka'),(543,107,'Hyogo','Hyogo'),(544,107,'Nara','Nara'),(545,107,'Wakayama','Wakayama'),(546,107,'Tottori','Tottori'),(547,107,'Shimane','Shimane'),(548,107,'Okayama','Okayama'),(549,107,'Hiroshima','Hiroshima'),(550,107,'Yamaguchi','Yamaguchi'),(551,107,'Tokushima','Tokushima'),(552,107,'Kagawa','Kagawa'),(553,107,'Ehime','Ehime'),(554,107,'Kochi','Kochi'),(555,107,'Fukuoka','Fukuoka'),(556,107,'Saga','Saga'),(557,107,'Nagasaki','Nagasaki'),(558,107,'Kumamoto','Kumamoto'),(559,107,'Oita','Oita'),(560,107,'Miyazaki','Miyazaki'),(561,107,'Kagoshima','Kagoshima'),(562,129,'JOH','Johor'),(563,129,'KDH','Kedah'),(564,129,'KEL','Kelantan'),(565,129,'KL','Kuala Lumpur'),(566,129,'MEL','Melaka'),(567,129,'NS','Negeri Sembilan'),(568,129,'PAH','Pahang'),(569,129,'PRK','Perak'),(570,129,'PER','Perlis'),(571,129,'PP','Pulau Pinang'),(572,129,'SAB','Sabah'),(573,129,'SWK','Sarawak'),(574,129,'SEL','Selangor'),(575,129,'TER','Terengganu'),(576,129,'LAB','W.P.Labuan'),(577,138,'AGS','Aguascalientes'),(578,138,'BC','Baja California'),(579,138,'BCS','Baja California Sur'),(580,138,'CAM','Campeche'),(581,138,'COA','Coahuila'),(582,138,'COL','Colima'),(583,138,'CHI','Chiapas'),(584,138,'CHIH','Chihuahua'),(585,138,'DF','Distrito Federal'),(586,138,'DGO','Durango'),(587,138,'MEX','Estado de Mexico'),(588,138,'GTO','Guanajuato'),(589,138,'GRO','Guerrero'),(590,138,'HGO','Hidalgo'),(591,138,'JAL','Jalisco'),(592,138,'MCH','Michoacan'),(593,138,'MOR','Morelos'),(594,138,'NAY','Nayarit'),(595,138,'NL','Nuevo Leon'),(596,138,'OAX','Oaxaca'),(597,138,'PUE','Puebla'),(598,138,'QRO','Queretaro'),(599,138,'QR','Quintana Roo'),(600,138,'SLP','San Luis Potosi'),(601,138,'SIN','Sinaloa'),(602,138,'SON','Sonora'),(603,138,'TAB','Tabasco'),(604,138,'TMPS','Tamaulipas'),(605,138,'TLAX','Tlaxcala'),(606,138,'VER','Veracruz'),(607,138,'YUC','Yucatan'),(608,138,'ZAC','Zacatecas'),(609,160,'OSL','Oslo'),(610,160,'AKE','Akershus'),(611,160,'AUA','Aust-Agder'),(612,160,'BUS','Buskerud'),(613,160,'FIN','Finnmark'),(614,160,'HED','Hedmark'),(615,160,'HOR','Hordaland'),(616,160,'MOR','Møre og Romsdal'),(617,160,'NOR','Nordland'),(618,160,'NTR','Nord-Trøndelag'),(619,160,'OPP','Oppland'),(620,160,'ROG','Rogaland'),(621,160,'SOF','Sogn og Fjordane'),(622,160,'STR','Sør-Trøndelag'),(623,160,'TEL','Telemark'),(624,160,'TRO','Troms'),(625,160,'VEA','Vest-Agder'),(626,160,'OST','Østfold'),(627,160,'SVA','Svalbard'),(628,162,'KHI','Karachi'),(629,162,'LH','Lahore'),(630,162,'ISB','Islamabad'),(631,162,'QUE','Quetta'),(632,162,'PSH','Peshawar'),(633,162,'GUJ','Gujrat'),(634,162,'SAH','Sahiwal'),(635,162,'FSB','Faisalabad'),(636,162,'RIP','Rawal Pindi'),(637,175,'AB','Alba'),(638,175,'AR','Arad'),(639,175,'AG','Arges'),(640,175,'BC','Bacau'),(641,175,'BH','Bihor'),(642,175,'BN','Bistrita-Nasaud'),(643,175,'BT','Botosani'),(644,175,'BV','Brasov'),(645,175,'BR','Braila'),(646,175,'B','Bucuresti'),(647,175,'BZ','Buzau'),(648,175,'CS','Caras-Severin'),(649,175,'CL','Calarasi'),(650,175,'CJ','Cluj'),(651,175,'CT','Constanta'),(652,175,'CV','Covasna'),(653,175,'DB','Dimbovita'),(654,175,'DJ','Dolj'),(655,175,'GL','Galati'),(656,175,'GR','Giurgiu'),(657,175,'GJ','Gorj'),(658,175,'HR','Harghita'),(659,175,'HD','Hunedoara'),(660,175,'IL','Ialomita'),(661,175,'IS','Iasi'),(662,175,'IF','Ilfov'),(663,175,'MM','Maramures'),(664,175,'MH','Mehedint'),(665,175,'MS','Mures'),(666,175,'NT','Neamt'),(667,175,'OT','Olt'),(668,175,'PH','Prahova'),(669,175,'SM','Satu-Mare'),(670,175,'SJ','Salaj'),(671,175,'SB','Sibiu'),(672,175,'SV','Suceava'),(673,175,'TR','Teleorman'),(674,175,'TM','Timis'),(675,175,'TL','Tulcea'),(676,175,'VS','Vaslui'),(677,175,'VL','Valcea'),(678,175,'VN','Vrancea'),(679,193,'WP','Western Cape'),(680,193,'GP','Gauteng'),(681,193,'KZN','Kwazulu-Natal'),(682,193,'NC','Northern-Cape'),(683,193,'EC','Eastern-Cape'),(684,193,'MP','Mpumalanga'),(685,193,'NW','North-West'),(686,193,'FS','Free State'),(687,193,'NP','Northern Province'),(688,203,'K','Blekinge'),(689,203,'W','Dalarna'),(690,203,'I','Gotland'),(691,203,'X','Gävleborg'),(692,203,'N','Halland'),(693,203,'Z','Jämtland'),(694,203,'F','Jönköping'),(695,203,'H','Kalmar'),(696,203,'G','Kronoberg'),(697,203,'BD','Norrbotten'),(698,203,'T','Örebro'),(699,203,'E','Östergötland'),(700,203,'M','Skåne'),(701,203,'AB','Stockholm'),(702,203,'D','Södermanland'),(703,203,'C','Uppsala'),(704,203,'S','Värmland'),(705,203,'AC','Västerbotten'),(706,203,'Y','Västernorrland'),(707,203,'U','Västmanland'),(708,203,'O','Västra Götaland'),(709,215,'AA','Adana'),(710,215,'AD','Adiyaman'),(711,215,'AF','Afyonkarahisar'),(712,215,'AG','Agri'),(713,215,'AK','Aksaray'),(714,215,'AM','Amasya'),(715,215,'AN','Ankara'),(716,215,'AL','Antalya'),(717,215,'AR','Ardahan'),(718,215,'AV','Artvin'),(719,215,'AY','Aydin'),(720,215,'BK','Balikesir'),(721,215,'BR','Bartin'),(722,215,'BM','Batman'),(723,215,'BB','Bayburt'),(724,215,'BC','Bilecik'),(725,215,'BG','Bingöl'),(726,215,'BT','Bitlis'),(727,215,'BL','Bolu'),(728,215,'BD','Burdur'),(729,215,'BU','Bursa'),(730,215,'CK','Çanakkale'),(731,215,'CI','Çankiri'),(732,215,'CM','Çorum'),(733,215,'DN','Denizli'),(734,215,'DY','Diyarbakir'),(735,215,'DU','Düzce'),(736,215,'ED','Edirne'),(737,215,'EG','Elazig'),(738,215,'EN','Erzincan'),(739,215,'EM','Erzurum'),(740,215,'ES','Eskisehir'),(741,215,'GA','Gaziantep'),(742,215,'GI','Giresun'),(743,215,'GU','Gümüshane'),(744,215,'HK','Hakkari'),(745,215,'HT','Hatay'),(746,215,'IG','Igdir'),(747,215,'IP','Isparta'),(748,215,'IB','Istanbul'),(749,215,'IZ','Izmir'),(750,215,'KM','Kahramanmaras'),(751,215,'KB','Karabük'),(752,215,'KR','Karaman'),(753,215,'KA','Kars'),(754,215,'KS','Kastamonu'),(755,215,'KY','Kayseri'),(756,215,'KI','Kilis'),(757,215,'KK','Kirikkale'),(758,215,'KL','Kirklareli'),(759,215,'KH','Kirsehir'),(760,215,'KC','Kocaeli'),(761,215,'KO','Konya'),(762,215,'KU','Kütahya'),(763,215,'ML','Malatya'),(764,215,'MN','Manisa'),(765,215,'MR','Mardin'),(766,215,'IC','Mersin'),(767,215,'MG','Mugla'),(768,215,'MS','Mus'),(769,215,'NV','Nevsehir'),(770,215,'NG','Nigde'),(771,215,'OR','Ordu'),(772,215,'OS','Osmaniye'),(773,215,'RI','Rize'),(774,215,'SK','Sakarya'),(775,215,'SS','Samsun'),(776,215,'SU','Sanliurfa'),(777,215,'SI','Siirt'),(778,215,'SP','Sinop'),(779,215,'SR','Sirnak'),(780,215,'SV','Sivas'),(781,215,'TG','Tekirdag'),(782,215,'TT','Tokat'),(783,215,'TB','Trabzon'),(784,215,'TC','Tunceli'),(785,215,'US','Usak'),(786,215,'VA','Van'),(787,215,'YL','Yalova'),(788,215,'YZ','Yozgat'),(789,215,'ZO','Zonguldak'),(790,229,'AM','Amazonas'),(791,229,'AN','Anzoátegui'),(792,229,'AR','Aragua'),(793,229,'AP','Apure'),(794,229,'BA','Barinas'),(795,229,'BO','Bolívar'),(796,229,'CA','Carabobo'),(797,229,'CO','Cojedes'),(798,229,'DA','Delta Amacuro'),(799,229,'DC','Distrito Capital'),(800,229,'FA','Falcón'),(801,229,'GA','Guárico'),(802,229,'GU','Guayana'),(803,229,'LA','Lara'),(804,229,'ME','Mérida'),(805,229,'MI','Miranda'),(806,229,'MO','Monagas'),(807,229,'NE','Nueva Esparta'),(808,229,'PO','Portuguesa'),(809,229,'SU','Sucre'),(810,229,'TA','Táchira'),(811,229,'TU','Trujillo'),(812,229,'VA','Vargas'),(813,229,'YA','Yaracuy'),(814,229,'ZU','Zulia'),(815,222,'BAS','Bath and North East Somerset'),(816,222,'BDF','Bedfordshire'),(817,222,'WBK','Berkshire'),(818,222,'BBD','Blackburn with Darwen'),(819,222,'BPL','Blackpool'),(820,222,'BMH','Bournemouth'),(821,222,'BNH','Brighton and Hove'),(822,222,'BST','Bristol'),(823,222,'BKM','Buckinghamshire'),(824,222,'CAM','Cambridgeshire'),(825,222,'CHS','Cheshire'),(826,222,'CON','Cornwall'),(827,222,'DUR','County Durham'),(828,222,'CMA','Cumbria'),(829,222,'DAL','Darlington'),(830,222,'DER','Derby'),(831,222,'DBY','Derbyshire'),(832,222,'DEV','Devon'),(833,222,'DOR','Dorset'),(834,222,'ERY','East Riding of Yorkshire'),(835,222,'ESX','East Sussex'),(836,222,'ESS','Essex'),(837,222,'GLS','Gloucestershire'),(838,222,'LND','Greater London'),(839,222,'MAN','Greater Manchester'),(840,222,'HAL','Halton'),(841,222,'HAM','Hampshire'),(842,222,'HPL','Hartlepool'),(843,222,'HEF','Herefordshire'),(844,222,'HRT','Hertfordshire'),(845,222,'KHL','Hull'),(846,222,'IOW','Isle of Wight'),(847,222,'KEN','Kent'),(848,222,'LAN','Lancashire'),(849,222,'LCE','Leicester'),(850,222,'LEC','Leicestershire'),(851,222,'LIN','Lincolnshire'),(852,222,'LUT','Luton'),(853,222,'MDW','Medway'),(854,222,'MER','Merseyside'),(855,222,'MDB','Middlesbrough'),(856,222,'MIK','Milton Keynes'),(857,222,'NFK','Norfolk'),(858,222,'NTH','Northamptonshire'),(859,222,'NEL','North East Lincolnshire'),(860,222,'NLN','North Lincolnshire'),(861,222,'NSM','North Somerset'),(862,222,'NBL','Northumberland'),(863,222,'NYK','North Yorkshire'),(864,222,'NGM','Nottingham'),(865,222,'NTT','Nottinghamshire'),(866,222,'OXF','Oxfordshire'),(867,222,'PTE','Peterborough'),(868,222,'PLY','Plymouth'),(869,222,'POL','Poole'),(870,222,'POR','Portsmouth'),(871,222,'RCC','Redcar and Cleveland'),(872,222,'RUT','Rutland'),(873,222,'SHR','Shropshire'),(874,222,'SOM','Somerset'),(875,222,'STH','Southampton'),(876,222,'SOS','Southend-on-Sea'),(877,222,'SGC','South Gloucestershire'),(878,222,'SYK','South Yorkshire'),(879,222,'STS','Staffordshire'),(880,222,'STT','Stockton-on-Tees'),(881,222,'STE','Stoke-on-Trent'),(882,222,'SFK','Suffolk'),(883,222,'SRY','Surrey'),(884,222,'SWD','Swindon'),(885,222,'TFW','Telford and Wrekin'),(886,222,'THR','Thurrock'),(887,222,'TOB','Torbay'),(888,222,'TYW','Tyne and Wear'),(889,222,'WRT','Warrington'),(890,222,'WAR','Warwickshire'),(891,222,'WMI','West Midlands'),(892,222,'WSX','West Sussex'),(893,222,'WYK','West Yorkshire'),(894,222,'WIL','Wiltshire'),(895,222,'WOR','Worcestershire'),(896,222,'YOR','York'),(897,44,'BJ','Beijing Municipality'),(898,44,'TJ','Tianjin Municipality'),(899,44,'HE','Hebei Province'),(900,44,'SX','Shanxi Province'),(901,44,'NM','Inner Mongolia Autonomous Region'),(902,44,'LN','Liaoning Province'),(903,44,'JL','Jilin Province'),(904,44,'HL','Heilongjiang Province'),(905,44,'SH','Shanghai Municipality'),(906,44,'JS','Jiangsu Province'),(907,44,'ZJ','Zhejiang Province'),(908,44,'AH','Anhui Province'),(909,44,'FJ','Fujian Province'),(910,44,'JX','Jiangxi Province'),(911,44,'SD','Shandong Province'),(912,44,'HA','Henan Province'),(913,44,'HB','Hubei Province'),(914,44,'HN','Hunan Province'),(915,44,'GD','Guangdong Province'),(916,44,'GX','Guangxi Zhuang Autonomous Region'),(917,44,'HI','Hainan Province'),(918,44,'CQ','Chongqing Municipality'),(919,44,'SC','Sichuan Province'),(920,44,'GZ','Guizhou Province'),(921,44,'YN','Yunnan Province'),(922,44,'XZ','Tibet Autonomous Region'),(923,44,'SN','Shaanxi Province'),(924,44,'GS','Gansu Province'),(925,44,'QH','Qinghai Province'),(926,44,'NX','Ningxia Hui Autonomous Region'),(927,44,'XJ','Xinjiang Uyghur Autonomous Region'),(928,44,'HK','Hong Kong Special Administrative Region'),(929,44,'MC','Macau Special Administrative Region'),(930,44,'TW','Taiwan Province'),(931,10,'CF','Ciudad de Buenos Aires (Distrito Federal)'),(932,10,'BA','Buenos Aires'),(933,10,'CT','Catamarca'),(934,10,'CC','Chaco'),(935,10,'CH','Chubut'),(936,10,'CD','Córdoba'),(937,10,'CR','Corrientes'),(938,10,'ER','Entre Ríos'),(939,10,'FO','Formosa'),(940,10,'JY','Jujuy'),(941,10,'LP','La Pampa'),(942,10,'LR','La Rioja'),(943,10,'MZ','Mendoza'),(944,10,'MN','Misiones'),(945,10,'NQ','Neuquén'),(946,10,'RN','Río Negro'),(947,10,'SA','Salta'),(948,10,'SJ','San Juan'),(949,10,'SL','San Luis'),(950,10,'SC','Santa Cruz'),(951,10,'SF','Santa Fe'),(952,10,'SE','Santiago del Estero'),(953,10,'TF','Tierra del Fuego'),(954,10,'TM','Tucumán'),(955,100,'AC','Aceh'),(956,100,'BA','Bali'),(957,100,'BB','Babel'),(958,100,'BT','Banten'),(959,100,'BE','Bengkulu'),(960,100,'JT','Jateng'),(961,100,'KT','Kalteng'),(962,100,'ST','Sulteng'),(963,100,'JI','Jatim'),(964,100,'KI','Kaltim'),(965,100,'NT','NTT'),(966,100,'GO','Gorontalo'),(967,100,'JK','DKI'),(968,100,'JA','Jambi'),(969,100,'LA','Lampung'),(970,100,'MA','Maluku'),(971,100,'KU','Kaltara'),(972,100,'MU','Malut'),(973,100,'SA','Sulut'),(974,100,'SU','Sumut'),(975,100,'PA','Papua'),(976,100,'RI','Riau'),(977,100,'KR','Kepri'),(978,100,'SG','Sultra'),(979,100,'KS','Kalsel'),(980,100,'SN','Sulsel'),(981,100,'SS','Sumsel'),(982,100,'JB','Jabar'),(983,100,'KB','Kalbar'),(984,100,'NB','NTB'),(985,100,'PB','Papuabarat'),(986,100,'SR','Sulbar'),(987,100,'SB','Sumbar'),(988,100,'YO','DIY'),(989,209,'10','Bangkok'),(990,209,'37','Amnat Charoen'),(991,209,'15','Ang Thong'),(992,209,'38','Bueng Kan'),(993,209,'31','Buriram'),(994,209,'24','Chachoengsao'),(995,209,'18','Chai Nat'),(996,209,'36','Chaiyaphum'),(997,209,'22','Chanthaburi'),(998,209,'50','Chiang Mai'),(999,209,'57','Chiang Rai'),(1000,209,'20','Chonburi'),(1001,209,'86','Chumphon'),(1002,209,'46','Kalasin'),(1003,209,'62','Kamphaeng Phet'),(1004,209,'71','Kanchanaburi'),(1005,209,'40','Khon Kaen'),(1006,209,'81','Krabi'),(1007,209,'52','Lampang'),(1008,209,'51','Lamphun'),(1009,209,'42','Loei Province'),(1010,209,'16','Lopburi Province'),(1011,209,'58','Mae Hong Son'),(1012,209,'44','Maha Sarakham'),(1013,209,'49','Mukdahan'),(1014,209,'26','Nakhon Nayok'),(1015,209,'73','Nakhon Pathom'),(1016,209,'48','Nakhon Phanom'),(1017,209,'30','Nakhon Ratchasima'),(1018,209,'60','Nakhon Sawan'),(1019,209,'80','Nakhon Si Thammarat'),(1020,209,'55','Nan'),(1021,209,'96','Narathiwat'),(1022,209,'39','Nong Bua Lam Phu'),(1023,209,'43','Nong Khai'),(1024,209,'12','Nonthaburi'),(1025,209,'13','Pathum Thani'),(1026,209,'94','Pattani'),(1027,209,'82','Phang Nga'),(1028,209,'93','Phatthalung'),(1029,209,'56','Phayao'),(1030,209,'67','Phetchabun'),(1031,209,'76','Phetchaburi'),(1032,209,'66','Phichit'),(1033,209,'65','Phitsanulok'),(1034,209,'14','Phra Nakhon Si Ayutthaya'),(1035,209,'54','Phrae'),(1036,209,'83','Phuket'),(1037,209,'25','Prachinburi'),(1038,209,'77','Prachuap Khiri Khan'),(1039,209,'85','Ranong'),(1040,209,'70','Ratchaburi'),(1041,209,'21','Rayong'),(1042,209,'45','Roi Et'),(1043,209,'27','Sa Kaeo'),(1044,209,'47','Sakon Nakhon'),(1045,209,'11','Samut Prakan'),(1046,209,'74','Samut Sakhon'),(1047,209,'75','Samut Songkhram'),(1048,209,'19','Saraburi'),(1049,209,'91','Satun'),(1050,209,'17','Sing Buri'),(1051,209,'33','Sisaket'),(1052,209,'90','Songkhla'),(1053,209,'64','Sukhothai'),(1054,209,'72','Suphan Buri'),(1055,209,'84','Surat Thani'),(1056,209,'32','Surin'),(1057,209,'63','Tak'),(1058,209,'92','Trang'),(1059,209,'23','Trat'),(1060,209,'34','Ubon Ratchathani'),(1061,209,'41','Udon Thani'),(1062,209,'61','Uthai Thani'),(1063,209,'53','Uttaradit'),(1064,209,'95','Yala'),(1065,209,'35','Yasothon');
bei dir nur so aus:
INSERT INTO `zones` VALUES (1,223,'AL','Alabama');
Ich hänge mal in
Beitrag 1 eine andere Version an, bei der man noch die Optionen
--complete-insert und
--extended-insert steuern kann. Erklärung der Optionen sind im Modul.
Einfach nur das neue Modul hochladen und dann Backup, Deinstallieren, Installieren und Wiederherstellen ... Fertig.
MfG Hetfield