Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I am using Odoo 11 CE
I tried to backup and restore by database by PSQL dump.
Step1 : Backup my database named rck_test5
sudo pg_dump -U rck10 -h localhost -p 5432 rck_test5 > /odoo/backups/new
Step2: Created new db
createdb -O rck10 rck_test6
Step3: Restore the database
psql -U rck10 -d rck_test6 -f /odoo/backups/new
Everything works fine. But when restored, I am missing all icons and images attached.
I found that these files are stored in ./local/share/Odoo/filestore/dbname when we create or restore database from ui.
When we restore using UI, filestore is zipped and restored properly.
But when we want to restore a database that is more than 10 GB, it is adviced to use psql dump.
I tried setting data_dir path in odoo-server.conf. But it does not generate filestore.
I need to know how to backup and restore filestore using command line. (Reason : I get to see full log of what is happening when we restore a huge database)
Please guide how to
* Backup a filestore
* Restore a filestore
* Update path in ir_attachement.location
to set odoo to read the new filestore location. Please guide me
first you go into your filestore directory, and existing directory copy and paste with new db name.
in your case,
now you first delete created automatically Filestore folder in directory.
apply command ==> sudo rm -R rck_test6
after that copy existing filestore db and paste with new name.
sudo cp -R rck_test5 rck_test6
after restart your server and check, all icons and images are displayed same as old db.
I hope it will help you.