gist: 91380 - Check MD5 integrity and import bzip2-sql files- GitHub


  
    
      import_md5_bzip2.sh #
    
    
      
      
        embed
        
      
      
      
      raw
    
  
  
  
    
      
        
          
            
            1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

          
          
            
              #!/bin/bash
db_host="localhost"
db_name="database"
db_user="root"
db_pass=""
file_path="/full/path"
 
while read LINE; do
  HASH=`echo $LINE | awk '{print $1}'`
  FILE=`echo $LINE | awk '{print $2}'`
 
  if test "`md5sum $file_path/$FILE | awk '{print $1}'`" = $HASH; then
    echo "Importando arquivo: $FILE ..."
    bzip2 -d < $file_path/$FILE | mysql -h $db_host -u $db_user -D $db_name -p$db_pass -f -H
    echo "OK"
  else
  	 echo "Erro no MD5 do arquivo: $FILE"
  	 # TODO:
  	 # Enviar email avisando da falha
  fi
done < $file_path/MD5SUMS
Description:	Check MD5 integrity and import bzip2-sql files
Public Clone URL:	git://gist.github.com/91380.git Give this clone URL to anyone. `git clone git://gist.github.com/91380.git gist-91380`
Embed All Files:	show embed