@Rakesh Jesadiya a million thanks for your input.
I followed the guidelines on that given blog post to create the two necessary CSV files. But I got an error message, when I tried to import the "directory_country_region.csv" file, which I created:
Error
SQL query:
INSERT INTO `directory_country_region`
VALUES (
'31', 'NG', 'AB', 'Abia'
)
MySQL said: Documentation
#1062 - Duplicate entry '31' for key 'PRIMARY'
In phpMyAdmin's "directory_country_region" table, the number 30 is the last in "region_id" column. So, I started my numbering at 31.
Please, see the "directory_country_region.csv" :
31 NG AB Abia
32 NG FC Abuja
33 NG AD Adamawa
34 NG AK Akwa Ibom
35 NG AN Anambra
36 NG BA Bauchi
37 NG BY Bayelsa
38 NG BE Benue
39 NG BO Borno
40 NG CR Cross River
41 NG DE Delta
42 NG EB Ebonyi
43 NG ED Edo
44 NG EK Ekiti
45 NG EN Enugu
46 NG GO Gombe
47 NG IM Imo
48 NG JI Jigawa
49 NG KD Kaduna
50 NG KN Kano
51 NG KT Katsina
52 NG KE Kebbi
53 NG KO Kogi
54 NG KW Kwara
55 NG LA Lagos
56 NG NA Nasarawa
57 NG NI Niger
58 NG OG Ogun
59 NG ON Ondo
60 NG OS Osun
61 NG OY Oyo
62 NG PL Plateau
63 NG RI Rivers
64 NG SO Sokoto
65 NG TA Taraba
66 NG YO Yobe
67 NG ZA Zamfara
Please, see the "directory_country_regions_name.csv" code:
en_gb 31 Abia
en_gb 32 Abuja
en_gb 33 Adamawa
en_gb 34 Akwa Ibom
en_gb 35 Anambra
en_gb 36 Bauchi
en_gb 37 Bayelsa
en_gb 38 Benue
en_gb 39 Borno
en_gb 40 Cross River
en_gb 41 Delta
en_gb 42 Ebonyi
en_gb 43 Edo
en_gb 44 Ekiti
en_gb 45 Enugu
en_gb 46 Gombe
en_gb 47 Imo
en_gb 48 Jigawa
en_gb 49 Kaduna
en_gb 50 Kano
en_gb 51 Katsina
en_gb 52 Kebbi
en_gb 53 Kogi
en_gb 54 Kwara
en_gb 55 Lagos
en_gb 56 Nasarawa
en_gb 57 Niger
en_gb 58 Ogun
en_gb 59 Ondo
en_gb 60 Osun
en_gb 61 Oyo
en_gb 62 Plateau
en_gb 63 Rivers
en_gb 64 Sokoto
en_gb 65 Taraba
en_gb 66 Yobe
en_gb 67 Zamfara
Do you or anyone else have any insight why phpMyAdmin flags 31 as a duplicate entry?
Thanks in advance for your help.
