The data is for your own private use only.
It is available here for more complicated analysis of the data.
Pick a realm...
Plato #1
Solon #2
Orichalc #3
Draconis #4
Thera #5
Critias #6
Hermocrates #7
Poseidon #9
Atlas #10
Crantor #11
Persephone #12
Strabo #13
Posidonius #14
Meropis #15
Zoticus #16
Philo #17
Bensalem #18
Atland #19
Lemuria (레뮤리아) #20
Blavatsky #21
Cayce #22
Tartessos #23
Spartel #24
Flores #25
Doggerland #26
Sargasso #27
Aztlan #28
Hyperborea #29
Ancomah #30
Lotus #31
Pearl #32
Emerald #33
Sapphire #34
Bijoux #35
Diamant #36
Jet #37
Topaz #38
Quartz #39
Beryl #40
Onyx #41
Granite #42
Jasper #43
Alexandrite #44
Bloodstone #45
Blutjaspis #46
Aquamarine (아쿠아마린) #47
Swan #48
Orchidée #50
Curlew #51
Hilaire #52
Hydra #53
Flame #54
Arrow #55
Flèche #56
Pfeil #57
Tempest #58
Staff (스태프) #59
Rubicon #60
Lena #61
Mission #62
Canary #63
Kyll #64
Thérain #65
Sparviere #66
Briljant #67
Anaconda #68
Akvamarin #69
Zümrüt #70
Stormvogel #71
Orinoco #72
Howard #73
Potomac #74
Serpiente #75
Couleuvre #76
Colubro #77
Folsom #78
Seine #79
Harrison #80
Klamath #81
Guadalquivir #82
Mittelmeer #83
Deschutes #84
Garonne #85
Tualatin (툴라틴) #86
Jarama #87
Tagliamento #88
Filyos #89
Nehalem #90
Nervión #91
Petaluma #92
Rhône (론) #93
Merced #94
Tajo #95
Kızılırmak #96
Ravina #97
Saratoga #98
Jörmungand #99
Moselle #100
Ticonderoga #101
Carillon #102
Merrimack #103
Menorca #104
Delle #105
Santorini #106
Minos #107
Pasiphae #108
Asterion #109
Theseus (테세우스) #110
Knossos #111
Labrys #112
Minotaur #113
Ariadne #114
Phaedra #115
Androgeus #116
Cerberus #117
Cercyon #118
Cleidemus #119
Daedalus #120
Deucalion #121
Euripides #122
Erinyes #123
Icarus (이카루스) #124
Dionysius #125
Hephaestus #126
Hippolyta #127
Hippolytus #128
Labyrinth #129
Lapith #130
Pirithous #131
Lycomedes #132
Melanippus #133
Perigune #134
Mnestheus #135
Nereid #136
Oenopion #137
Ovid #138
Metamorphoses #139
Pallas #140
Seneca #141
Aegeus #142
Pausanias #143
Hades #144
Philochorus #145
Pittheus #146
Plutarch #147
Procrustes #148
Lannister #149
Sciron #150
Pallantides #151
Sinis #152
Skyros #153
Софо́кл #154
Staphylos #155
Tartarus #156
Elysium #157
Taurus #158
Troezen #159
Utopia #160
Hyboria #161
Атлант #162
Leucippe #163
Gadeirus #164
Eumelus #165
Nettuno #166
Evaemon #167
Autochthon #168
Elasippus #169
Mestor #170
Azaes #171
Diaprepes #172
Neptune #173
Triton #174
Hippocampus #175
Hellanicus #176
Зевс #177
Proclus #178
Theopompus #179
Marcellinus #180
Timagenes #181
Левиафан #182
Tertullian #183
Arnobius #184
Cosmas #185
Mu #186
Посейдон #187
Thule #188
Akasha #189
소크라테스 #190
탄탈루스 #191
Ligustinus #192
Hinojos #193
Sundaland #194
Eden #195
Arcadia #196
Киклопы #197
Columbus #198
Theodosia #199
Epervier #200
Celeste #201
Cyclops #202
Tlaloc #203
Hurakan #204
Mananann #205
Medusa #206
헥토르 #207
Юпитер #208
Ao Kin #209
Vulcain #210
Fafnir #211
Ignis #212
シリウス #213
Daucina #214
Ahti #215
Jormungand #216
Behemoth #217
Bacchus #218
아킬레스 #219
Нептун #220
Pégaso #221
プロシオン #222
Celestia #223
Jason #224
Pompey #225
Delphinus #226
Oceanus #227
Nirvana #228
亚特拉斯 #229
Apollon #230
Leviathan #231
Kara Korku #232
Namaka #233
Varuna #234
Gümüş Kanat #235
伽狄鲁斯 #236
Ryujin #237
Lympha #238
Tatzelwurm #239
Amathaunta #240
Nammu #241
Tiamat #242
Bahamut #243
伊菲蒙 #244
曼尼修斯 #245
Elisium #246
Nixie #247
Марс #248
Aegeus #250
Poseidon #251
Cadmus #252
Heracles #253
Pausanias #254
Zeus #255
Hera #256
Aphrodite #257
Artemis #258
Ares #259
Valyrian #260
斯巴达 #261
卡迪亚 #262
트라케 #263
ジェネシス #264
Pittheus #265
Athena #266
Corinth #267
Westeros #268
Apagra #269
Pherox #270
Elippi #271
Demypes #272
Astamis #273
Maeon #274
Olympias #275
Prometheus #276
Otonia #277
Прометей #278
Сократ #279
Akrai #280
Isparta #281
Chios #282
Corcyra #283
Delphi #284
Golgi #285
Megara #286
Naxos #287
Sidon #288
Herodotus #289
Tripoli #290
Sicyon #291
Kavala #292
Pyrgos #293
Eleusis #294
Амариллис #295
雅辛托斯 #296
Narciso #297
Peony #298
Dafne #299
Palaemon #300
Argus #301
Telamon #302
Kadmus #303
Erisbe #305
Remiel #306
Telantes #307
Bekto #308
Asgard #309
伊特加 #310
Bilmece #311
Альфа #312
Ortson #313
Deralin #314
Podiana #315
Valhalla #316
Salbei #317
Tethys #318
Phorcys #319
Pontus #320
Mist #321
Sabra #322
Mamre #323
Luz #324
Gibia #325
Hinode #326



Info about the numbers in the downloads.
Gender column is the family...
0 Corleone
1 Tattaglia
2 Stracci
3 Barzini
4 Cuneo



To load With command line...
  1. To load: mysql -u root -p mysql <....sql
  2. To dump back into csv: mysqldump -T /tmp/ -u root -p mysql mapbyid_?? users alliances
Change "root" + "mysql" to whatever the user name/database name is.
And is whatever the MapId number is.


With GUI in windows...
  1. Download mysql (for windows, click on the "development" tab and use >=v5.5 the older versions have problems with too many opened files.)
  2. For windows: Download HeidiSql
  3. Make a new session, you only need to set the password on this screen if mysql was installed on the same computer.
  4. In HeidiSQL click:
    1. Select a database on the left, "mysql" is usually there.
    2. Import -> Load sql data -> pick the .sql file that you had extracted
    3. Tools -> Preferences -> export -> change "fields separated by" to , (comma). Change "Limit Copy as CSV Copy" to 50MB
    4. Tools -> Preferences -> data -> change "Number of rows displayed in data tab" to "1000000"
    5. Click the "Refresh" icon, then select the table in the database, which is either users,alliances,map,mapbyid_???
    6. Go to the "data" tab, press ctrl-end to load all the data into the grid.
    7. Export -> export grid

Foreign characters
To get the foreign characters to appear correctly for some games. Before running any queries, use...
set character_set_connection = 'latin1';
set character_set_client = 'latin1';
set character_set_results = 'latin1';

Video instructions here