Hello,
I'm not sure if my previous post made it to the list, but it seems that
mysql no longer accepts '.' in database names.
I merely changed the . with _ and the missing databases came alive :)
Kind Regards,
0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0
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 'use DBNAME' says
>
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
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
