Databases | Sandeep Ghael

Ultimate Snow Leopard Web Development machine (part 3) – Databases

27, Oct 2009

Depending on the webapp project I’m working on, I flip back and forth between MySQL and PostgresSQL, generally using Postgres for anything that needs spatial or mapping related functionality. One pain point I encountered with Snow Leopard is getting everything compiled for true 64bit, and then getting the appropriate bindings for MySQL or Postgres to [...]

In: Databases|MacOSX
Tags: 64bit, Mac OS X, MySQL, Postgres, Snow Leopard

Read More
(3) Comments

Backup script for MySQL (onsite and offsite)

24, Aug 2009

In the previous post, I provide a backup script for PostgreSQL. As promised, here is the same script written for MySQL. Below are the setup instructions. Copy the contents below into a file named mysql-backup.sh placed in the root account home (on Ubuntu it’s ‘/root’). For simplicity, I’m using the root account, but on your [...]