Re: how to recover the whole month backups
2007-11-30 08:30:45
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.
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.
yup. I would say you are a bit confused.
The 26th is the last full backup (the 0 in the column after the date),
and the 29th is the most recent incremental based on that full (the 1 in
the column after the date). Anything else is older, out of date,
redundant . . . whatever you want to call it. If you had messed up a
file and then it got backed up, you might want to go to an older one.
What, exactly, is it that you are trying to do? And Why?
---------------
Chris Hoogendyk
-
O__ ---- Systems Administrator
c/ /'_ --- Biology & Geology Departments
(*) \(*) -- 140 Morrill Science Center
~~~~~~~~~~ - University of Massachusetts, Amherst
<hoogendyk AT bio.umass DOT edu>
---------------
Erdös 4
|
|
|