Kev The Dev TheSkyNet

## kill_dat_querey,sh
#FIND

#SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
#FROM information_schema.processlist
#WHERE command <> 'Sleep'
#AND info NOT LIKE '%PROCESSLIST%'
#ORDER BY time DESC LIMIT 50;

host="octopus-read-1"
password=XXXXXXX

## magento_oneliner_db_dump.sh
config="app/etc/local.xml"; u=`sed  -n 's/.*<username><!\[CDATA\[\(.*\)]]><\/username>/\1/p' $config`;n=`sed  -n 's/.*<dbname><!\[CDATA\[\(.*\)]]><\/dbname>/\1/p' $config`;p=`sed  -n 's/.*<password><!\[CDATA\[\(.*\)]]><\/password>/\1/p' $config`;mysqldump -u $u -p"${p}" $n > ~/${n}_$(date +"%Y_%m_%d")
	#FIND

	#SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
	#FROM information_schema.processlist
	#WHERE command <> 'Sleep'
	#AND info NOT LIKE '%PROCESSLIST%'
	#ORDER BY time DESC LIMIT 50;

	host="octopus-read-1"
	password=XXXXXXX