Is there a way to have dnsmasq output dns queries to a mysql database?  I've searched and don't think there is a way to have it do it.  So if not, is there a way to write a script to copy the contents of the log file it's using to a database and then empty the file?

Depending on the format of the log file I imagine a load of cuts/grep/seds would give you what you want for a command line mysql query.

I think the only records I'd want from the log file are designated like this: [query]  so it shouldn't be terribly hard to do that right?  How would I flush that file afterward though? I think there is probably a built in command that does like like it rotates the log files.

Got that grep portion working, thanks for reminding me about it!  It's something I should use daily but just haven't taken the time to really learn yet.

You could delete and recreate the file at the end of the script.

Or copy the contents, empty the file, then do the mysql stuff after to make sure no extra stuff is added whilst it's all going on.

I'll give it a shot and let you know how I've fucked things up!