shell½Å±¾Ñ§Ï°±Ê¼Ç£¨Èý£©mysqlÓëARP±íµÄ°ó¶¨Ô´Âë

shell½Å±¾Ñ§Ï°±Ê¼Ç£¨Èý£©
 
                    
£­£­£­£­£­£­mysqlÓëARP±íµÄ°ó¶¨Ô´Âë
 Õâ¸ö³ÌÐòÖгýÁËÓÐshell½Å±¾£¬»¹Óõ½ÁËmysqlÅú´¦Àí½Å±¾
Ö÷ҪʵÏÖÓÃmysql¶ÔARP±íµÄ¸üÐÂ
shell½Å±¾£º
#!/bin/bash
#create IP-MAC items in database and add some IP-MAC items in the
ARP table
#First cheek if there is a database
DataBasePath='/var/lib/mysql'  #the path is where
the mysql store the databse
dataPath='/var/lib/mysql/Data'  
#where mysql place the database
homePath='/home/shiyan/mysql'   
#normal place to put the data
state=''  #hold for state,1 for err state,0 for
correct state
##################################function#######################################
#update the ARP table with the database
updateARP(){
sudo chmod 777 $dataPath
sudo cp $dataPath/data.txt $homePath/
cd $homePath
 Line=`wc -l data.txt|awk '{printf $1}'`
 Hold1=$Line
 while [ $Hold1 -ne "0" ]
 do
 IPhold=` sed -n \`echo $Hold1\`p data.txt|awk
'{printf $1}'`
 MAChold=` sed -n \`echo $Hold1\`p
data.txt|awk '{printf $2}'`
 sudo arp -s $IPhold $MAChold
 Hold1=`expr $Hold1 - 1`
done
}
#delete the data.txt in $dataPath
delete(){
sudo chmod 777 $dataPath
cd $dataPath
hold=`ls|grep 'data.txt'`
if [ -z $hold ];then #$hold is empty
   echo -e "\n"
else
  sudo rm
data.txt   #delete the data.txt
in order to update the data.txt
fi
}
##################################main#############################################
sudo chmod 777 $DataBasePath
sudo chmod 777 $DataPath
cd $DataBasePath
hold1=`ls|grep 'Data'`
if [ -z $hold1 ];then #if hold1 is empty,means there is no Data
DataBase yet
  mysql -uroot -p123
<$homePath/exe/createData.txt
fi
echo "1---add IP-MAC items from file"
echo "2---add IP-MAC items from keyboard"