guys i need some help in writing a shell script, what i am trying to write is a shell script that can delete generated trace files my software usually generated everyday, i will give an example to make it easy to understand
what i am trying to do is crating a script that will delete only yesterday files and keep only latest 2 files for security reasons.
my attempt in creating was like that to delete all yesterday file
now how can i delete yesterday files and keep latest 2 files?
Hi.
I'm trying to write a script that will delete all directories found, that are not named as a "number" (year)...
here is what i mean, let's say i have within /data/exports the following directories:
/data/exports/2000
/data/exports/2001
/data/exports/2002
/data/exports/daily/2000... (5 Replies)
i want to delete all the files in my directory except the latest one. i need to do this from shell script.
say i have
a.txt - latest file
b.txt,
c.txt..
it should delete all the files except a.txt? (4 Replies)
Id like to delete a line from a file using (preferably a single line unix command) if it contains a certain string pattern.
If line contains "abcdef" then delete that line.
Help greatly appreciated. (7 Replies)
Hi,
Need to delete line prior to (INSERT/UPDATE/DELETE). In case ' available, then keep that. Pls refet below details.
Input
======================
l_s := ' INSERT INTO TEST'
l_P PD := ' UPDATE INTO TEST'
l_D := ' DELETE INTO TEST'
This is test
Output... (4 Replies)
I have a local linux machine in which the files are dumped by a remote ubuntu server. If the process in remote server has any problem then empty files are created in local machine. Is there any way using perl script to check if the empty files are being created and delete them and then run a shell... (2 Replies)
hi :)
I need to delete partial duplicate lines
I have this in a file
sihp8027,/opt/cf20,1980182
sihp8027,/opt/oracle/10gRelIIcd,155200016
sihp8027,/opt/oracle/10gRelIIcd,155200176
sihp8027,/var/opt/ERP,10376312
and need to leave it like this:
sihp8027,/opt/cf20,1980182... (2 Replies)
Hello, this is probably a simple request but I've been toying with it for a while.
I have a large list of devices and commands that were run with a script, now I have lines such as:
a-router-hostname-C#show ver
I want to print everything up to (and excluding) the # and everything after it... (3 Replies)
Hello Mates,
I would request your help in a shell script,
simply I need to delete some matching db table records (rows) to ones in a given file:
------------------------------
#!/bin/bash
SQL="delete from numberlist where msidn='';"
MYSQL_USER="<your-user>"... (4 Replies)
Background: I use a TV tuner card to capture OTA video files (.mpeg) and then my Plex Media Server automatically optimizes the files (transcodes for better playback) and places them in a new directory. I have another Plex Library pointing to the new location for the optimized .mp4 files. This... (2 Replies)
Discussion started by: shaky
2 Replies
LEARN ABOUT PHP
dba_open
DBA_OPEN(3) 1 DBA_OPEN(3)dba_open - Open databaseSYNOPSIS
resource dba_open (string $path, string $mode, [string $handler], [mixed $...])
DESCRIPTION dba_open(3) establishes a database instance for $path with $mode using $handler.
PARAMETERS
o $path
- Commonly a regular path in your filesystem.
o $mode
- It is r for read access, w for read/write access to an already existing database, c for read/write access and database creation
if it doesn't currently exist, and n for create, truncate and read/write access. The database is created in BTree mode, other
modes (like Hash or Queue) are not supported. Additionally you can set the database lock method with the next char. Use l to lock
the database with a .lck file or d to lock the databasefile itself. It is important that all of your applications do this consis-
tently. If you want to test the access and do not want to wait for the lock you can add t as third character. When you are abso-
lutely sure that you do not require database locking you can do so by using - instead of l or d. When none of d, l or - is used,
dba will lock on the database file as it would with d.
Note
There can only be one writer for one database file. When you use dba on a web server and more than one request requires
write operations they can only be done one after another. Also read during write is not allowed. The dba extension uses locks
to prevent this. See the following table:
DBA locking
+-------------+---------------+---+---+---+---+---+---+---+
|already open | | | | | | | | |
| | | | | | | | | |
| | $mode = "rl" | | | | | | | |
| | | | | | | | | |
| | $mode = "rlt" | | | | | | | |
| | | | | | | | | |
| | $mode = "wl" | | | | | | | |
| | | | | | | | | |
| | $mode = "wlt" | | | | | | | |
| | | | | | | | | |
| | $mode = "rd" | | | | | | | |
| | | | | | | | | |
| | $mode = "rdt" | | | | | | | |
| | | | | | | | | |
| | $mode = "wd" | | | | | | | |
| | | | | | | | | |
| | $mode = "wdt" | | | | | | | |
| | | | | | | | | |
+-------------+---------------+---+---+---+---+---+---+---+
| not open | | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
|$mode = "rl" | | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | wait | | | | | | | |
| | | | | | | | | |
| | false | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
|$mode = "wl" | | | | | | | | |
| | | | | | | | | |
| | wait | | | | | | | |
| | | | | | | | | |
| | false | | | | | | | |
| | | | | | | | | |
| | wait | | | | | | | |
| | | | | | | | | |
| | false | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
|$mode = "rd" | | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | ok | | | | | | | |
| | | | | | | | | |
| | wait | | | | | | | |
| | | | | | | | | |
| | false | | | | | | | |
| | | | | | | | | |
|$mode = "wd" | | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | illegal | | | | | | | |
| | | | | | | | | |
| | wait | | | | | | | |
| | | | | | | | | |
| | false | | | | | | | |
| | | | | | | | | |
| | wait | | | | | | | |
| | | | | | | | | |
| | false | | | | | | | |
| | | | | | | | | |
+-------------+---------------+---+---+---+---+---+---+---+
ook: the second call will be successfull.
owait: the second call waits until dba_close(3) is called for the first.
ofalse: the second call returns false.
oillegal: you must not mix
"l" and "d" modifiers for $mode parameter.
o $handler
- The name of the handler which shall be used for accessing $path. It is passed all optional parameters given to dba_open(3) and
can act on behalf of them.
RETURN VALUES
Returns a positive handle on success or FALSE on failure.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 4.3.0 | |
| | |
| | It's possible to open database files over net- |
| | work connection. However in cases a socket con- |
| | nection will be used (as with http or ftp) the |
| | connection will be locked instead of the resource |
| | itself. This is important to know since in such |
| | cases locking is simply ignored on the resource |
| | and other solutions have to be found. |
| | |
+--------+---------------------------------------------------+
SEE ALSO dba_popen(3), dba_close(3).
PHP Documentation Group DBA_OPEN(3)