just to reconfirm - you mean - ODOO.SH-  Am i correct 

If you’re using Odoo 18 Enterprise (Online/Cloud version) and want to backup your database and run it locally, follow these steps:

✅ Step 1: Backup Odoo 18 Database from Cloud

1️⃣ Log into Odoo Cloud

• Go to Odoo.com → Click "Sign in"
• Navigate to "My Databases"

2️⃣ Download the Backup

• Find your database and click "Manage Database"
• Select "Backup"
• Choose "Full Backup" (includes filestore and database)
• Click "Download" and save the .zip file

✅ Step 2: Restore Backup on Local Odoo 18

🔹 Install Odoo 18 Locally (if not already installed)

bash
CopyEdit
sudo apt update
sudo apt install odoo

🔹 Extract the Backup File

• Unzip the .zip file to get the database dump (.dump or .sql)

🔹 Restore Database to PostgreSQL

bash
CopyEdit
sudo -u postgres createdb odoo18_local
sudo -u postgres pg_restore -d odoo18_local /path/to/your_backup.dump

✅ Step 3: Configure Odoo to Use the Restored Database

1️⃣ Edit Odoo Configuration File (/etc/odoo.conf)

ini
CopyEdit
db_name = odoo18_local

2️⃣ Restart Odoo Service

bash
CopyEdit
sudo systemctl restart odoo

✅ Step 4: Access Odoo Locally

• Open your browser and go to:
  http://localhost:8069
• Log in using your Odoo cloud credentials

Hi  BloomOn Design Agency,

Restoring an Odoo 18 Enterprise database from a cloud backup to a local instance requires several precise steps to ensure that everything, including the database, filestore, and configuration, is set up correctly. Below is a detailed guide to help you troubleshoot and fully restore your Odoo database locally.

Step-by-Step Guide to Restoring Odoo 18 Enterprise Locally

1. Download the Backup from Odoo Cloud

Since you've already downloaded the .dump.zip file and extracted it, you should have:

• dump.sql (PostgreSQL database)
• filestore/ (attachments, images, files)
• (Optional) manifest.json (backup metadata)

2. Restore the Database in PostgreSQL

To restore your database properly, follow these steps:

Step 2.1: Create a New Database

1. Open pgAdmin or use the command line.
2. Create a new database in PostgreSQL using the same encoding and collation:

   
   
   CREATE DATABASE odoo18_local WITH OWNER odoo ENCODING 'UTF8' TEMPLATE template0;
   

   • Replace odoo18_local with your actual database name.
   • Replace odoo with your PostgreSQL user.

Step 2.2: Restore the Database from dump.sql

Use the following command in the terminal:

psql -U odoo -d odoo18_local -f dump.sql

• If you encounter errors about missing roles, create the role manually:

  
  
  CREATE ROLE odoo WITH LOGIN SUPERUSER CREATEDB CREATEROLE PASSWORD 'yourpassword';
  

  Then retry the restore.

3. Restore the Filestore

Odoo stores attachments and images separately from the database. You must copy the extracted filestore/ directory to Odoo's local data directory.

Locate Your Odoo Data Directory

• On Linux:

  
  
  /home/odoo/.local/share/Odoo/filestore/
  

• On Windows:

  
  
  C:\Users\YourUser\AppData\Local\Odoo\filestore\
  

Copy the Filestore

Ensure the filestore matches the name of the database:

cp -r filestore/ ~/.local/share/Odoo/filestore/odoo18_local/

(Change odoo18_local to your actual database name.)

4. Update Odoo Configuration

Edit your odoo.conf file to point to the restored database.

Find the Configuration File

• Linux:

  
  
  /etc/odoo/odoo.conf
  

• Windows:

  
  
  C:\Program Files\Odoo 18\server\odoo.conf
  

Modify the Configuration

Ensure it includes:

[options]
db_host = localhost
db_port = 5432
db_user = odoo
db_password = yourpassword
addons_path = /opt/odoo/addons,/opt/odoo/custom_addons
data_dir = /home/odoo/.local/share/Odoo

Restart the Odoo service after updating the configuration:

sudo systemctl restart odoo

5. Debugging Issues After Restoration

If Odoo starts but has missing attachments or errors:

• Check Logs: Run Odoo with logging enabled:

  
  
  ./odoo-bin --log-level=debug
  

• Update Filestore Permissions:

  
  
  sudo chown -R odoo:odoo ~/.local/share/Odoo/filestore/
  sudo chmod -R 755 ~/.local/share/Odoo/filestore/
  

• Check Installed Modules: If you get module errors, run:

  
  ./odoo-bin -c odoo.conf -u all
  

  This updates all modules.

6. Verify Everything

• Log in to Odoo at http://localhost:8069.
• Check if attachments load correctly.
• Review logs for any errors.

Final Thoughts

✅ Common Issues and Fixes

Method 2: Restore via Odoo UI (/web/database/manager)

If you want a more user-friendly way to restore your database, follow these steps:

1. Open Odoo Database Manager

1. Start your local Odoo instance.

   bash
   
   sudo systemctl start odoo  # For Linux
   net start odoo18           # For Windows (if installed as a service)
   

2. Open your web browser and go to:

   bash
   
   http://localhost:8069/web/database/manager
   

2. Restore the Database

1. Click on "Restore Database".
2. Choose the .zip file you downloaded (.dump.zip).
3. Enter a new database name (e.g., odoo18_local).
4. Master Password:
   • This is defined in your Odoo configuration file (odoo.conf).
   • If you haven't set one, you need to find or set it manually.

3. Finding or Setting the Master Password

Option 1: Check Existing Configuration

• Open your odoo.conf file (/etc/odoo/odoo.conf on Linux or C:\Program Files\Odoo 18\server\odoo.conf on Windows).
• Look for the admin_passwd line:

  
  admin_passwd = mysecurepassword
  

  
  

Option 2: Set a New Master Password

If you don’t know it, set a new one in odoo.conf:

ini

admin_passwd = newpassword

Then restart Odoo:

bash

sudo systemctl restart odoo  # Linux
net stop odoo18 && net start odoo18  # Windows

4. Final Steps

• After restoring, log in with your existing Odoo admin credentials (from the cloud version).
• Verify that everything (modules, filestore, customizations) is working.
• If attachments are missing, manually copy the filestore as explained in the first method.

Comparison of Both Methods

Thanks & Regards,
Sunny Sheth