Backup single MySQL table using shell command and phpMyAdmin
1. Creating dump file -
#mysqldump db_name table_name > table_name.sql
2. Creating dump file from remote server -
#mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql
3. Creating dump file using phpMyAdmin -
cPanel >> phpMyAdmin >> Export >> Export Method: Click on 'Custom - display all possible options'>> Database(s) >>Output: Save output to a file - Select Compression type >> Go
