Skip to Content
Menu
This question has been flagged
2 Replies
1761 Views

Hi, 

I have created many test product and added images and other information's like contact info. All these added for test purpose. But I want to reset the database and start like fresh database. Is there any way to reset database?  

Avatar
Discard

Before doing these activities, if you take a backup, you can restore it at a later stage.

Best Answer

Delete the Existing Database and Create a New One. 

Avatar
Discard
Best Answer

Hi,

There are a few ways to “reset” your Odoo database so you can start fresh; the right method depends on whether you’re using Odoo.sh, Odoo Online (SaaS), or your own on-premise installation:

Odoo.sh


    1 Go to your Odoo.sh project → select the branch (e.g., staging, dev).

    2 In the Database section, click the ■ (Settings) icon.

    3 Choose 'Download backup'.

    4 You’ll get a .zip file containing a PostgreSQL dump (.dump) and a filestore

    (attachments/images).

    5 Save this file before resetting your database.


Odoo Online (SaaS at odoo.com)


    1 Go to https://www.odoo.com/my/databases.

    2 Locate your database in the list and click 'Manage Database'.

    3 Click 'Download Backup'.

    4 Choose whether to include the filestore.

    5 Save the backup to restore later if needed.


On-Premise / Local Odoo


    1 Open Database Manager in your browser: http://:8069/web/database/manager.

    2 Enter the master password (defined in odoo.conf).

    3 Select the database and click 'Backup'.

    4 You’ll get a .zip file with a .dump file and filestore.

    5 Alternatively, from the command line run: pg_dump mydb > mydb.dump


After downloading the backup, you can safely reset the database and start fresh, while keeping the option to restore your old data.


Hope it helps.



Avatar
Discard
Related Posts Replies Views Activity
0
Jul 25
1721
2
Nov 24
7101
2
Oct 24
3908
2
Aug 24
2196
3
Jul 24
8608