Hello,
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.
The file will be written in the database directory for the default database, given a statement as you've written it. That will be the file /usr/local/var/test/books.dat (not test.dat) if the current database is test and if the server's data directory is /usr/local/var/. On Mac OS X, it's probably not. To find out where the database directory actually is, go into mysql and issue this query:
SHOW VARIABLES LIKE 'datadir';
That will show you a pathname. Your file will be in test/books.dat under that.
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
