hi when i try and do a mysqldump of the databases it exites with this error
[EMAIL PROTECTED] diaendomet]# mysqldump -ucojjohealth -p --all-databases > alldatabases.sql Enter password: mysqldump: Got error: 29: File '../diaendomet/users.MYD' not found (Errcode: 2) when using LOCK TABLES so i ran mysqlcheck --all-databases --auto-repair -ucojjohealth -p and now i get the following error : File '../diaendomet/users.MYD' not found (Errcode: 2) what do i do next ? many thanks -- Gregory Machin [EMAIL PROTECTED] www.linuxpro.co.za -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]