dharmendra1986 0 Newbie Poster
I have a shell script like as follows 

#!/bin/bash
# Downloading Dumps from the production server.
Date=`date +'%d-%m-%y-%H-%M'`
BACKDIR=/home/tmp/Backup
#IP Address of the Server
Host="localhost"
#User Name
USER="root"
#Database Name
DBS="test_db"

echo "Backing up MySQL databases..."
echo "Time: `date`"
mysqldump -h $HOST -v --user=$USER --password=$PASS $DBS 
test_tbl1 test_tble2 ...... >    $BACKDIR/$DBS_tables.sql

if [ $? -eq 0 ]
then
echo "Database dumps downloaded successfully!"
else
echo "Error in downloading database dumps"
exit 1;
fi

echo Your backup is complete!
echo "Time: `date`"


I have around 50 tables, from there I need to take dump of 15
only. So can I include any logic here so that I do not need to
write the name of table in the mysqldump command which automatically igones the other tables