Crash Incorrect Database

2002-05-21 Thread Stavros Patiniotis
Hello, My hard drive has just failed on my database server, and I have rebuilt it and copied the data from backups back on to the drive, however mySQL cannot see all of the databases. A 'show databases' shows all of the databases, however 'use DBNAME' says ERROR 1102: Incorrect database

Re: Crash Incorrect Database

2002-05-21 Thread Stavros Patiniotis
;ve just recreated. in fact this could be a better thing to try. Then run myisamchk myisamchk -q -r TABLENAME then Start mysqld normally, all should be fine. Let me know how u go - Original Message - From: Stavros Patiniotis To: [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002

Re: Crash Incorrect Database

2002-05-21 Thread Stavros Patiniotis
2002, Myk Melez wrote: Stavros Patiniotis wrote: Hello, My hard drive has just failed on my database server, and I have rebuilt it and copied the data from backups back on to the drive, however mySQL cannot see all of the databases. A 'show databases' shows all of the databases, however