Skip to Content
Menu
This question has been flagged
2 Replies
1909 Zobrazenia

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
Zrušiť

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
Zrušiť
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
Zrušiť
Related Posts Replies Zobrazenia Aktivita
0
júl 25
1822
2
nov 24
7354
2
okt 24
4083
2
aug 24
2302
3
júl 24
8760