Hello,
Can you not have '.' in database names any more??
I just renamed one of the databases to something without .'s, and it
worked.....
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
On Tue, 21 May 2002, Paul wrote:
> 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
