How to Export the Database using SSH?

0
456
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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here