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
;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
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