where do i get the backed up database

  • Posted on December 31, 2014
  • iostarAsked by iostar

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

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

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

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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.