Re: Table names with periods

[Bastian Balthazar Bux]

Chance Ellis wrote:
[snip]
> of CREATE TABLE entries. I then import those files with a cron script into
> mysql. This is where I am looking to convert IP address into something
[snip]

There is a world of possibilities at this point, one is this:

sed \
--expression='s/@@@NEEDTOREPLACETHIS\([0123456789]\).\([0123456789]\)\.\([0123456789]\)\.\([0123456789]\)*NEEDTOREPLACETHIS@@@/\1_\2_\3_\4/'
\
SAVEDFILENAME \
| mysql -ublabla -psecret dbname



You can do quite everyting from a cron script, also create sql query
from normal syslog logs.