Body: <p>I have my Craft 3 database on a separate server than my Craft webserver (load balancing) and when I use the download database backup function in Craft 3, it doesn't know where to look.</p>
  
  <p>I haven't worked with a setup with separate locations for the DB and the site before so it's something new for me to work with.</p>
  
  <p>From <a href="https://craftcms.stackexchange.com/questions/23290/craft-3-cant-backup-database-mysqldump-command-not-found/23291#23291">this answer</a>, I think it's where I'd setup a custom <code>backupCommand</code> config, but I don't know where to start.</p>
  
  <p>It's on an nginx setup if that helps?</p>
  
  <p>Cheers.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-29T15:19:39.530Z
Comments.Text: might help: [Mitigating Disaster via Website Backups](https://nystudio107.com/blog/mitigating-disaster-via-website-backups)
Comments.UserDisplayName: andrew.welch
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-29T15:50:03.647Z
Comments.Text: You always have something, Andrew. Gonna get setup with this 
Comments.UserDisplayName: Jay
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-29T21:40:00.310Z
Comments.Text: @Jay Be sure and add an answer when you get a working solution. :)
Comments.UserDisplayName: Brad Bell
Tags: <control-panel><database><mysql><back-up>
Title: Setting up Craft 3 database backup command for a remote database server
ThreadText: # Setting up Craft 3 database backup command for a remote database server
  
  (Asked by: username_0 on 2018-08-29)
  
  I have my Craft 3 database on a separate server than my Craft webserver (load balancing) and when I use the download database backup function in Craft 3, it doesn't know where to look.
  
  I haven't worked with a setup with separate locations for the DB and the site before so it's something new for me to work with.
  
  From [this answer](https://craftcms.stackexchange.com/questions/23290/craft-3-cant-backup-database-mysqldump-command-not-found/23291#23291), I think it's where I'd setup a custom `backupCommand` config, but I don't know where to start.
  
  It's on an nginx setup if that helps?
  
  Cheers.
  
  **Tags:** control-panel, database, mysql, back-up
  
  > **Comments:**
  > **username_1**: might help: [Mitigating Disaster via Website Backups](https://nystudio107.com/blog/mitigating-disaster-via-website-backups)  
  > **username_0**: You always have something, Andrew. Gonna get setup with this   
  > **username_2**: @username_0 Be sure and add an answer when you get a working solution. :)  
  
  ---
  
  ## 0 answers
  
  