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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
