02-25-2013
I am no dba but what i would do is dump the table into a flat file...fill in the missing date time rows using perl...load it back into the date table...and if all of this sounds like baloney feel free to ignore it...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi ,
I have two variables both containg dates,
x= `date`
and
y= `date'
their format being -> Fri Nov 12 22:59:50 MST 2004
how do I compare which one is greater.
->Can dates be converted into integer and then compared?
( one lengthy way would be to compare the words one by... (7 Replies)
Discussion started by: k_oops9
7 Replies
2. Shell Programming and Scripting
Hello friends,
I am looking for a script or method that can display all the dates between any 2 given dates.
Input:
Date 1
290109
Date 2
010209
Output:
300109
310109
Please help me. Thanks. :):confused: (2 Replies)
Discussion started by: frozensmilz
2 Replies
3. Programming
Hello,
I am working on a program in C and need to read, write and manage Dates (YYY-MM-DD HH:MM). I have made my own version of a structure to store the date data and something else. Do you recommend me to use the time.h library? In such case, is it worthwhile to have an structure containing... (1 Reply)
Discussion started by: Ister
1 Replies
4. Programming
Don't know if it is important: Debian Linux / MySQL 5.1
I have a table:
media_id int(8)
group_id int(8)
type_id int(8)
expiration date
start date
cust_id int(8)
num_runs int(8)
preferred_time int(8)
edit_date timestamp ON UPDATE CURRENT_TIMESTAMP
id... (0 Replies)
Discussion started by: vertical98
0 Replies
5. Emergency UNIX and Linux Support
Hi guys,
For my wiki site I need to fix 1400 pages that use the wrong date format, most pages (not all) use eg. 1988]] I need to change that to (1988)]]
The date range goes back to 1400 so I guess I need to do the following
ssh into my server,
dump mysql database
vi .sql dump
search... (20 Replies)
Discussion started by: lawstudent
20 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I am trying to print the dates that falls between 2 date variables into a file. Here is the example.
$BUS_DATE =20120616
$SUB_DATE=20120613
Output to file abc.txt should be : 20120613,20120614,120120615,20120616
Can you pls help me accomplish this in LINUX.
Thanks... (5 Replies)
Discussion started by: dsfreddie
5 Replies
7. Shell Programming and Scripting
HI,
i have row like this
HHH100037440313438961000201001012012073110220002 N
in this i have 2 dates in pos 25-32 and 33-40 , so based upon the se two dates , i need to generated records between these two values
so in the above record 20100101 and 20120731
need to genearte rows like this... (4 Replies)
Discussion started by: sathishsr
4 Replies
8. Shell Programming and Scripting
HI,
to my shell script i pass two parameters date1 and date2
is there any way to get all dates betwen these two dates?
if i pass 20130714 and 20130717 i need to get below dates
20130715
20130716
is it possible.
thanks (3 Replies)
Discussion started by: ulab
3 Replies
9. Shell Programming and Scripting
Hi Experts,
I have written the below script to check the missing files based on the date in the file name from current date to in a given interval of days.
In the file names we have dates along with some name. ex:jera_sit_2017-04-25-150325.txt.
The below script is working fine if we have only... (10 Replies)
Discussion started by: nalu
10 Replies
10. Shell Programming and Scripting
Hi All,
I have 2 dates in mm/dd format.
sdate=10/01 (October 01)
edate=10/10 (October 10)
I need the dates in between these 2 dates like below.
10/01
10/02
10/03
10/04
10/05
10/06
10/07
10/08 (1 Reply)
Discussion started by: jayadanabalan
1 Replies
LEARN ABOUT XFREE86
backup_volinfo
BACKUP_VOLINFO(8) AFS Command Reference BACKUP_VOLINFO(8)
NAME
backup_volinfo - Displays a volume's dump history from the Backup Database
SYNOPSIS
backup volinfo -volume <volume name> [-localauth]
[-cell <cell name>] [-help]
backup voli -v <volume name>
[-l] [-c <cell name>] [-h]
DESCRIPTION
The backup volinfo command displays a dump history of the specified volume, reporting information such as the date on which the volume was
dumped and the tapes that contain it. Include the ".backup" extension on the volume name if the backup version of the volume was dumped.
OPTIONS
-volume <volume name>
Names the volume for which to display the dump history. Include the ".backup" or ".readonly" extension if the backup or read-only
version of the volume was dumped.
-localauth
Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The backup command interpreter presents it to
the Backup Server, Volume Server and VL Server during mutual authentication. Do not combine this flag with the -cell argument. For more
details, see backup(8).
-cell <cell name>
Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see backup(8).
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The output includes a line for each Backup Database dump record that mentions the specified volume, order from most to least recent. The
output for each record appears in a table with six columns:
dumpID
The dump ID of the dump that includes the volume.
lvl The depth in the dump hierarchy of the dump level at which the volume was dumped. A value of 0 indicates a full dump. A value of 1 or
greater indicates an incremental dump made at the specified depth in the dump hierarchy.
parentid
The dump ID of the dump's parent dump. A value of 0 indicates a full dump, which has no parent; in this case, the value in the "lvl"
column is also 0.
creation date
The date and time at which the Backup System started the dump operation that created the dump.
clone date
For a backup or read-only volume, the time at which it was cloned from its read/write source. For a read/write volume, the same as the
value in the "creation date" field.
tape name
The name of the tape containing the dump: either the permanent tape name, or an AFS tape name in the format
volume_set_name.dump_level_name.tape_index where volume_set_name is the name of the volume set associated with the initial dump in the
dump set of which this tape is a part; dump_level_name is the name of the dump level at which the initial dump was backed up;
tape_index is the ordinal of the tape in the dump set. Either type of name can be followed by a dump ID in parentheses; if it appears,
it is the dump ID of the initial dump in the dump set to which this appended dump belongs.
EXAMPLES
The following example shows part of the dump history of the Backup volume "user.smith.backup":
% backup volinfo -volume user.smith.backup
DumpID lvl parentID creation date clone date tape name
924600000 1 924427600 04/20/1999 05:20 04/20/1999 05:01 user_incr_2 (924514392)
924514392 1 924427600 04/19/1999 05:33 04/19/1999 05:08 user_incr_2
924427600 0 0 04/18/1999 05:26 04/18/1999 04:58 user_full_6
. . . . . . . .
. . . . . . . .
PRIVILEGE REQUIRED
None
SEE ALSO
backup(8), backup_dumpinfo(8), backup_volrestore(8)
COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 BACKUP_VOLINFO(8)