Hello Matt,
Thank you for your reply.
I dowloaded the data from https://peeringdb.com/v1/final_export.sql. This link
is available from documentation page.
In these data I realized that something were strange because few months ago I
dowloaded these data and the prefix tables beginning with "peeringdb".
I would like to use the recent data to do a statistics process and validation
using real BGP updates from RIPE/RouteView.
Using the application from indicated link I can dowload the complete data?
Thanks for any help.
Best regards,
Regivaldo Costa
Doe Sangue. Doe Vida.
De: Matt Griswold <[email protected]>
Para: Regivaldo Gomes Costa <[email protected]>
Cc: "[email protected]" <[email protected]>
Enviadas: Quinta-feira, 3 de Novembro de 2016 1:10
Assunto: Re: [PDB Tech] MySQL table description
* Regivaldo Gomes Costa <[email protected]> [161101 14:16 +0000]:
> Hello Guys,
> I have a newbie doubt about table/columns in MySQL structure.
> Please, somebody can help me in an specific information. My doubts
> are:
>
> 1. In table "peerParticipantsPublics", the column "public_id"
> matches with column "id" in table "mgmtPublics"? Recordds in table
> "mgmtPublics" are IXPs?
>
> 2. Regarding table "peerParticipantsPublics" and the column
> "participant_id", i.e., are peers with the "public_id" objects (in
> this case IXPs... I think).
That is the old schema, where are you getting it from?
To get a local copy with the new schema, you can use
https://github.com/peeringdb/peeringdb-py
Cheers
_______________________________________________
Pdb-tech mailing list
[email protected]
http://lists.peeringdb.com/cgi-bin/mailman/listinfo/pdb-tech