Re: How to re-activate databases
From: Fokke Nauta <usenet_at_solfon.nl>
Date: Thu, 6 Jun 2019 14:55:54 +0200
Message-ID: <glsgqpFi8hkU1_at_mid.individual.net>
>> 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?
Date: Thu, 6 Jun 2019 14:55:54 +0200
Message-ID: <glsgqpFi8hkU1_at_mid.individual.net>
[Quoted] 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. When I change the data path, MySQL will no longer start. That's why I tried to do the trick with the sym link.
Fokke Received on Thu Jun 06 2019 - 14:55:54 CEST