Where to save the database dump?

Question

MySQL

We have a nodejs application with a mysql database. Recently there was a need to save database dumps, and it was decided to leave the dump files directly in a separate application folder. Where can I save database dumps so that they are not in the project folder?

Answer 1

For more secure storage of dumps, it is advisable to use the remote storage of Google Drive and Dropbox.
It is desirable that the program works primarily with localStorage, and Google Drive or Dropbox is used only to synchronize data from localStorage.
Implementation example:
Link

Answer 2

The most reasonable thing is to have a synchronous replica that can be used as the main server in case of loss of it. Do dumps from a replica and store in any file storage away from the database, that is, on another hardware

Answer 3

I would recommend following the golden rule 3-2-1
. There are many approaches, from replicas (replica != backup) to sql backups and binary dumps.
You can use both self-written scripts and individual complexes (for example, Bacula), it’s already a matter of budget and imagination.