Backup and Restore a table

Backup

mysqldump -u -p db_name table_name > script_name.sql

Example :  mysqldump -u dse -p dse_db tread_data_2015 > tread_data_2015.sql


Restore

Loggin to mysql : mysql -u <user_name> -p db_name

execute the script: mysql> source <full_path>/table_name.sql

Example: mysql -u dse -p dse_db
mysql> source /u0/SQL_SCRIPTS/tread_data_2015.sql