Dumping a mysql table

# mysqlshow

#mysqlshow database
Dump
mysqldump db_name table_name > table_name.sql
Dump using PV
mysqldump db_name table_name | pv > database.table.$(date +"%Y-%m-%d").sql

Importing a table