How to take backup of single table in MySQL Db using MySQLdump

[Moriana]

How to take backup of single table in MySQL Db by using MySQLdump?
and how to restore it?

[KelvinSmith]

Hello Moriana,

Backing up a table in MySQL

mysqldump -u -p databasename tablename > tablename.sql

Example : mysqldump psa BackupsScheduled > BackupsScheduled.sql -u admin -p`cat /etc/psa/.psa.shadow`

Restoring table from MySQL

mysql -u -p databasename < tablename.sql

Example : mysql psa < BackupsScheduled.sql -u admin -p`cat /etc/psa/.psa.shadow`