skip to main | skip to sidebar

Infinite diversity in infinite combinations.

Musings and mumblings with some code here

Thursday, October 10, 2013

MYSQL load data: Stripping out zulu time and converting ip addresses to unsigned ints.

Snip for me: Storing IP addresses compactly in MySQL

Posted by lmwangi at 6:00 PM

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Blog Archive

► 2017 (1)
- ► August (1)

► 2016 (1)
- ► January (1)

► 2015 (1)
- ► October (1)

► 2014 (11)
- ► October (1)
- ► August (1)
- ► July (2)
- ► May (4)
- ► March (1)
- ► January (2)

▼ 2013 (14)
- ► December (1)
- ► November (1)
- ▼ October (4)
- ► April (2)
- ► March (2)
- ► February (3)
- ► January (1)

► 2012 (4)
- ► July (1)
- ► June (1)
- ► May (1)
- ► April (1)

► 2011 (34)
- ► August (1)
- ► July (6)
- ► May (8)
- ► April (7)
- ► March (5)
- ► February (7)

► 2010 (14)
- ► December (3)
- ► October (2)
- ► August (1)
- ► July (1)
- ► May (2)
- ► April (2)
- ► March (1)
- ► February (1)
- ► January (1)

► 2009 (1)
- ► November (1)

Labels

Linux (8) python (8) hg (7) rpki (6) MySQL (5) TLS (5) KVM (4) R (4) awk (4) debian (4) ipv4 (4) openssl (4) shell (4) sorting (4) C (3) SSL (3) apache (3) ipv6 (3) libvirt (3) squeeze (3) x509 (3) Munin (2) PostgreSQL (2) Replication (2) flock (2) gdb (2) gfs (2) gnuplot (2) kernel (2) partitions (2) perl (2) script (2) soekris (2) strace (2) tshark (2) wireshark (2) /8 blocks (1) Decryption (1) IaMBanks (1) Installing OpenGrok (1) MANOPT (1) NOAA (1) PDF (1) RMySQL (1) SNMP (1) SSL' (1) TLSS (1) X (1) Zenoss (1) aggregation (1) alpr python ai opencv (1) asn1 (1) backdoor (1) blktrace (1) books (1) buddyinfo (1) casting (1) categorical data (1) certutil (1) cherrypy (1) clientauth (1) contextmanager (1) convert (1) crl (1) curl (1) dance (1) debian bug 560044 (1) deepcopy (1) digests (1) django (1) dns (1) dtruss (1) dualhead (1) dumpe2fs (1) ejbca (1) encryption (1) errors (1) ext4 (1) fadvise (1) fgrep (1) filedescriptors (1) firefox (1) firewalls (1) flask (1) freebsd (1) function (1) garbled man (1) geom_vline (1) ggplot2 (1) ghostscript (1) google api (1) grep (1) hg ssl x509 imap fingerprints fetchmail (1) histogram (1) ipython (1) isc (1) iterm2 (1) itsdangerous (1) jboss (1) json (1) kenya (1) ksplice (1) lock (1) loopbackfs (1) macbookpro (1) man (1) manifests (1) manpages (1) maths (1) matplotlib (1) memory (1) mencoder (1) mod_auth_mysql (1) modes (1) moinmoin migrate to wikimedia (1) mouse (1) mozilla (1) net 5501 (1) networking (1) oh-my-zsh (1) oil prices (1) opendirectoryd dtrace (1) osx (1) owth (1) p12 (1) pagecache (1) parallel (1) permissions (1) ping (1) pk12util (1) pkcs12 (1) plpgsql (1) powerline (1) proc (1) processes (1) python-ldap (1) random (1) recursion (1) roa (1) rrd (1) ruby (1) sci-fi (1) scp (1) screen (1) secret key (1) serial (1) shard (1) sid (1) socket (1) solarized (1) spf13 (1) ssh (1) statistics (1) steganography (1) stuck X (1) subnets (1) suspend (1) tail recursion (1) tcp (1) traffic camera (1) translate (1) trigger (1) udp (1) unix (1) usb (1) variables (1) vim (1) virtualenv (1) with (1) xargs (1) xbmc (1) xmlrpc (1) xor obfuscation (1) xwd (1) zsh (1)