Re: need help with foreign keys, new to mysql

[Enrique Sanchez Vela]

--- Kishore Jalleda <kjalleda@stripped> wrote:

> check the permissions on the mysql data dir, may be
> the user mysql or
> who ever runs mysql does not have sufficient
> privileges
> Kishore Jalleda
> 


I agree with Kishore, to elaborate his answer a little

longer I would ask the following.

  - is the hardware all ok?

  - You said you created the table before, so u must
had have access to the directories from the OS
prespective, did you use the same method to connect to
the server at the time of creation and at the time to
alter it?

 - did u alter the tablespaces location? the
configuration files? I am not 100% familiar with the
Windows OS but I would expect the full path to the
files not a relative one in the error message.

 - can u select anything from the different tables?

 - did you use the same userid, passsword and
connection method to create the database and to try to
alter it?





Enrique Sanchez Vela
email: esanchezvela@stripped
-----------------------------------------------------------------------------
It's often easier to fight for one's  ||    We live in the outer space               
principles than to live up to them    ||    Rev. Kay Greenleaf
Adlai Stevenson                       ||


	
		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com