Re: Table names with periods

[Chance Ellis]

Thanks everyone for all of the replies! I have been banging my head against
this for a week now and I was never looking in the direction of the cron
script... Sometimes it helps having another set (or ten) of eyes looking at
the problem.
 Thanks again!


 On 10/3/05, Bastian Balthazar Bux <BastianBalthazarBux@stripped> wrote:
>
> 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.
>
>