Socialabel

Thursday, February 25, 2016

Disable Rule Mod Security

Disable rule pada mod security apache 
 
#<IfModule security2_module>
#        SecRuleEngine Off
#</IfModule> 
 
<IfModule mod_security2.c>
 SecRuleRemoveById ######
</IfModule>
 
 
service httpd graceful
 

Tuesday, February 2, 2016

Backup SQL Server Remote

sqlbackup <Host> <User> <Password> <DB> <TUJUAN> <KOMENTAR>

################# BASH BACKUP SQL ########################
serverdb=$1
userdb=$2
passwd=$3
namadb=$4
tujuan=$5
komen=$6

DATE=`date +%Y-%m-%d_%H_%M_%S`

#echo "$serverdb,$userdb,$passwd,$namadb"

mysqldump --opt --lock-tables=false --host $serverdb -P 3306 -u $userdb -p"$passwd" $namadb > $tujuan/$namadb.sql+$serverdb+$userdb+$DATE+$komen
################# BASH BACKUP SQL ########################