Mac OS X and database path

2003-03-01 Thread Bernardo Zuniga
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'

Re: Mac OS X and database path

2003-03-01 Thread Paul DuBois
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

Re: Mac OS X and database path

2003-03-01 Thread Bernardo Zuniga
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

Re: Mac OS X and database path

2003-03-01 Thread Paul DuBois
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

Re: Mac OS X and database path

2003-03-01 Thread Bernardo Zuniga
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

Database path

2002-02-28 Thread Ernesto A. Zapata Icart
Friends: How I can change the place where they are create the database? Different place than \mysql\data\mybase thanks Ernesto - Before posting, please

Database path

2002-02-28 Thread Victoria Reznichenko
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