Sunday, November 18, 2012

Commands


Clean the Kernals
============================================
dpkg --get-selections|grep 'linux-image*'|awk '{print $1}'|egrep -v "linux-image-$(uname -r)|linux-image-generic" |while read n;do apt-get -y remove $n;done


select * from ReportSummaryDB.CampaignInsightSummarySegment where date >='2012-08-12' and date <='2012-08-18' INTO OUTFILE '/tmp/CampaignInsightSummarySegment.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

http://www.electrictoolbox.com/mysqldump-selectively-dump-data/
mysqldump -t -u root -p ReportSummaryDB CampaignInsightSummarySegment --where="date >='2012-08-12' and date <='2012-08-18'" > CampaignInsightSummarySegment1218.sql;

mysqldump -t -u root -p ReportSummaryDB CampaignInsightSummarySegment --where="date >='2012-08-12' and date <='2012-08-18'" > CampaignInsightSummarySegment1218.sql;

SVN Password
htpasswd /etc/subversion/passwd jason

No comments:

Post a Comment