# Starting Over with Old Database

**URL:** https://meta.discourse.org/t/starting-over-with-old-database/63577
**Category:** Support
**Created:** [May 29, 2017, 9:10pm UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577 "2017-05-29T21:10:03Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![jameshull](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jameshull/32/72977_2.png) [@jameshull](https://meta.discourse.org/u/jameshull)
#### Post date: [May 29, 2017, 9:10pm UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/1 "2017-05-29T21:10:03Z")

</div>

Hi there -

I’ve been running Discourse on DigitalOcean for the past two years. Just this week I tried to upgrade and every time I tried to do it from the control panel it would fail.

I tried SSH’ing in and doing it manually, but for some reason DO’s setup of Discourse–at least at the time I originally set it up–didn’t have the `var/discourse` directory. Regardless, now I’m getting 502 and I can’t get my application to start back up again. Running the logs app from the `/docker` directory I get `Could not find activesupport-4.2.8 in any of the sources`

What I would love to do is to start completely over - perhaps by installing with whatever new paradigm DO/Discourse has for 2017 BUT I want to be able to keep my old database - my years of posts, comments, etc.

Is there any resource or suggestion anyone would have about how to go about doing this? I would super appreciate it as I have a pretty big active community that is wondering what happened!

Thank you

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [May 29, 2017, 9:13pm UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/2 "2017-05-29T21:13:28Z")

</div>

Start a new droplet on Digital Ocean, install Discourse using the [official guide](https://github.com/discourse/discourse/blob/master/docs/INSTALL-cloud.md) and after the first login upload your last backup and restore.

---

<div class="post-metadata">

### Author: ![jameshull](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jameshull/32/72977_2.png) [@jameshull](https://meta.discourse.org/u/jameshull)
#### Post date: [May 29, 2017, 11:11pm UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/3 "2017-05-29T23:11:08Z")

</div>

Thanks! Sounds super obvious - but two questions:

- Is this better than the one-click install app option on DO? What’s the difference?
- How do I go about downloading my last backup? What is the location of all the important info?

In DO, my only options are to Create Droplet from a Backup or Restore Droplet from a Backup, nothing about downloading - but I’m sure I can do it manually if I know the essential parts.

---

<div class="post-metadata">

### Author: ![jomaxro](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jomaxro/32/126216_2.png) [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [May 29, 2017, 11:22pm UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/4 "2017-05-29T23:22:10Z")

</div>

> [@jameshull](#):
>
> Is this better than the one-click install app option on DO? What’s the difference?

The one-click install is out of date (2 major versions if I’m not mistaken) and there have been a number of support requests recently that appeared to be related to the DO install.

> [@jameshull](#):
>
> How do I go about downloading my last backup? What is the location of all the important info?

Are you still able to access Discourse from the browser? If so, download your backup from `/admin/backups`. If not, the files are located (by default) in `/var/discourse/shared/standalone/backups/default`. If you can find the installation location in your droplet, the shared folder should exist and from there you should be able to get the backups.

---

<div class="post-metadata">

### Author: ![jameshull](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jameshull/32/72977_2.png) [@jameshull](https://meta.discourse.org/u/jameshull)
#### Post date: [May 29, 2017, 11:35pm UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/5 "2017-05-29T23:35:31Z")

</div>

And if I somehow don’t have a `/var/discourse` folder but a `var/docker` folder…does that sound right?

I can’t get into the control panel from the browser, only SSH through Terminal.

Also, just realized, these are DO’s automatic backups of the entire droplet done once a week. Unless Discourse does backups automatically I might not have them in that location.

---

<div class="post-metadata">

### Author: ![jomaxro](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jomaxro/32/126216_2.png) [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [May 29, 2017, 11:50pm UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/6 "2017-05-29T23:50:00Z")

</div>

> [@jameshull](#):
>
> a `var/docker` folder

That is where Discourse used to be installed (years ago), so yes, that sounds right.

Discourse does do automated backups, and that is what you should be looking for. DO droplet backups will not help you reinstall Discourse and then restore the database.

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [May 31, 2017, 2:03am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/8 "2017-05-31T02:03:36Z")

</div>

> [@jomaxro](#):
>
> The one-click install is out of date (2 major versions if I’m not mistaken)

What ?! ?! We got to contact Digital Ocean about this @codinghorror originally the plan was for this to be updated weekly by Digital Ocean staff.

---

<div class="post-metadata">

### Author: ![jomaxro](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jomaxro/32/126216_2.png) [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [May 31, 2017, 2:07am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/9 "2017-05-31T02:07:22Z")

</div>

Before contacting DO I’d really appreciate it if someone would double check me on that. I’ve never personally used the DO one-click install…I’ve just seen reports of people doing it and coming in with old versions.

Edit: I’ve got some credit, testing this now…

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [May 31, 2017, 2:15am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/10 "2017-05-31T02:15:52Z")

</div>

Hold off… I was just doing that …

indeed, this is a blast from the past!

```plaintext
commit 0113fce420bcf3bc18a38c6864150334fdefa273
Author: Sam <sam.saffron@gmail.com>
Date: Tue Apr 12 13:29:48 2016 +1000

    FEATURE: automatically close topics with 10k+ posts
    FEATURE: automatically close messages with 2k+ posts

    Both configurable via `auto_close_messages_post_count`
    and `auto_close_topics_post_count`

```

```plaintext
root@delete-me-app:/var/www/discourse# cat /VERSION
1.0.13

```

```plaintext
root@delete-me-app:/var/www/discourse# git branch
  master
* tests-passed

```

```plaintext
root@delete-me-app:/var/www/discourse# psql --version
psql (PostgreSQL) 9.3.11

```

Looks like it is `1.6.0.beta.1`, vintage 🍷 Discourse.

Yeah, if Digital Ocean are not keeping this up to date we really should lobby them to remove it.

Also for added bonus, vintage ubuntu:

```plaintext
root@delete-me:~# lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 14.04.4 LTS
Release:	14.04
Codename:	trusty

```

And you also get an old version of Docker that has lots of known issues:

```plaintext
root@delete-me:~# docker version
Client:
 Version: 1.10.3

```

---

<div class="post-metadata">

### Author: ![r3d\_f0x](https://avatars.discourse-cdn.com/v4/letter/r/3da27b/32.png) [@r3d\_f0x](https://meta.discourse.org/u/r3d_f0x)
#### Post date: [May 31, 2017, 2:34am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/11 "2017-05-31T02:34:00Z")

</div>

> [@jomaxro](#):
>
> The one-click install is out of date (2 major versions if I’m not mistaken) and there have been a number of support requests recently that appeared to be related to the DO install.

I installed with it and it upgraded when I rebuilt it and ran the setup.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [May 31, 2017, 2:47am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/12 "2017-05-31T02:47:02Z")

</div>

They have been contacted by @techAPJ multiple times, if you would like to take a run at it feel free.

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [May 31, 2017, 2:47am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/13 "2017-05-31T02:47:59Z")

</div>

Yeah I am doing my usual Twitter, [Contact DigitalOcean](https://www.digitalocean.com/company/contact/) etc dance. I suspect the old maintainers of this have moved along.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [February 3, 2019, 7:11am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/14 "2019-02-03T07:11:21Z")

</div>

Can you make a note to check what version the DO one click install is at, today?

---

<div class="post-metadata">

### Author: ![thegurjyot](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/thegurjyot/32/120516_2.png) [@thegurjyot](https://meta.discourse.org/u/thegurjyot)
#### Post date: [February 3, 2019, 8:54am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/15 "2019-02-03T08:54:45Z")

</div>

I installed Discourse yesterday and it’s on Version 2.0.20180802. The lastest Discourse is not available. But I guess they need a week to update it to the latest.  
Although when I clicked to update the discourse, the installation got stuck and after that 504 error.

---

<div class="post-metadata">

### Author: ![itsbhanusharma](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/itsbhanusharma/32/180717_2.png) [@itsbhanusharma](https://meta.discourse.org/u/itsbhanusharma)
#### Post date: [February 3, 2019, 9:01am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/16 "2019-02-03T09:01:09Z")

</div>

Is it related to the current topic in any way?

Ps: why don’t you install using the official guide instead of spinning up Digitalocean one click install? It’s known to be buggy.

---

<div class="post-metadata">

### Author: ![thegurjyot](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/thegurjyot/32/120516_2.png) [@thegurjyot](https://meta.discourse.org/u/thegurjyot)
#### Post date: [February 3, 2019, 9:16am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/17 "2019-02-03T09:16:51Z")

</div>

> [@itsbhanusharma](#):
>
> Is it related to the current topic in any way

Codinghorror asked for the latest version DO is using so I told him that. I admit that the rest of the answer is unrelated.

> [@itsbhanusharma](#):
>
> Ps: why don’t you install using the official guide instead of spinning up Digitalocean one click install? It’s known to be buggy

As to why I used one click installation, because I don’t know anything about SSH command line installation. Moreover, I didn’t knew that it’s buggy.

---

<div class="post-metadata">

### Author: ![itsbhanusharma](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/itsbhanusharma/32/180717_2.png) [@itsbhanusharma](https://meta.discourse.org/u/itsbhanusharma)
#### Post date: [February 3, 2019, 9:26am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/18 "2019-02-03T09:26:52Z")

</div>

> [@thegurjyot](#):
>
> I told him that.

I don’t see an exact version number 🙂

> [@thegurjyot](#):
>
> I didn’t knew that it’s buggy.

A little search would’ve helped 🙂

---

<div class="post-metadata">

### Author: ![thegurjyot](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/thegurjyot/32/120516_2.png) [@thegurjyot](https://meta.discourse.org/u/thegurjyot)
#### Post date: [February 3, 2019, 9:41am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/19 "2019-02-03T09:41:38Z")

</div>

> [@itsbhanusharma](#):
>
> A little search would’ve helped

Do you research about a car to know it’s buggy or you drive it to know about its issue? I prefer the latter. Now I can make my mind, about which way to go. 😉

---

<div class="post-metadata">

### Author: ![itsbhanusharma](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/itsbhanusharma/32/180717_2.png) [@itsbhanusharma](https://meta.discourse.org/u/itsbhanusharma)
#### Post date: [February 3, 2019, 9:45am UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/20 "2019-02-03T09:45:58Z")

</div>

I don’t drive a car, I take Ola instead 😉

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 8, 2024, 12:37pm UTC](https://meta.discourse.org/t/starting-over-with-old-database/63577/25 "2024-06-08T12:37:16Z")

</div>

This topic was automatically closed after 2566 days. New replies are no longer allowed.
