sql/DBC_sql_statements/import_script.sh

   1 #!/bin/sh
   2 # Small Bash Script to help you import the sql files
   3 # into openemr database, in order to use DBC Dutch System
   4 #
   5 # 2008 Cristian Navalici ncristian @lemonsoftware . eu
   6
   7
   8 DIRSQLDBC='/var/www/html/openemrdbc/sql/DBC_sql_statements'
   9 USER='user for import'
  10 PASS='password'
  11 DATABASE='openemr db'
  12
  13 cd $DIRSQLDBC
  14
  15 for i in *.sql.gz ;
  16 do
  17         echo "Unpacking $i";
  18         gunzip "$i";
  19 done;
  20
  21 for j in *.sql;
  22 do
  23         SIZE=`du -h $j`;
  24         echo "Importing $j (SIZE: $SIZE)";
  25         mysql -u$USER -p$PASS $DATABASE < $j;
  26 done;
  27