#!/bin/bash
TABLE_NAME="$1"
SQL_FILENAME="$2"
CURRENT_DIR="`pwd`"
if [ $# -ne 2 ];then
echo "please input TABLE_NAME and SQL_FILENAME, exit"
exit
fi
echo "TABLE_NAME: ${TABLE_NAME}"
echo "SQL_FILENAME: ${SQL_FILENAME}"
echo "CURRENT_DIR: ${CURRENT_DIR}"
echo "FUll_NAME: ${CURRENT_DIR}/${SQL_FILENAME}"
if [ ! -f "${CURRENT_DIR}/${SQL_FILENAME}" ];then
echo "${CURRENT_DIR}/${SQL_FILENAME} not exsists,exit"
exit
fi
sed -n "/-- Table structure for table \`$1\`/,/-- Dumping data for table \`$1\`/p" ${CURRENT_DIR}/${SQL_FILENAME} | tee ${CURRENT_DIR}/${TABLE_NAME}.sql
grep "INSERT INTO \`$1\` VALUES" ${CURRENT_DIR}/${SQL_FILENAME} | tee -a ${CURRENT_DIR}/${TABLE_NAME}.sql