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