Steps to take backup of single Mysql table

[kumkumsharma]

You can follow below steps :

You can create dump file :

#mysqldump db_name table_name > table_name.sql

You can create dump file from remote server:

#mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql

You can create dump file using phpmyadmin:

Cpanel >> phpmyadmin >> Export >> Method: Click on 'Custom - display all possible options'>> Database(s) >>Output: Save output to a file - Select Compression type >> Go