##############################

# Step 1: Backup Database on Source Server

##############################

# Connect to source server

ssh user@source_server_ip

# Switch to postgres user

sudo su - postgres

# Backup database 'igbssaas'

pg_dump igbssaas > /tmp/igbssaas_backup.sql

# Compress backup (optional)

gzip /tmp/igbssaas_backup.sql

# Exit postgres

exit

##############################

# Step 2: Backup Filestore on Source Server

##############################

cd /opt/odoo18/.local/share/Odoo/filestore/

tar -czvf igbssaas_filestore.tar.gz igbssaas

##############################

# Step 3: Transfer Backup Files to Destination Server

##############################

# Database

scp /tmp/igbssaas_backup.sql.gz user@destination_server_ip:/tmp/

# Filestore

scp /opt/odoo18/.local/share/Odoo/filestore/igbssaas_filestore.tar.gz user@destination_server_ip:/opt/custom/

##############################

# Step 4: Restore Database on Destination Server

##############################

ssh user@destination_server_ip

sudo su - postgres

# Create database

psql -c "CREATE DATABASE igbssaas;"

# Restore database

gunzip /tmp/igbssaas_backup.sql.gz

psql igbssaas < /tmp/igbssaas_backup.sql

# Set proper owner

psql -c "ALTER DATABASE igbssaas OWNER TO odoo;"

exit

##############################

# Step 5: Restore Filestore on Destination Server

##############################

# Move tar.gz to filestore

sudo mv /opt/custom/igbssaas_filestore.tar.gz /opt/odoo18/.local/share/Odoo/filestore/

cd /opt/odoo18/.local/share/Odoo/filestore/

# Extract filestore

sudo tar -xzvf igbssaas_filestore.tar.gz

# Set permissions

sudo chown -R odoo:odoo /opt/odoo18/.local/share/Odoo/filestore/igbssaas

# Optional: remove tar.gz to save space

sudo rm igbssaas_filestore.tar.gz

##############################

# Step 6: Update Odoo Config (if needed)

##############################

# Edit /etc/odoo/odoo.conf or your Odoo config

# db_user = odoo

# db_password = your_password

# db_name = igbssaas

##############################

# Step 7: Clear Odoo assets cache

##############################

cd /opt/odoo18

sudo -u odoo18 python3 odoo/odoo-bin -d yuccaloc -u web --stop-after-init

SELECT id, name, res_model, res_id, res_field, type, store_fname, mimetype, file_size

FROM ir_attachment

ORDER BY id DESC

LIMIT 2;

SELECT id, name, res_model, res_id, res_field, type, store_fname, mimetype, file_size

FROM ir_attachment

WHERE store_fname = '79/7965f5fbd7ebca2e586a4a4443ab68efa015ec7b';