Answers.Body: <p>Ended up getting this resolved, by downloading DB from Craft staging site and importing, instead of using Sequel Pro. Also make sure your configs in general.php are correct. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-11T15:18:28.807Z
Answers.LastActivityDate: 2019-01-11T15:18:28.807Z
Answers.UserDisplayName: c_c
Answers.Body: <blockquote>
    <p>But when I import my DB then visit my site: I get the error message "Site unavailable".</p>
  </blockquote>
  
  <p>You get that because it's a front-end site request and Craft needs to make updates to the database that can be triggered by the Control Panel.</p>
  
  <blockquote>
    <p>I click proceed and see the message "Craft couldn’t backup the database. How would you like to proceed?".</p>
  </blockquote>
  
  <p>That's because Craft uses <a href="https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html" rel="nofollow noreferrer">mysqldump</a> (if you're using MySQL) to perform database backups and the path to that currently isn't available to PHP in your environment. The easiest way to fix it is to add the path to <code>mysqldump</code> to your system PATH environment varible.</p>
  
  <p>Alternatively, you can manually perform a database backup using your favorite database client, and click the "Continue anyway" button to let Craft finish performing the update.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-11T00:30:20.043Z
Answers.LastActivityDate: 2019-01-11T00:30:20.043Z
Answers.UserDisplayName: Brad Bell
Body: <p>I am installing a repo locally, and everything runs smoothly and I am able to see the site and login to my admin. But when I import my DB then visit my site: I get the error message "Site unavailable". </p>
  
  <p>When I visit my admin area I see the message: "To complete the update, some changes must be made to your database." I click proceed and see the message "Craft couldn’t backup the database. How would you like to proceed?".</p>
  
  <p>I am using Craft 3. But the DB I am importing from uses the older 'craft_' prefix, which I defined in the setup. Am stumped on how to solve this.</p>
  
Tags: <craft3><database><installation><craft2>
Title: Unable to access site after importing DB
ThreadText: # Unable to access site after importing DB
  
  (Asked by: username_0 on 2019-01-10)
  
  I am installing a repo locally, and everything runs smoothly and I am able to see the site and login to my admin. But when I import my DB then visit my site: I get the error message "Site unavailable".
  
  When I visit my admin area I see the message: "To complete the update, some changes must be made to your database." I click proceed and see the message "Craft couldn’t backup the database. How would you like to proceed?".
  
  I am using Craft 3. But the DB I am importing from uses the older 'craft\_' prefix, which I defined in the setup. Am stumped on how to solve this.
  
  **Tags:** craft3, database, installation, craft2
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2019-01-11. Score: 1
  
  Ended up getting this resolved, by downloading DB from Craft staging site and importing, instead of using Sequel Pro. Also make sure your configs in general.php are correct.
  
  
  ---
  
  ### Answer by username_1 on 2019-01-11. Score: 0
  
  > But when I import my DB then visit my site: I get the error message "Site unavailable".
  
  You get that because it's a front-end site request and Craft needs to make updates to the database that can be triggered by the Control Panel.
  
  > I click proceed and see the message "Craft couldn’t backup the database. How would you like to proceed?".
  
  That's because Craft uses [mysqldump](https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html) (if you're using MySQL) to perform database backups and the path to that currently isn't available to PHP in your environment. The easiest way to fix it is to add the path to `mysqldump` to your system PATH environment varible.
  
  Alternatively, you can manually perform a database backup using your favorite database client, and click the "Continue anyway" button to let Craft finish performing the update.
  
  
  ---
  
  