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
DUMP(1M) DUMP(1M)
NAME
dump - incremental file system dump
SYNOPSIS
dump [ key [ argument ... ] filesystem ]
DESCRIPTION
Dump copies to magnetic tape all files changed after a certain date in the filesystem. The key specifies the date and other options about
the dump. Key consists of characters from the set 0123456789fusd.
f Place the dump on the next argument file instead of the tape.
u If the dump completes successfully, write the date of the beginning of the dump on file `/etc/ddate'. This file records a separate
date for each filesystem and each dump level.
0-9 This number is the `dump level'. All files modified since the last date stored in the file `/etc/ddate' for the same filesystem at
lesser levels will be dumped. If no date is determined by the level, the beginning of time is assumed; thus the option 0 causes the
entire filesystem to be dumped.
s The size of the dump tape is specified in feet. The number of feet is taken from the next argument. When the specified size is
reached, the dump will wait for reels to be changed. The default size is 2300 feet.
d The density of the tape, expressed in BPI, is taken from the next argument. This is used in calculating the amount of tape used per
write. The default is 1600.
If no arguments are given, the key is assumed to be 9u and a default file system is dumped to the default tape.
Now a short suggestion on how perform dumps. Start with a full level 0 dump
dump 0u
Next, periodic level 9 dumps should be made on an exponential progression of tapes. (Sometimes called Tower of Hanoi - 1 2 1 3 1 2 1 4 ...
tape 1 used every other time, tape 2 used every fourth, tape 3 used every eighth, etc.)
dump 9u
When the level 9 incremental approaches a full tape (about 78000 blocks at 1600 BPI blocked 20), a level 1 dump should be made.
dump 1u
After this, the exponential series should progress as uninterrupted. These level 9 dumps are based on the level 1 dump which is based on
the level 0 full dump. This progression of levels of dump can be carried as far as desired.
FILES
default filesystem and tape vary with installation.
/etc/ddate: record dump dates of filesystem/level.
SEE ALSO
restor(1), dump(5), dumpdir(1)
DIAGNOSTICS
If the dump requires more than one tape, it will ask you to change tapes. Reply with a new-line when this has been done.
BUGS
Sizes are based on 1600 BPI blocked tape. The raw magtape device has to be used to approach these densities. Read errors on the filesys-
tem are ignored. Write errors on the magtape are usually fatal.
DUMP(1M)