Shell Programming and Scripting

Hi all,

i have a list of files that contains some PC hostname, then i need to enumerate every hostname and check if there's a table with same name of the hosts in MySQL database XYZ.
I need this because have to decide automatically if i have to make a create table or a insert into an existent table.
Database XYZ is composed by a table for every hostname i have (inventory purposes), now i have a scheduled task that creates a inventory text file and put it in a directory. Let's go back to first phrases of this post, i wish to feed a list of inventory files into another file then compare entries from that file with a ls (or similar) of sql directory.
I know for sure that for every old hostname there's a table named like the hostname but in the script that execute the sql code i need to create a new table in case of new hostname that make himself the inventory, so...

Eg.

I have a file named "hostnames" which contain:

Code:

 
pc001
pc002
pc005
...

And a directory "sqldir" which contains sql tables of the machines:

Code:

-rw-r--r-- 1 root root 12 2010-02-15 17:17 pc001.frm
-rw-r--r-- 1 root root 12 2010-02-15 17:17 pc001.MYI
-rw-r--r-- 1 root root 12 2010-02-15 17:17 pc001.MYD
-rw-r--r-- 1 root root 12 2010-02-15 17:17 pc002.frm
-rw-r--r-- 1 root root 12 2010-02-15 17:17 pc002.MYI
..............

Now... Have anybody optimal way or suggests to read the file "hostnames" and then compare every hostname with the list of the directory "sqldir" and set a variable to make possible decide if it's the time to create a new table or append a existent one?

P.S. I have already the statement to create a new one or append, need only to put the right value for the variable which decide "right" or "left"...

Sorry if i have written too much but i'm not very confident in US/english and i fear to going misunderstood... Thx

try with next

Code:

#!/bin/bash
for  HH in `cat hostnames`
do
    Var=`ls |awk '/'$HH'/ {print 1}'`
    if [ "$Var" = "1" ] ; then
      echo append script for $HH
    else
      echo cretae script for $HH
    fi
done

and the result was:

append script for pc001
append script for pc002
cretae script for pc003
cretae script for pc004
cretae script for pc005
cretae script for pc006
append script for pc007

Thx for the suggest i try right away...

P.S. Get in touch with shell programming i have found that is really hard and request a lot of time and practice anyway... Fortunately "exist" this forum "then" we may "find" the solutions for our problems...
I hope i have not to put this phrase in CODE wrap...