Stavros,
As an absolute last resort try the following...
Shutdown mysql first. copy your database backups to a safe place before
doing this.
Removed all tables first off. Then move the .MYD and .MYI and .frm files for
each database.
Run mysqladmin and re-create all of the tables again. and leave these tables
with no data in them.
Copy you backed up tables over the top of these tables in
/usr/local/mysql/data (the .MYD and .MYI and .frm files) overwritting the
MYD/MYI/frm files.
You could even try just copying the MYD and MYI files over the top and
skipping the FRM files, as they table form definition files which you;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 5:21 PM
Subject: Crash & Incorrect Database
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 name....
Now I have done a check on each of the tables in one of the 'missing'
db's, and the database is still not available.
(eg myisamchk -r -e table_name)
Can anyone point me in the right direction.
(FreeBSD v4.5, mySQL v3.23.49)
Kind Regards,
0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0
escape net
m a k i n g t h e n e t w o r k f o r y o u
465b South Road ph 8293 2526
KESWICK SA 5035 fx 8293 2949
0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0
---------------------------------------------------------------------
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
