Lost Entire NocoDB Database Unexpectedly

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

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

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.


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