On 2007-11-30 12:40, fedora wrote:

Hi guys,

Normally I do amrecover command to restore backups. Here is my way to
recover:

amrecover> sethost ind.indo.com
amrecover> setdisk /var/lib/mysql
amrecover> history for config DailySet1
200- Dump history for config "DailySet1" host "ind.indo.com" disk
/var/lib/mysql
201- 2007-11-29-03-00-01 1 DailySet1-26:7
201- 2007-11-28-03-00-01 1 DailySet1-23:18
201- 2007-11-27-03-00-01 1 DailySet1-22:10
201- 2007-11-26-09-45-31 0 DailySet1-20:15
201- 2007-11-23-03-00-01 0 DailySet1-18:12
201- 2007-11-22-03-00-01 0 DailySet1-17:15
201- 2007-11-21-03-00-01 0 DailySet1-16:5
201- 2007-11-20-03-00-01 0 DailySet1-15:5
201- 2007-11-19-03-00-01 0 DailySet1-30:5
201- 2007-11-18-03-00-02 0 DailySet1-03:5
201- 2007-11-17-03-00-01 0 DailySet1-01:6
201- 2007-11-16-03-00-01 0 DailySet1-13:6
201- 2007-11-15-03-00-01 0 DailySet1-12:8
201- 2007-11-14-03-00-02 1 DailySet1-11:2
201- 2007-11-13-03-00-01 1 DailySet1-10:2
201- 2007-11-12-03-00-01 1 DailySet1-09:10
201- 2007-11-11-03-00-02 1 DailySet1-08:2
201- 2007-11-10-03-00-01 1 DailySet1-07:3
201- 2007-11-09-15-50-58 1 DailySet1-06:49
201- 2007-11-08-03-00-02 1 DailySet1-06:36
201- 2007-11-07-03-00-02 1 DailySet1-06:21
201- 2007-11-06-16-46-15 1 DailySet1-06:6
200 Dump history for config "DailySet1" host "ind.indo.com" disk
/var/lib/mysql

amrecover> add *
Added dir /Telkomsel_Wallpaper/ at date 2007-11-26-09-45-31
Added dir /Telkomsel_Wallpaper/ at date 2007-11-29-03-00-01
Added dir /Telkomsel_TrueTone/ at date 2007-11-26-09-45-31
Added dir /Telkomsel_TrueTone/ at date 2007-11-29-03-00-01
--- output truncated ---

1) If I do "add *", it i'll add the current backup or the whole month?  What
I have found when I "add *" it only added backup for 26 and 29 Nov 2007 for

the same DB even backup is running daily.

You request to restore the files in the state as found on the "setdate"
command (default to today).  To accomplish this Amanda looks in its
history add collects all necessary levels (level 0, last level 1, last
level 2, etc.).

2) I can choose the date if I want to recover only for that day but if I
want to recover the whole month how?. I am a bit confused. Actually I want
to restore backup for the whole month before tapes being rotated.

You're confused about the concepts of backups, or at least, you're
using terms nobody else understands.
What is your definition of "recover a whole month"  versus "recover
only for that day"?

one of them.  You cannot take them all 5.

You can take a picture on your birthday, and you can look at each
picture taken previously and watch growing older.  But you cannot look
at 1 picture where all your ages are on the same picture (unless you
use gimp and copy/paste each face next too the previous one -- just as
you can restore each backup in a different directory, and indeed
have a whole month restored).

--
Paul Bijnens, xplanation Technology Services        Tel  +32 16 397.511
Technologielaan 21 bus 2, B-3001 Leuven, BELGIUM    Fax  +32 16 397.512
http://www.xplanation.com/          email:  Paul.Bijnens AT xplanation DOT com
***********************************************************************
* I think I've got the hang of it now:  exit, ^D, ^C, ^\, ^Z, ^Q, ^^, *
* F6, quit, ZZ, :q, :q!, M-Z, ^X^C, logoff, logout, close, bye, /bye, *
* stop, end, F3, ~., ^]c, +++ ATH, disconnect, halt,  abort,  hangup, *
* PF4, F20, ^X^X, :D::D, KJOB, F14-f-e, F8-e,  kill -1 $$,  shutdown, *
* init 0, kill -9 1, Alt-F4, Ctrl-Alt-Del, AltGr-NumLock, Stop-A, ... *
* ...  "Are you sure?"  ...   YES   ...   Phew ...   I'm out          *
***********************************************************************