Additional requirement:
- zip & unzip
- rsync
- openssh
URL to backup Odoo is https://[your_ip]//web/database/backup or http://[your_ip]:8069//web/database/backup.
We can use wget to backup Odoo from localhost or from remote without interrupting Odoo service.
for local server
# wget --post-data
'master_pwd=yourpassword&name=yourdatabase&backup_format=zip' -O
backup.zip http://localhost:8069/web/database/backup
for remote server (Not Recomended: your password will send through internet in plain text)
# wget --post-data
'master_pwd=yourpassword&name=yourdatabase&backup_format=zip' -O
backup.zip http://[your_ip]:8069/web/database/backup
for remote server via https reverse proxy
# wget --post-data
'master_pwd=yourpassword&name=yourdatabase&backup_format=zip'
--no-check-certificate -O backup.zip
https://[your_ip]/web/database/backup
Backup Option:
- Use backup_format=zip to backup database and filestore
- Use backup_format=dump to backup database only
Now we can create bash file to make it easier to backup
# vi myodoobackup.sh
#!/bin/bash
## created by dedetok Sept 2016
## last update 2016-09-21
## GNU GPL v3
# create file name
now=$(date +"%Y-%m-%d")
mfname="backup_$now.zip"
#echo "$mfname"
# perform Odoo backup to output file $mfname
wget
--post-data
"master_pwd=yourpassword&name=yourdatabase&backup_format=zip"
--no-check-certificate -O "$mfname"
https://[your_ip]/web/database/backup
The file name of the output will be backup_2016-09-18.zip.
If you use local server you can use http://localhost:8069//web/database/backup
Backup to remote server
You can synchronized your backup using rsync. You need to install rsync in host and remote server.
You need to create key in your host and put it in remote
read here
Synchronized without delete (exist in remote but not exist in host)
$ rsync -avzh -e "ssh -p 22" /home/foo/test/ bar@SERVER_B:/home/bar/test/sending incremental file list./test.txtsent 389 bytes received 38 bytes 854.00 bytes/sectotal size is 395 speedup is 0.93
Synchronized with delete (delete any file in remote folder if not exist in host)
$ rsync -avzh --delete -e "ssh -p 22"
/home/foo/test/ bar@SERVER_B:
/home/bar/test/
Modification bash script
#!/bin/bash## created by dedetok Sept 2016## last update 2016-09-18## GNU GPL v3now=$(date +"%Y-%m-%d")dbname="dbname"dbserver="localhost"dbpass="dbpassword"dbmode="zip"mfname="full_"$dbname"_"$now".zip"echo "backup $dbname @ $dbserver mode $dbmode into $mfname"wget
--post-data
"master_pwd=$dbpass&name=$dbname&backup_format=$dbmode"
--no-check-certificate -O "$mfname"
"http://$dbserver:8069/web/database/backup"# synchronized to remoteecho "syncronized backup to REMOTE_B"rsync -avzh --delete -e "ssh -p 22" /home/foo/ bar@REMOTE_B:/home/bar/
Note: Single quotes won't interpolate anything, but double quotes
will (for example variables, backticks, certain \ escapes, etc...)
"test $parm" equal to 'test '$parm
References:
