原创，数据备份的脚本 for informix

武昌鱼

1. #!/bin/ksh
   
2. if (($# != 4)) then
   
3. 
   
4.         print "Usage:csh  bakup_dbtab.sh dbname start_time[yyyy-mm-dd] stop_time[yyyy-mm-dd] mapping";
   
5.         exit 0;
   
6.        
   
7. elif (($# == 4)) then
   
8. 
   
9.         dbname=$1;
   
10.         print "$dbname";
    
11.         mkdir "$2--$3";
    
12.         filedir="$2--$3";
    
13.         print "$filedir";
    
14.        
    
15. fi
    
16. 
    
17. for tabname in $(< $4)
    
18. do
    
19.    
    
20.    mkdir "$filedir/$tabname";
    
21. dbaccess $dbname <<EOF
    
22.    unload to "tmp_time.unl"  select extend(first_result,year to day) from $tabname where extend(first_result,year to day)>="$2" and extend(first_result,year to day)<="$3";
    
23. EOF
    
24. 
    
25.    sed 's/|//w time.unl' tmp_time.unl
    
26.    rm tmp_time.unl
    
27.    for time in $(<time.unl)
    
28.    do   
    
29.      
    
30. dbaccess $dbname <<EOF     
    
31.   unload to "$filedir/$tabname/$time.unl" select * from $tabname where extend(first_result,year to day)="$time";
    
32. EOF
    
33.    done
    
34.    rm time.unl;
    
35. done
    
36. 
    
37. print "Do you want unite the date by table ?(warning:if the system limit files size ,please enter n)(y/n)"
    
38. read answer
    
39. if [[ $answer == [Yy]* ]];
    
40. then
    
41. for tabdir in $(< $4)
    
42. do
    
43.    cat $filedir/$tabdir/*.unl > $filedir/$tabdir\-$3.data;
    
44.    rm -r "$filedir/$tabdir";
    
45. done
    
46. fi
    
47. 
    
48. print "tar the $filedir  ";
    
49.    tar -cvf $filedir.tar $filedir;
    
50. 
    
51. print "compress the $filedir.tar  "
    
52.    compress $filedir.tar
    
53. 
    
54. print "Do you want delete temp dir?(y/n)"
    
55. read answer2
    
56. if [[ $answer2 == [Yy]* ]];
    
57. then
    
58.    rm -r $filedir
    
59. fi
    
60. 
    
61. print "Do you want delete the bak_data from table ?(y/n)"
    
62. read answer3
    
63. if [[ $answer3 == [Yy]* ]];
    
64. then
    
65. for tabname in $(< $4)
    
66. do
    
67. dbaccess $dbname <<EOF
    
68.    unload to "del_tmp_time.unl"  select extend(first_result,year to day) from $tabname where extend(first_result,year to day)>="$2" and extend(first_result,year to day)<="$3";
    
69. EOF
    
70. 
    
71.    sed 's/|//w del_time.unl' del_tmp_time.unl
    
72.    rm del_tmp_time.unl
    
73.    for time in $(<del_time.unl)
    
74.    do
    
75. dbaccess $dbname <<EOF     
    
76.    delete from $tabname where extend(first_result,year to day)="$time";
    
77. EOF
    
78.    done
    
79.    rm del_time.unl;
    
80. done
    
81. fi

复制代码

***帮你加个code。
建议今后上传的代码都加上code，这样看起来会规整一些
admirer

武昌鱼

请大家指教