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 
 
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to change the primary IP address of a WHM/cPanel (centOS/RHEL) based servers?

1. Steps for WHM: I. Log into WHM >> Basic cPanel & WHM Setup II. Change the Primary...

#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 Install or Uninstall EasyApache 4 on cPanel server?

EasyApache Software is included within your cPanel and WHM license which is very easy and useful...

Failed to connect to MySQL: Access denied for user

While accessing the website, I was getting the error as -Failed to connect to MySQL: Access...

Powered by WHMCompleteSolution