#!/bin/bash
DBNAME=`basename $1 .sql.gz`

function patch_sql
{
  systools/patch_sql
#  sed 's/TYPE=MyISAM/ENGINE=MyISAM/g; s/timestamp([0-9]*)/timestamp/g; s/TYPE=InnoDB/ENGINE=MyISAM/g'
}

rm -f $DBNAME.sql
gunzip $DBNAME.sql.gz
if [ $2"." == "." ]
then
  cat $DBNAME.sql | grep "INSERT INTO" | mysql -f -u euro3g -peuro3g $1
else
  echo "use $1" > tmp_table_update.sql
  echo "delete from $2;" >> tmp_table_update.sql
  cat $DBNAME.sql | grep "INSERT INTO" | grep $2 >> tmp_table_update.sql
  cat tmp_table_update.sql | patch_sql | mysql -f -u euro3g -peuro3g $1
fi


