Tag Archive for 'cli'

Phew. My calendar is synced to my phone again

My phone used to sync with iCal several times a day, but when I upgraded to Leopard it wiped my cron tab file and all that goodness stopped. (Your crontab file is a way of scheduling tasks on your Mac using the Terminal application.) I’ve just googled around for the solution and found it again: Use cron to automate iSync at non-standard intervals. Nice neat solution, to which I would only add the following: 0 8,10,12,14 * * * osascript -e ‘tell application “iSync” to synchronize’ >> /dev/null Whenever a Cron command runs, any output is sent by email to the account handler. This simply builds up as unsendable email in the system, or spams you every time the script runs… either way it’s not good. The >> /dev/null simply sends any output into a black hole so it doesn’t bother me.

Originally I’m sure I had this set so iSync closed down again when it was done… so maybe more to follow.

Exporting from MySQL to CSV

Everytime I need to do this I go into at least five minutes of Googling for a decent solution. The problem is that a lot of people don’t have access to the commandline, so the solutions all reference PHPMyAdmin which is, you know, OK, but I don’t use it or want to install it just to export some quick reports. Other solutions are similarly indirect.

Continue reading ‘Exporting from MySQL to CSV’




Bad Behavior has blocked 1071 access attempts in the last 7 days.