Wednesday, July 22, 2009

startup MySQL on mac

from
http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html

If you don't use the Startup Item, enter the following command sequence:

shell> cd /usr/local/mysql
shell> sudo ./bin/mysqld_safe
(Enter your password, if necessary)
(Press Control-Z)
shell> bg
(Press Control-D or enter "exit" to exit the shell)

Import MS Access to MySQL

  1. need local PC running mysql
  2. get MySQL Migration toolkit for Windows
  3. import MS access and export to web/local machine
  4. using MySQL Administrator on PC backup the Database
  5. then you have an SQL just like phpmyadmin to go to web/mac

Tuesday, June 2, 2009

Joomla get rid of ugly category list

from this post
http://forum.joomla.org/viewtopic.php?f=428&t=273447

change
$category->link = JRoute::_(ContentHelperRoute::getCategoryRoute($category->slug, $category->section).'&layout=default');

to
$category->link = JRoute::_(ContentHelperRoute::getCategoryRoute($category->slug, $category->section).'&layout=blog');

and you end up with a blog layout from the section list