List:General Discussion« Previous MessageNext Message »
From:shawn l.green Date:April 7 2014 2:39pm
Subject:Re: database not listed
View as plain text  
Hello Nicu,

On 4/6/2014 1:51 AM, Nicolae Marasoiu wrote:
> Hi,
>
> A directory in datadir does not show up as database. Please help!
>
> drwx------ 2 mysql root     24576 oct  9 00:34 *opendental*
> drwx------ 2 mysql mysql     4096 mar 22 19:54 performance_schema
> drwx------ 2 mysql root      4096 mar 22 19:53 test
>
>
> mysql> show databases
>      -> \g
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | test               |
> +--------------------+
>   \
> Thanks
> Nicu
>

At first glace, it appears that you have not copied the old 'mysql' 
database folder from your old --datadir location to the new one. MySQL 
only knows about the one active folder you have defined in your 
configuration file. It does not remember any older settings where you 
want your databases to be stored.

Remember to make the new files in the new data directory owned by the 
current mysql user and group.

Yours,
-- 
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
Thread
database not listedNicolae Marasoiu6 Apr 2014
  • Re: database not listedshawn l.green7 Apr 2014