terminal - how do i back up a mysql database on my server onto my computer? -

i want delete contents on digitalocean server , start afresh. it's ruby on rails project, want make java.

but want keep 1 of databases. possible backup database onto computer? have thought straight forward i've been googling while no luck.

the closest can find mysql 'dumping' part of server :

mysqldump -u username -p database_to_backup > backup_name.sql 

and restoring somewhere else on server. want put on computer , delete stuff on server.

the best method install phpmyadmin , dump database .sql file, importing later, digital ocean have guide on website installing, , securing it. make managing database later, easier.

here