good rsync functions explained
michael rsync-ignore-existing-update-newer
Tell another server to run a shell script
ssh user@xxx.xxx.xxxx.xxx ./myscript.sh $para
update mysql table from another table
ref: from SOF UPDATE tableB t1 INNER JOIN tableA t2 ON t1.id = t2.id SET t1.name = t2.name
SQL check duplicate
SELECT id, policy_number, count(*) FROM `policies` group by policy_number having ( count(*) > 1 and id >10000) SELECT submission_date, policy_number, count(*) FROM `policies` group by policy_number having ( count(*) >…
Rsync to GoDaddy host
Inspired by this link: (it’s for CentOS, but somehow I found rsync in my GD Red Hat hosting.) http://www.htpcbeginner.com/install-rsync-on-godaddy-hosting-account/2/ my sample link rsync -rv -e ssh –rsync-path=/usr/bin/rsync “/Users/michael/test” lin@microlingolo.com:/home/lingolo/public_html/all_thumbs/
ffmpeg bulk convert to 720p
this work for my osx 10.9 give -b a high value to maintain quality this script cut my 1080p video to half size # for f in *.MOV; do ffmpeg…
No RDP on free VirtualBox
That says, we cannot RDP to the virtual machine, but …. we can RDP to the host machine nei. http://www.macrium.com/help/v5/How_to/ImgToVHD/Create_a_virtual_machine_using_ImgToVHD.htm on this web it said: Oracle provides two versions of…
An easy way to install Microsoft’s TrueType core fonts on linux
http://corefonts.sourceforge.net/
Eject a DVD from iMac
LINK HERE
花了十幾分鐘才找到的wordpress正體中文檔
LINK HERE 很多網頁都指來指去，到後來，指番到原頁。 很無奈。