Friday, March 19, 2010

Installing GD Library on Mac OS X 10.5


— Open Terminal

  • sudo mv /usr/local/php5 ~/Desktop/php5.old
  • curl -O http://www2.entropy.ch/download/php5-5.2.5-6-beta.tar.gz
  • tar -xzf php5-*-beta.tar.gz
  • sudo mv php5 /usr/local/
  • sudo ln -sf /usr/local/php5/entropy-php.conf /etc/apache2/other/+entropy-php.conf
  • sudo apachectl restart
— Comment “#LoadModule php5_module libexec/apache2/libphp5.so in private/etc/apache2/httpd.conf

— Dump
php5.old folder from desktop

php.ini on MacOS X 10.5 (Leopard)


usr/local/php5/lib/php.ini

Monday, March 15, 2010

Reset MySQL auto increment value


ALTER TABLE tablename AUTO_INCREMENT = 1


This will reset the next auto increment value to current largest value in the auto increment column + 1.