<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1478177970466_59022"><span id="yui_3_16_0_ym19_1_1478177970466_59023">Hello Matt,</span></div><div id="yui_3_16_0_ym19_1_1478177970466_59024"><br clear="none" id="yui_3_16_0_ym19_1_1478177970466_59025"></div><div id="yui_3_16_0_ym19_1_1478177970466_59026">Thank you for your reply.</div><div id="yui_3_16_0_ym19_1_1478177970466_59027"><br clear="none" id="yui_3_16_0_ym19_1_1478177970466_59028"></div><div id="yui_3_16_0_ym19_1_1478177970466_59029">I dowloaded the data from https://peeringdb.com/v1/final_export.sql. This link is available from documentation page.</div><div id="yui_3_16_0_ym19_1_1478177970466_59030"><br clear="none" id="yui_3_16_0_ym19_1_1478177970466_59031"></div><div id="yui_3_16_0_ym19_1_1478177970466_59032">In these data I realized that something were strange because few months ago I dowloaded these data and the prefix tables beginning with "peeringdb".</div><div id="yui_3_16_0_ym19_1_1478177970466_59033"><br clear="none" id="yui_3_16_0_ym19_1_1478177970466_59034"></div><div id="yui_3_16_0_ym19_1_1478177970466_59035">I would like to use the recent data to do a statistics process and validation using real BGP updates from RIPE/RouteView.</div><div id="yui_3_16_0_ym19_1_1478177970466_59036"><br clear="none" id="yui_3_16_0_ym19_1_1478177970466_59037"></div><div id="yui_3_16_0_ym19_1_1478177970466_59038">Using the application from indicated link I can dowload the complete data? </div><div id="yui_3_16_0_ym19_1_1478177970466_59039"><br clear="none" id="yui_3_16_0_ym19_1_1478177970466_59040"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1478177970466_59041">Thanks for any help.</div><div id="yui_3_16_0_ym19_1_1478177970466_59042"><br clear="none" id="yui_3_16_0_ym19_1_1478177970466_59043"></div><div id="yui_3_16_0_ym19_1_1478177970466_59044">Best regards, </div><div id="yui_3_16_0_ym19_1_1478177970466_59045"><br clear="none" id="yui_3_16_0_ym19_1_1478177970466_59046"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1478177970466_59047">Regivaldo Costa<br clear="none" id="yui_3_16_0_ym19_1_1478177970466_59048"><em id="yui_3_16_0_ym19_1_1478177970466_59049"><font color="#c00000" id="yui_3_16_0_ym19_1_1478177970466_59050">Doe Sangue. Doe Vida.</font></em></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1478177970466_62457"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1478177970466_62461" style="display: block;"> <div style="font-family: HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;" id="yui_3_16_0_ym19_1_1478177970466_62460"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1478177970466_62459"> <div dir="ltr" id="yui_3_16_0_ym19_1_1478177970466_62458"> <font size="2" face="Arial" id="yui_3_16_0_ym19_1_1478177970466_62463"> <hr size="1"> <b><span style="font-weight:bold;">De:</span></b> Matt Griswold <grizz@20c.com><br> <b><span style="font-weight: bold;">Para:</span></b> Regivaldo Gomes Costa <regivaldocosta@yahoo.com.br> <br><b><span style="font-weight: bold;">Cc:</span></b> "pdb-tech@lists.peeringdb.com" <pdb-tech@lists.peeringdb.com><br> <b><span style="font-weight: bold;">Enviadas:</span></b> Quinta-feira, 3 de Novembro de 2016 1:10<br> <b><span style="font-weight: bold;">Assunto:</span></b> Re: [PDB Tech] MySQL table description<br> </font> </div> <div class="y_msg_container"><br>* Regivaldo Gomes Costa <<a shape="rect" ymailto="mailto:regivaldocosta@yahoo.com.br" href="mailto:regivaldocosta@yahoo.com.br">regivaldocosta@yahoo.com.br</a>> [161101 14:16 +0000]:<div class="yqt0924946784" id="yqtfd70258"><br clear="none">> Hello Guys,<br clear="none">> I have a newbie doubt about table/columns in MySQL structure.<br clear="none">> Please, somebody can help me in an specific information. My doubts<br clear="none">> are:<br clear="none">><br clear="none">> 1. In table "peerParticipantsPublics", the column "public_id"<br clear="none">> matches with column "id" in table "mgmtPublics"? Recordds in table<br clear="none">> "mgmtPublics" are IXPs?<br clear="none">><br clear="none">> 2. Regarding table "peerParticipantsPublics" and the column<br clear="none">> "participant_id", i.e., are peers with the "public_id" objects (in<br clear="none">> this case IXPs... I think).</div><br clear="none">That is the old schema, where are you getting it from?<br clear="none"><br clear="none">To get a local copy with the new schema, you can use<br clear="none"><a shape="rect" href="https://github.com/peeringdb/peeringdb-py" target="_blank">https://github.com/peeringdb/peeringdb-py</a><br clear="none"><br clear="none">Cheers<br><br></div> </div> </div> </div></div></body></html>