where do i get the backed up database

  • Posted December 31, 2014

i took a mysql database backup using console by mysqldump command, but now i dont know from where to download the backed up databse


You usually do a file redirect of the output. From the mysqldump man page:

A common use of mysqldump is for making a backup of an entire database:
           mysqldump db_name > backup-file.sql
You can load the dump file back into the server like this:
           mysql db_name < backup-file.sql

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

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.

@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.