Lost Entire NocoDB Database Unexpectedly

Self-Host
1

I tried accessing my NocoDB database, but I lost everything out of nowhere!

  • It’s hosted on my Contabo VPS (self-hosted).
  • All my created tokens are gone.
  • Over 5,000 records disappeared.

Everything is lost! What could have happened? How can I recover my data?

BEFORE

image
image1365×550 64.5 KB

AFTER
An error occurred: Sorry, new users can only put one embedded media item in a post.

3

Hi @Dante
I believe you might have been running NocoDB via Docker without a volume mount and without setting NC_DB. Is that correct?

In such a case, NocoDB defaults to using SQLite and stores data within the container’s filesystem, which is not persistent.

image
image2002×402 32.1 KB

(reference Docker | NocoDB)

I’m really sorry to hear about the data loss. If you’re lucky, the data might still be recoverable from a Docker volume. Here’s what you can try:

  1. Check for existing Docker volumes:
    docker volume ls
    Look for any volume related to NocoDB and inspect it:
    docker volume inspect <volume_name>
  2. If you find the volume, try extracting the noco.db file from it.
  3. Start a new NocoDB container and mount the recovered noco.db to it.

This approach might help you recover your data.

Wishing you the best of luck, hope you’re able to restore everything!