How to Backup MySQL Database with Putty (SSH)

To back up a database using an SSH client, simply use the following command:

 

mysqldump --opt -Q -u usuário_banco-de-dados -p nome_banco-de-dados > backup.sql

 

Replace the names in bold with the user of your database and the name of the database. Below is a video lesson explaining the process: