Server AutoStart on Mac OS X 10.3.2 Panther

Hi All, Thank you very much for the kind and ample help ! I am running Mac OS X 10.3.2 Panther, and per the MySQL (DuBois) book have created a new user 'mysqladm' to run the server. I manually start the server now via : sudo mysqld_safe --user=mysqladm I have two questions : 1. Why does 'mysq

CPAN - DBI & MySQL problems with make test & make install

Greetings MySQL gurus! I am setting up a local db and plan to access it via perl & DBI. on a Mac iBook running OSX 10.3.2 After creating a new user account to run the sql server, I connected to the sql server with my personal account and all works fine regarding accessing my tables, etc. I then

Backup & Recover Database

Dear MySQL'ers, I have backed up my db using : % mysqldump -p -u tfiedler --opt BigData >./db_backup.sql When db_backup.sql is scp'd (secure copy) to another machine running mysqld, then I ssh to that machine and execute : $ mysql -u tfiedler BigData < db_backup.sql ERROR 1044: Access denied fo

SELECT statement w/ Min() & Group By

Greetings MySQL group: I am new to the group so if this is posted to the wrong place, please inform me. Using the following table : +---++---++ | unique_est_id | sp_id | score | evalue | +---++---++ | 2 | R