How to Export the Database using SSH?

Export the Database
Export Database Graphical Illustration

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.


Please enter your comment!
Please enter your name here