Shell script for partial table backup I have multiple database in my MYSQL server and i want to take some particular tables backup from each database.
    can anyone help me in writting a shell script for this scenario.
write table names in a file and use following command to take backups


  for i in `cat table_name_file` 
  do
  mysqldump -uroot -p -T $i
  done


Hope it helps