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

Error displaying the error page: The cachelite Cache Storage is not supported on this platform. (Joomla error)

While accessing the Joomla site, I was getting error as - Error displaying the error page: The...

How to access phpMyAdmin without login to cPanel?

Many times you will get the question from client that -I want to provide access the phpMyAdmin to...

sendmail cannot be called directly from a shell with the current user id

While sending email using sendmail scirpt, I was getting the error message as - sendmail:...

Host1 uid 32210 no header by parse_headers so taking whole header with BODY.PEEK[HEADER]

I was getting below error messages while using imapsync command on the server and emails were not...

How to disable the php mail() function on cPanel with CloudLinux?

If your server installed cPanel with CloudLinux along alt-php and you want to disable php mail()...

Powered by WHMCompleteSolution