I'm a bit confused about where the database is located in Mac OS X. I was following the instructions in O'Reilly's boot using and Managing MySQL ad got to the point where I tried to do a select and output to a file. The command I ran was as follows:
SELECT * INTO OUTFILE 'books.dat' FIELDS TERMINATED BY ',' FROM BOOK;
The book states that a test.dat file will exist n my drive at /usr/local/var/test/test.dat , yet no such file can be found. I don't even have that directory. My directory structure goes as far as /usr/local/ - then there is mysql-2.23.55 and an alias (mysql) that points to that directory. Inside mysql-2.23.55, i have a tests directory and a data directory which i cannot get into at the moment. So is the book wrong, or is it different for OS X now.
Any help is appreciated, Thanks, Bernardo Zuniga
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
