Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
backup
9 ตอบกลับ
103650 มุมมอง
อวตาร
rakhmat dp

excuse me, I am new in this field ,

how to make a backup of the database on odoo_8.0 ??

whether someone who can answer ?

Thank you

 

อวตาร
ละทิ้ง
อวตาร
Yenthe Van Ginneken (Mainframe Monkey)
คำตอบที่ดีที่สุด

Hi rakhmat,
You have four options.

  • Take a dump through the webinterface, via the URL:

    http://www.yourweburl.com:8069/web/database/manager
    Then click on "Backup database", you can take a dump from there.
  • Use a back-up module, as you can find here. This module is made by me so if you need help, let me know.

  • Take a dump through the terminal, via pg_dump.

    pg_dump db_name

  • Take a dump through XML-RPC.

     def get_db_list(self, cr, user, ids, host='localhost', port='8069', context={}):
        uri = 'http://' + host + ':' + port
        conn = xmlrpclib.ServerProxy(uri + '/xmlrpc/db')
        db_list = execute(conn, 'list')
        return db_list
อวตาร
ละทิ้ง
Temur

upvote for xmlrpc option ;)

Yenthe Van Ginneken (Mainframe Monkey)

Thanks Temur! :) I think its a handy option if you wish to work with automated back-ups!

Jonathan Leaders

This does not backup the file store. Isn't the file store also a required piece of Odoo to backup for it to function or be restored at another location?

Yenthe Van Ginneken (Mainframe Monkey)

It does backup the filestore if you choose the right format (zip).

อวตาร
Md. Sajib Ali
คำตอบที่ดีที่สุด

video reference here


อวตาร
ละทิ้ง
อวตาร
Dharmesh Chudasama
คำตอบที่ดีที่สุด

Odoo database backup in local/server : 

อวตาร
ละทิ้ง
อวตาร
rakhmat dp
ผู้เขียน คำตอบที่ดีที่สุด

Thank you buddy,

for all the answers useful ,


greetings ^ - ^

 

อวตาร
ละทิ้ง
อวตาร
TecDiSol
คำตอบที่ดีที่สุด

i backup

Going to "My odoo.com Account" then click "Manage My Organizations", then "Backup"

อวตาร
ละทิ้ง
อวตาร
Hilar Andikkadavath
คำตอบที่ดีที่สุด

You can use this addon for backup.

https://apps.odoo.com/apps/modules/13.0/auto_backup_odoo/

https://automaticbackup.odoo.com/

How to backup odoo database automatically

Available Backup DB/Filestore Modes:

  • Local
  • Remote Server
  • Google Drive
  • Dropbox

Module For backup ODOO databases and automating the backup process of ODOO.

  • Multiple Backup Modes
  • Filestore Backup
  • Backup ODOO Databases in specified path
  • Detailed Message Log
  • Backup Status Information and History
  • User can select the format to dump, either custom archive, plain text SQL or tar archive
  • Archive Backup Process
  • Repeat Missed Backup Process

Features

  • Dump ODOO Database in specified format
  • Output a custom archive suitable for input into pg_restore. This is the most flexible format in that it allows the reordering of loading data as well as to object definitions. This format is also compressed by default. Here we user gzip ie, test.gz, We also recommend you to select Custom, because Using the custom format you can restore single objects from a backup.
  • Output a plain-text SQL script file (the default). The plain text format is useful for very small databases with a minimal number of objects but other than that, it should be avoided.
  • Output a tar archive suitable for input into pg_restore. Using this archive format allows reordering and/or exclusion of database objects at the time the database is restored. It is also possible to limit which data is reloaded at restore time. we use tar with gzip
  • Backup Filestore
  • Multiple backup modes at sametime

Get Module From Here


Video Demonstration

อวตาร
ละทิ้ง
อวตาร
Temur
คำตอบที่ดีที่สุด

AFAIK there is no particular way for odoo. You can backup database using pg_dump (see here) or any other postgresql specific way. 

update:

if you mean backup from user interface, then there is backup option at /web/database/manager page in odoo. The "Database Management/Backup"

อวตาร
ละทิ้ง
Yenthe Van Ginneken (Mainframe Monkey)

http://yoururl.com:8069/web/database/manager has support for taking dumps from the webinterface.

Temur

Thanks Yenthe, I've updated answer. But this way allows only manual backup, that's why I don't consider it as option. gp_dump way may be easily automated using some tools (cron etc.).

Yenthe Van Ginneken (Mainframe Monkey)

Yeah there are actually 3 options really. I'll expand my answer too.

Temur

I've not seen if you've separated answer, I thought you just commented here, that's why I've updated my answer with you option.. :) BTW the xmlprc option needs to adapt a bit? it seems that function is for gather database list?

Yenthe Van Ginneken (Mainframe Monkey)

Correct, this function calls the database list and from there on you need to carry on. You can find all the code here: https://github.com/Yenthe666/auto_backup/tree/8.0/auto_backup my module does this exactly.

Temur

does this module includes filestore backup?

Yenthe Van Ginneken (Mainframe Monkey)

Yep! It generates a .dump file which has an SQL file and everything from the filestore is also in the dump file.

อวตาร
sameer alhwety
คำตอบที่ดีที่สุด

You  use xmlrpc or from link with /web/database/manager

อวตาร
ละทิ้ง
อวตาร
Ankit H Gandhi(AHG)
คำตอบที่ดีที่สุด

Hello Rakhmat,


Please refer below link it will be help you.


http://maheshwarimayur.blogspot.in/2013/02/backup-and-restore-openerp-database.html

http://acespritechblog.com/2012/05/21/how-to-backup-and-restore-openerp-database/

อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 แก้ไขแล้ว
backup
อวตาร
อวตาร
อวตาร
อวตาร
อวตาร
9
ก.ค. 25
67296
Backup Odoo 12 database using Ubuntu command line
backup
อวตาร
อวตาร
1
ก.ค. 22
5850
how to backup a saas database and restore on a local server แก้ไขแล้ว
backup
อวตาร
อวตาร
อวตาร
อวตาร
อวตาร
12
มิ.ย. 24
23082
i can't delete
backup
อวตาร
0
เม.ย. 22
50
Error installing auto-backup on Oddo 15 แก้ไขแล้ว
backup
อวตาร
อวตาร
อวตาร
2
มี.ค. 22
5012