RBePJTRK

1#!/bin/bash
2
3MYSQLuser=Box4S
4MYSQLpassword=zgJnwauCAsHrR6JB*
5
6#create databse if not existing
7echo "CREATE DATABASE IF NOT EXISTS Box4s_db" | mysql -u"$MYSQLuser" -p"$MYSQLpassword"
8cd /tmp/
9#download ASN database
10curl -O -s https://iptoasn.com/data/ip2asn-combined.tsv.gz 
11gunzip -f ip2asn-combined.tsv.gz
12#insert ASN table into Box4s_db Database
13echo "DROP TABLE IF EXISTS asn; CREATE TABLE asn (range_start VARBINARY(40),range_end VARBINARY(40), AS_number VARCHAR(10) ,country_code VARCHAR(7),AS_description VARCHAR(250)); LOAD DATA LOCAL INFILE'/tmp/ip2asn-combined.tsv' INTO TABLE asn FIELDS TERMINATED BY '\t';" | mysql -u"$MYSQLuser" -p"$MYSQLpassword" Box4s_db
14rm ip2asn-combined.tsv