Backuping and restoring a single table using mysqldump

mysqldump_single_table

Backuping a single table from a database
mysqldump -u -p database_one -h host table_name > /var/www/backups/table_name.sql

Backuping a single table from a database with query
mysqldump -u #{user} -p#{pass} -h #{server} -nt --databases #{database} --tables #{table}  --where="#{query}" > example.sql
mysqldump -u root -prootpass -h ssserver -nt --databases example_development --tables products  --where="id > 7970001" > products.sql
-n -t for --no-create-db --no-create-info
mysqldump -u root -pmagrathea -h ssserver  --no-create-db --no-create-info --databases marvin_real3 --tables products  --where="id > 7970001" > pr2.sql

Restoring the table into another database
mysql -u -p -h host database_two < /var/www/backups/table_name.sql

default host is localhost