To back up a locally hosted Odoo instance, follow these steps to ensure all critical components (database, filestore, custom code, and configurations) are safely backed up:<\/p>\n\n\n\n
Odoo uses PostgreSQL<\/strong> for its database. Use Command:<\/strong><\/p>\n\n\n\n Odoo stores attachments (e.g., documents, images) in the filestore<\/strong> directory. Locate it in your Odoo config file ( Command:<\/strong><\/p>\n\n\n\n If you\u2019ve added custom modules or modified Odoo source code, back up these directories:<\/p>\n\n\n\n Command:<\/strong><\/p>\n\n\n\n Back up your Odoo configuration file and any server configurations (e.g., Nginx\/Apache, service files).<\/p>\n\n\n\n Command:<\/strong><\/p>\n\n\n\n Create a script ( Script Example:<\/strong><\/p>\n\n\n\n Add to Cron (run daily):<\/strong><\/p>\n\n\n\n To restore Odoo from a backup:<\/p>\n\n\n\n By following these steps, you\u2019ll ensure a complete backup of your Odoo instance, minimizing downtime and data loss risks.<\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" To back up a locally hosted Odoo instance, follow these steps to ensure all critical components (database, filestore, custom code, and configurations) are safely backed up: 1. Backup the Odoo Database Odoo uses PostgreSQL for its database. Use pg_dump to create a SQL dump of your database. Command: 2. Backup the Filestore Odoo stores attachments […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-634","post","type-post","status-publish","format-standard","hentry","category-ict"],"_links":{"self":[{"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/posts\/634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/comments?post=634"}],"version-history":[{"count":1,"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/posts\/634\/revisions"}],"predecessor-version":[{"id":635,"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/posts\/634\/revisions\/635"}],"wp:attachment":[{"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/media?parent=634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/categories?post=634"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/remote-support.space\/wordpress\/wp-json\/wp\/v2\/tags?post=634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}pg_dump<\/code> to create a SQL dump of your database.<\/p>\n\n\n\npg_dump -U <postgres_username> -F p <database_name> > \/path\/to\/backup\/odoo_db_$(date +%Y-%m-%d).sql<\/code><\/pre>\n\n\n\n\n
<postgres_username><\/code> and <database_name><\/code> with your PostgreSQL credentials.<\/li>\n\n\n\npg_dump -U odoo -F p odoo_production > ~\/backups\/odoo_db_2023-10-01.sql<\/code><\/li>\n<\/ul>\n\n\n\n
\n\n\n\n2. Backup the Filestore<\/strong><\/h3>\n\n\n\n
odoo.conf<\/code>):<\/p>\n\n\n\n# Find the filestore path (default: ~\/.local\/share\/Odoo\/filestore)\ngrep data_dir \/etc\/odoo\/odoo.conf\n\n# Copy the filestore directory\ncp -r ~\/.local\/share\/Odoo\/filestore\/<database_name> \/path\/to\/backup\/filestore_$(date +%Y-%m-%d)<\/code><\/pre>\n\n\n\n
\n\n\n\n3. Backup Custom Modules\/Code<\/strong><\/h3>\n\n\n\n
\n
~\/odoo-custom-addons<\/code>)<\/li>\n\n\n\n\/opt\/odoo\/odoo<\/code>).<\/li>\n<\/ul>\n\n\n\ntar -czvf \/path\/to\/backup\/odoo_custom_code_$(date +%Y-%m-%d).tar.gz \\\n ~\/odoo-custom-addons \\\n \/opt\/odoo\/odoo<\/code><\/pre>\n\n\n\n
\n\n\n\n4. Backup Configuration Files<\/strong><\/h3>\n\n\n\n
cp \/etc\/odoo\/odoo.conf \/path\/to\/backup\/odoo.conf_$(date +%Y-%m-%d)<\/code><\/pre>\n\n\n\n
\n\n\n\n5. Automate Backups (Optional)<\/strong><\/h3>\n\n\n\n
\/path\/to\/backup_odoo.sh<\/code>) to automate daily backups:<\/p>\n\n\n\n#!\/bin\/bash\nBACKUP_DIR=\"\/path\/to\/backups\"\nDB_NAME=\"odoo_production\"\nDB_USER=\"odoo\"\nDATE=$(date +%Y-%m-%d)\n\n# Backup database\npg_dump -U $DB_USER -F p $DB_NAME > $BACKUP_DIR\/odoo_db_$DATE.sql\n\n# Backup filestore\nrsync -avr ~\/.local\/share\/Odoo\/filestore\/$DB_NAME $BACKUP_DIR\/filestore_$DATE\n\n# Backup custom code\ntar -czvf $BACKUP_DIR\/odoo_custom_code_$DATE.tar.gz ~\/odoo-custom-addons\n\n# Backup config\ncp \/etc\/odoo\/odoo.conf $BACKUP_DIR\/odoo.conf_$DATE\n\n# Delete backups older than 30 days\nfind $BACKUP_DIR -type f -mtime +30 -delete<\/code><\/pre>\n\n\n\ncrontab -e\n# Add this line to run at 2 AM daily:\n0 2 * * * \/bin\/bash \/path\/to\/backup_odoo.sh<\/code><\/pre>\n\n\n\n
\n\n\n\n6. Restoring from Backup<\/strong><\/h3>\n\n\n\n
\n
createdb -U <postgres_user> <new_db_name>\n psql -U <postgres_user> <new_db_name> < \/path\/to\/backup\/odoo_db_2023-10-01.sql<\/code><\/pre>\n\n\n\n\n
cp -r \/path\/to\/backup\/filestore_2023-10-01 ~\/.local\/share\/Odoo\/filestore\/<new_db_name><\/code><\/pre>\n\n\n\n\n
Extract the .tar.gz<\/code> file and replace the relevant directories\/configs.<\/li>\n<\/ol>\n\n\n\n
\n\n\n\nAdditional Tips<\/strong><\/h3>\n\n\n\n
\n
Go to Settings > Database > Backup<\/code> in the Odoo web interface to download a .zip<\/code> backup (includes database + filestore).<\/li>\n\n\n\ngpg<\/code> for sensitive data.<\/li>\n\n\n\n
\n\n\n\n