Hi,
From the database manager: ie, from /web/database/manager you can export the db with or without filestore and from the db manager page of the new odoo instance, restore the exported db.

* Navigate to the DB manager page of existing odoo instance
* Trigger the backup process
* Once the db is exported as zip
* Open db manager page of new instance
* Click Restore button and select the already exported file and restore

Odoo database backup:  How To Back Up Database In Odoo

Thanks

Thank you guys so much !

I have used the two methods that Tobi mentions and I recommend using the database manager, since when you export the database zip, it also exports the static files. For example the images of the contacts.

The path to this directory is located in your odoo directory:

/odoo/.local/share/Odoo

If you use the pg_dump method, make sure to transfer this directory to your PC

Simply run:

pg_dump dbname > dumpfile

on your server for each database or just backup database from /web/database/manager screen