SELECT email,COUNT(email) AS NumOccurrencesFROM usersGROUP BY emailHAVING ( COUNT(email) > 1 )
SELECT emailFROM usersGROUP BY emailHAVING ( COUNT(email) = 1 )
Default partition size for /var normally not enough to store databases, so we need to store it somewhere bigger (/usr). The steps will show how to transfer database from /var/db/mysql (default path installation for MySQL in FreeBSD) to /usr/local/mysql/data (suggested path). Steps as follows :-
DONE!
There are 2 ways u can do this. For example if u want to delete directory older than 7 days :
First method :
find /path/dir -type d -mtime +7 -exec rm -rf {} \;
Second method :
find /path/dir -type d -mtime +7 | xargs rm -rf {} \;
You can always change the +7 value to any number of days preferred.
FYI, this command is only for directory deletion, if u want to delete files, u can change the “-type d” (d means directory) to “-type f” (f means files).
Example :
find /path/dir/unl.txt -type f -mtime +7 | xargs rm -f {} \;
P/S : There’s an alternative command which we can use, tmpwatch (more info : http://linux.about.com/library/cmd/blcmdl8_tmpwatch.htm)
mod_dosevasive is an evasive maneuvers module for Apache to provide evasive action in the event of an HTTP DoS or DDoS attack or brute force attack. It is also designed to be a detection and network management tool, and can be easily configured to talk to ipchains, firewalls, routers, and etcetera. mod_dosevasive presently reports abuses via email and syslog facilities.
Recent Comments