Re: How to re-activate databases

From: J.O. Aho <user_at_example.net>
Date: Fri, 7 Jun 2019 10:02:44 +0200
Message-ID: <gluk15F1j52U1_at_mid.individual.net>

On 06/06/2019 14.55, Fokke Nauta wrote:

> On 06/06/2019 09:22, J.O. Aho wrote:

>> On 05/06/2019 21.35, Fokke Nauta wrote:
>>
>>> I have copied all the contents of the folder E:/Files/Databases/MySQL
>>> to the folder C:/ProgramData/MySQL/MySQL Server 8.0/Data.
>>> OK, it works.
>>> But due to my backup system I want all other datbases to be it the
>>> same folder E:/Files/Databases/..
>>> The MySQL database as well. So I thought to be clever and created a
>>> symbolic link from E:/Files/Databases/MySQL to
>>> C:/ProgramData/MySQL/MySQL Server 8.0/Data, in order to keep the
>>> MySQL database in the same folder.
>>> Didn't work. The MySQL service didn't want to start again with the
>>> same message.
>>>
>>> Any more tricks to make it work?
>>
>> Remove the "symbolic link" and configure your my.cnf to have the
>> correct path for the datadir setting.
>>
>
> You mean my.ini. That's the config file.

It may be called something else in a lesser os, so I guess that it's the one.

[Quoted] > When I change the data path, MySQL will no longer start. > That's why I tried to do the trick with the sym link.

[Quoted] See to that the whole path has the right ownership (compare with the working path). Also ensure you do write the path correctly, so you have the slashes in the right direction.

-- 

  //Aho

Received on Fri Jun 07 2019 - 10:02:44 CEST