Enable Dark Mode!
By: Akhil Ashok

How to Import Database in Odoo Sh

Technical Odoo 17

In the world of Odoo, efficient database management is crucial for smooth business operations. The process of uploading and importing backups in Odoo SH is a pivotal aspect of database management for users looking to seamlessly transition between versions or safeguard their data. By navigating through well-defined steps, starting from accessing the backups tab and making choices based on the dump size, users can efficiently handle the import process.

This blog provides a comprehensive guide on how to import databases in Odoo SH. This comprehensive guide not only demystifies the complexities of backup uploading and database importing but also underscores the importance of a systematic and secure approach. By following these steps, Odoo SH users can confidently manage their application data, fostering a resilient and well-maintained environment.

Upload the backup

By clicking the backups tab of your production branch, you can import the backup you just downloaded.

How to Import Database in Odoo Sh-cybrosys

After clicking the "Import Database" button, a popup with two options will appear.

1. Through your browser(Easier for dumps smaller than 2GB).

2. Through SSH(for dumps over 2GB).

Through your Browser

After selecting the first option, ensure you're on a stable internet connection. Then, you will find a browse button; select the file and click on the import button located at the bottom.

How to Import Database in Odoo Sh-cybrosys

Through SSH

If the dumps are more than 2GB, we can choose the second option to import.

Adding Access Key to Your Profile

Generate a new SSH key on your local machine. Once generated, add the public key to your profile. Open the terminal, paste the text below, and replace the example email with your GitHub email address.

ssh-keygen -t ed25519 -C "your_email@example.com"

When prompted to "Enter a file in which to save the key," simply press Enter to accept the default file location.

After saving the public key, navigate to the specified location, copy the key, and then paste the SSH key under your profile.

How to Import Database in Odoo Sh-cybrosys

After adding the public key to your profile. To import the database through SSH, you can use the following command:

rsync -P --inplace <zip_dump_file>  

Upon completion of the rsync upload, initiate the process by clicking the Import button.

How to Import Database in Odoo Sh-cybrosys

After importing the backup, database access can be obtained by clicking the Connect button within the branch history.

How to Import Database in Odoo Sh-cybrosys

For smaller dumps, the browser option offers simplicity, while larger dumps exceeding 2GB necessitate the secure and efficient SSH route. The addition of an access key to the user's profile enhances security during the import process. The step-by-step guide for generating, saving, and adding the SSH key ensures a smooth and secure pathway.

Whether through the browser or SSH, the process culminates with the click of the Import button, initiating the transfer of data. Once the rsync upload is completed, users gain access to their imported database by utilizing the Connect button within the branch history.

If you need any assistance in odoo, we are online, please chat with us.



i have done the same process i see that the database size file is 4GB but until now i didn't see filestore




Leave a comment




Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635



Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.



Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message