Download and Restore MySql database via SSH?

[Jovani]

Hello, can anyone guide me any simple steps to download and restore MySql database via SSH on my VPS?
I used to do it via cPanel but i heard someone said that do it via SSH very fast.
please give me your tips.

 

[Hassan]

Exporting MySQL Data
1:Log into your server via SSH.
2:Using SSH, execute the following command:

mysqldump -p -u username database_name > dbname.sql

Provide password for database user and press enter The file dbname.sql now holds a backup of your database.

Import A MySQL Database
1: Start upload your .sql file to host if you dont have a database yet you can create from control panel.
2: Login to SSH.
3: Using SSH, navigate to the directory where your .sql file is.
4: perform following command:

mysql -p -u username database_name < file.sql