Schedule Backup and Restore Database (Crontab Configuration)
This module will be work internally as command line interface (for Linux only) through linux crontab to backup and restore database.
- Backup database <DB>
- Restore as database <DB>_TEST
- Update image (i.e., with test logo) to <DB>_TEST
Just install this module, and it should work. Setup schedule time as you need it. Note: Itself, can also be used as scheduler instead of normal scheduler in OpenERP (you will see this backup and restore as one example).
- Add, Modify, Delete schedule
- Direct process through command line interface
Menu -> Setting/Technical/Scheduler/Crontab Configuration
Crontab Name - name of crontab
Description - more information
Scheduling - crontab scheduling
3.1 Minute: 0-59
3.2 Hour: 0-23
3.3 Day: 1-31
3.4 Month: 1-12
3.5 Weekday: 0-6, where 0 = Sunday
Execute Directory - OpenERP's root path to be used for log file, Temp File, DB Backup File and etc (depends on type of program)
Command - command to run the program in command line interface pattern, require full path.
Active - when True, will create crontab scheduler in OS. When False will delete it.
Attach File - Additional files, to be used in process (optional)
Note: crontab scheduler will be created only when State = Confirmed and Active = True
Backup Database Script:
Use script, db_backup.py (written in Python)db_backup.py -u <DBUser> -d <DBName> -p <BacKDir>
Example:'/home/buasri/workspace/ecosoft_official_addons/ecosoft-addons/crontab_config/db_backup.py' -u openerp -d TT -p '/home/buasri/workspace/openerp_tt'>>'/home/buasri/workspace/openerp_tt/crontab_oe.log'
- Create backup database as <dbname>_dbbackup-YYYY-MM-DD hh:mm:ss.dmp
- Create file oe_db_last_bkup.txt to be used for restoration
Restore Database Process:
Use script, db_restore.py (written in Python)db_restore.py -u <DBUser> -d <DBName> -p <BacKDir>
-i id of crontab in OpenERP, from table crontab_config -c id of Company in OpenERP, from table res_company
Example:'/home/buasri/workspace/ecosoft_official_addons/ecosoft-addons/crontab_config/db_restore.py' -u openerp -d TT_TEST -p '/home/buasri/workspace/openerp_tt'>>'/home/buasri/workspace/openerp_tt/crontab_oe.log'
- Disconnect database to be restored
- Delete database
- Create new database
- Restore it.
- Read attached logo file
- Resize logo file
- Update logo file