phpMyAdmin’s ability to import and export databases make it much easier to recover from database crash and even migrate a database from one server to another. Since the process is done through a web-based interface, you don’t have to recover the database from your server.
What is Database Export?
When you trade a database, you are making a reinforcement record of the database. This reinforcement record is typically a .sql document (a content record) and can be utilized to duplicate and import the database onto another server. You can export a database also using phpMyAdmin option in cPanel.
What is SSH?
SSH also is known as Secure Socket Shell is a network protocol that provides administrators with a secure way to access a remote computer.
How to export the database using SSH?
mysqldump -p -u username database_name > dbname.sql command is used to export the database using SSH.