I'm assuming you're on a UNIX box? If so, you might first check to see if the data files exist and then look at the permissions on them. My data files are in:
/usr/local/var/<database name> Let the list know what you find. On Sat, 2002-03-23 at 06:10, Andy wrote: > > > When trying to execute a simple "Select" statement from the mysql command > prompt I'm getting the following Message: > > ERROR 1016: Can't open file: 'wishes.MYD'. (errno: 144) > > As far as I can see the database exists . Any ideas ? > > Andy C > R2 project > http://www.r2-dvd.org > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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