<<< Chronological >>> Author Index    Subject Index <<< Threads >>>

Announcement: traceroute DB changed.

  • To:
  • From: "Henk Uijterwaal (RIPE NCC)" < >
  • Date: Tue, 11 May 2004 11:54:12 +0200 (CEST)

Dear all,

This is only relevant for those of you mirroring our database with TTM
traceroute data for IPv4.  All others can skip this mail.

As you know, a daily dump of the IPv4 traceroute DB is available at

  ftp://ftp.ripe.net/test-traffic/mysql/sqldump.gz

Over the years, this file grown to more than 1 Gb.  This caused problems
with copying as well as with our internal operations.  As of tomorrow, May
12, the file will therefor be split into (currently 5)  files of at most
250 Mb. These will be called:

  ftp://ftp.ripe.net/test-traffic/mysql/sqldump.0.aa
                                        sqldump.0.ab
                                        ...
                                        sqldump.0.ae

(with a 6th file to be added as soon as sqldump.0.ae reaches 250 Mb).

To import the file into a mysql DB, you probably did something like:

  $ gzip -dc sqldump.gz | mysql import

This has to be replaced by

  $ cat sqldump.0.* | gzip -d | mysql import

Note that you have to copy all 5 files every time you copy the data base,
even though the size of the files appears to be the same.

Please mail tt-ops@localhost with any questions that you may have,

Henk

------------------------------------------------------------------------------
Henk Uijterwaal                           Email: henk.uijterwaal(at)ripe.net
RIPE Network Coordination Centre          http://www.amsterdamned.org/~henk
P.O.Box 10096          Singel 258         Phone: +31.20.5354414
1001 EB Amsterdam      1016 AB Amsterdam  Fax: +31.20.5354445
The Netherlands        The Netherlands    Mobile: +31.6.55861746
------------------------------------------------------------------------------

Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.                          (David Brent).



<<< Chronological >>> Author    Subject <<< Threads >>>