Dump table and database to a file in MySQL

For DB Backup : -

mysqldump -d -h HOST -u USER -p PASSWORD DBNAME > dumpfile.sql

For Table Backup : -

mysqldump -d -h HOST -u USER -p PASSWORD DBNAME TABLENAME > table.sql

For Only Table Structure :-

mysqldump -d -h HOST -u USER -p PASSWORD DBNAME TABLENAME  –no-data > table.sql

You Can Restore Dump as Below : -

mysql > source /path/SQLfile