#!/bin/bash

# dwalters@liquidweb.com

dbdump=$1
tablename=$2

if [ $# -lt 2 ]
then
  echo "extract_table.sh dumpfile table"
  exit 255
fi

startline=$(grep -n "CREATE TABLE \`${tablename}\`" ${dbdump} | cut -d ":" -f 1)
endline=$(egrep -n "(CREATE TABLE|UNLOCK TABLES)" ${dbdump} | egrep "^${startline}" -A 1 | tail -n 1 | cut -d ":" -f 1)

difference=$(echo "${endline}-${startline}+1" | bc)

if [ $difference -lt 0 ]
then
  endline=$( cat ${dbdump} | wc -l )
  ((difference=endline-startline+1))
fi

head -n $endline ${dbdump} | tail -n $difference