29 lines
1.3 KiB
Plaintext
29 lines
1.3 KiB
Plaintext
Backup Commands
|
|
========================
|
|
1. command: console\cakce Backup generateAccessInfo
|
|
Run it only once to generate accessinfo for records before 25 february 2018
|
|
|
|
2. command: console\cake Backup shiftExpiredRecords
|
|
Run it in every hours once
|
|
This method generates records into the table expired_records and delete all records fron access info
|
|
|
|
3. command: console\cake Backup initiateBackup
|
|
Run it in every six hours once
|
|
This method scan expire_records table and shift records to backup tables;
|
|
After taking backup, it delete records from expire_records table.
|
|
|
|
4. Command : console\cake Backup backupSingleExpense
|
|
This method shifts and backup single expense from live tables to backup tables in the production database.
|
|
|
|
5. command: console\cake Backup archieveSingleItem
|
|
Run it to archieve a sinle expense
|
|
This method shifts one single expense from backup tables(live db) to archieve database
|
|
|
|
|
|
Restore Commands
|
|
==========================
|
|
1. Command: console\cake Restore restoreSingleExpense
|
|
For restoring a single item
|
|
This methods first tries to restore single expense from backup tables to live tables. If there
|
|
is no such expense in backup table, it tries to restore from archieve database to live database.
|
|
If the expense is already exist in live tables, it does not do anything. |