How to backup single MySQL table?

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 
 

Was this answer helpful?

 Print this Article

Also Read

Account Creation Status: failed. A database owner with the name <account-name> already exists.

I have deleted the account from the WHM but while recreating it, I was getting below error...

#145 - Table './database_name/table_name' is marked as crashed and should be repair

I was getting below error while accessing one site - Error in establishing database...

How to configure Amazon S3 backups in WHM?

There is always issues on the server like Hard Drive Failures and its very important to keep your...

SSL Installation error -directive missing closing '>'

While installing the SSL on domain from WHM >> SSL/TLS >> Install an SSL Certificate...

587 sender verify fail for <email address>: No Such User Here

I was getting the error while sending email as -587 sender verify fail for <email address>:...

Powered by WHMCompleteSolution