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

CC BY-SA 4.0
2019-01-11T15:18:28.807Z
2019-01-11T15:18:28.807Z
c_c
<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>

CC BY-SA 4.0
2019-01-11T00:30:20.043Z
2019-01-11T00:30:20.043Z
Brad Bell
<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>

<craft3><database><installation><craft2>
Unable to access site after importing DB
# 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.


---

