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'
At 19:46 -0500 3/1/03, Bernardo Zuniga wrote:
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
Thank you Paul,
That helped to clear things up. My guess was that the book was wrong
and the path was different for OS X. The command worked fine, but
apparently the files were never created for some reason. I will try
this again.
thanks for your help,
Bernardo
On Saturday, March 1, 2003, at
At 21:38 -0500 3/1/03, Bernardo Zuniga wrote:
Thank you Paul,
That helped to clear things up. My guess was that the book was wrong
and the path was different for OS X. The command worked fine, but
apparently the files were never created for some reason. I will try
this again.
Well, the book
There were no errors and it listed a number of rows affected and a
time. tried the command again and it said that the file already
existed. The problem was the directory path that I was looking in. I
couldn't see it in the GUI but in the terminal a find pointed me to the
file. I wasn't able to
Friends:
How I can change the place where they are create the database?
Different place than \mysql\data\mybase
thanks
Ernesto
-
Before posting, please
Ernesto,
Thursday, February 28, 2002, 6:06:53 PM, you wrote:
EAZI Friends:
EAZI How I can change the place where they are create the database?
EAZI Different place than \mysql\data\mybase
You should change default directories by editing my.cnf:
[mysqld]
datadir=path_to_your_dir
or you