where do i get the backed up database

@iostar I reread your question and realized you are probably using a web console to your droplet and want to do a file transfer from your droplet to your local machine. The short answer is you can’t do it directly from the web console. You need to use a file transfer method, such as secure ftp, or copy to a remote mount filesystem, or as a last resort and it’s a small database (let’s say < 1Mb) email the file to yourself.

The FTP intro tutorial may help you get started.

As above mentioned, you will likely need to do it manually via ssh / ftp / sftp…

Anyway, Locationwise. Its whereever you currently are on the system…

For example. When you login to your server, Type the command “pwd” This will tell you were your current WorkingDirectory is… This is where you work from.

So, Say I type PWD and it says. /home/myusername

This means if i type: mysqldump db_name > backup-file.sql

backup-file.sql will be in /home/myusername/backup-file.sql

If i type: mysqldump db_name > /root/backup-file.sql

I have above used /root/ as the directory and forced it to store it in this location.

So… If you dont specify a directory, it will store it where you are working from currently ( PWD to see )

Hope this helps on top of the above answer.