How to backup single MySQL table? – Knowledgebase


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 

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Hire a server Expert to resolve the issue Now.

Hire a server Expert to resolve the issue Now.

Resolve this issue in just 5$ from https://serverexpert.io

 

You have Successfully Subscribed!

Open chat