Export MySQL database via SSH

Posted on 5 February 201819 October 2018 by Linux

In one of my earlier I showed the way import the database using the console.
This time we reverse the situation and export a database using ssh.
Below a very simple tutorial.

mysqldump -u mysql_username -p name_of_database > databasefile.sql

1	mysqldump -u mysql_username -p name_of_database > databasefile.sql

Podmieniamy:
mysql_uzytkownik, nazwabazy to its data base and to spend the console command.
After the process should be done in the directory where they see a file called nazwapliku.sql
This is just a snapshot of our database.