07-28-2010
Might be a bit late for that. This is not a syntax error.
Quote:
find /WMID/data/temp/TxTest/Dev/txStore -type d -mtime +1
The above statement finds the parent directory first:
/WMID/data/temp/TxTest/Dev/txStore
Then the command part deleted the entire tree recursively.
The remaining deletions all fail because the directories have already been deleted.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all,
how to write a script that will indentify the files in a directory which are 7 days old and delete those files.
Thanks in advance
Cheers
Arunava (8 Replies)
Discussion started by: arunava_maity
8 Replies
2. UNIX for Dummies Questions & Answers
I have a directory that contains files. I would like the command that deletes all files that are over 30 days old. Delete files based on creation date and not modified. (2 Replies)
Discussion started by: GEBRAUN
2 Replies
3. Shell Programming and Scripting
Hi,
I would like to list latest 2 days, 3 days or 4 days,etc of files in the directory...
how? is it using ls? (3 Replies)
Discussion started by: happyv
3 Replies
4. UNIX for Dummies Questions & Answers
Hi
Can u please tell me how to delete last 10 days logs .. (9 Replies)
Discussion started by: pb18798
9 Replies
5. Shell Programming and Scripting
i want to delete three days from system date ... date -3 (4 Replies)
Discussion started by: r_t_1601
4 Replies
6. Shell Programming and Scripting
Hi..
Am using diff to compare 2 directories(A & B) and as ouput i get a list of files which are found only in directory B ( I used grep & sed to create the list).
Now I want to delete the files which are found only in dir B after 3 days.
Please help me with this.
Thanks
CoolAtt (7 Replies)
Discussion started by: coolatt
7 Replies
7. Shell Programming and Scripting
Dear all,
I have a directory /homes/zak in which I have a number of directories which are created on a daily basis
thus:
02-MAY-10
03-MAY-10
04-MAY-10
05-MAY-10
I want to script the clean up of these directories, so I only keep two days worth,
so for example anything over 2 days... (10 Replies)
Discussion started by: Zak
10 Replies
8. Shell Programming and Scripting
Hi All
I want to remove the files with name like data*.csv from the directory older than 10 days.
If there is no files exists to remove older than 10 days, It should not do anything.
Thanks
Jo (9 Replies)
Discussion started by: rajeshjohney
9 Replies
9. AIX
how do i remove sub directories of a directory and all files which are older than 7 days by a single command in AIX. pls help me.
I am using command as
#find /gpfs1/home/vinod/hpc/ -depth -type d -mtime +7 -exec rm -rf {} \;
so i want to delete all sub directories and all files from the... (1 Reply)
Discussion started by: vinodkmpal
1 Replies
10. Shell Programming and Scripting
Will this work to delete files 30 days old in $backupDir or is there a better way to do it?
find $backupDir -type f -mtime +30 -exec rm {} \; (2 Replies)
Discussion started by: wyclef
2 Replies
LEARN ABOUT PHP
maxdb_stmt_error
MAXDB_STMT_ERROR(3) 1 MAXDB_STMT_ERROR(3)
maxdb_stmt_error - Returns a string description for last statement error
Procedural style
SYNOPSIS
string maxdb_stmt_error (resource $stmt)
DESCRIPTION
Object oriented style
string$maxdb_stmt->error ()
For the statement specified by stmt, maxdb_stmt_error(3) returns a containing the error message for the most recently invoked statement
function that can succeed or fail.
RETURN VALUES
A string that describes the error. An empty string if no error occurred.
EXAMPLES
Example #1
Object oriented style
<?php
/* Open a connection */
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
$maxdb->query("INSERT INTO temp.mycity SELECT * FROM hotel.city");
$query = "SELECT name, zip FROM temp.mycity ORDER BY name";
if ($stmt = $maxdb->prepare($query)) {
/* drop table */
$maxdb->query("DROP TABLE temp.mycity");
/* execute query */
$stmt->execute();
printf("Error: %s.
", $stmt->error);
/* close statement */
$stmt->close();
}
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
/* Open a connection */
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
maxdb_query($link, "INSERT INTO temp.mycity SELECT * FROM hotel.city");
$query = "SELECT name, zip FROM temp.mycity ORDER BY name";
if ($stmt = maxdb_prepare($link, $query)) {
/* drop table */
maxdb_query($link, "DROP TABLE temp.mycity");
/* execute query */
maxdb_stmt_execute($stmt);
printf("Error: %s.
", maxdb_stmt_error($stmt));
/* close statement */
maxdb_stmt_close($stmt);
}
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
Warning: maxdb_stmt_execute(): -4004 POS(23) Unknown table name:MYCITY [42000] <...>
Error: POS(23) Unknown table name:MYCITY.
SEE ALSO
maxdb_stmt_errno(3), maxdb_stmt_sqlstate(3).
PHP Documentation Group MAXDB_STMT_ERROR(3)