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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]