--- Kishore Jalleda <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] ----------------------------------------------------------------------------- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]