Re: How to re-activate databases
From: Fokke Nauta <usenet_at_solfon.nl>
Date: Wed, 5 Jun 2019 21:07:14 +0200
Message-ID: <glqi71F5du5U2_at_mid.individual.net>
>> Hi all,
>>
>> I uninstalled MySQL 8.0.15.0. I left the database in E:\MySQL Database
>> and removed the MySQL folder in the Program Data folder. Also removed
>> the MySQL folders out of the Programs folder.
>> I recently installed MySQL 8.0.16.0 as new. The default location of
>> the database folder is C:\ProgramData\MySQL\MySQL Server 8.0\Data. How
>> can I make the MySQL server see the old databases? I copied the
>> folders of the databases out of the old database folder into the
>> current database folder, but they don't show up after I restarted
>> MySQL80. Then I changed in the my.ini file the line
>> C:/ProgramData/MySQL/MySQL Server 8.0/Data into "E:/MySQL Database". I
>> thought this might point the server to the old database location.
>> Restarting the MySQL service did not work, as it crashed. MySQL did
>> not want to start again. So I uninstalled it completely, and
>> re-installed it from fresh.
>> Hence my question: how can I now achieve that MySQL can see the old
>> databases?
Date: Wed, 5 Jun 2019 21:07:14 +0200
Message-ID: <glqi71F5du5U2_at_mid.individual.net>
On 05/06/2019 19:48, The Natural Philosopher wrote:
> On 05/06/2019 14:09, Fokke Nauta wrote:
>> Hi all,
>>
>> I uninstalled MySQL 8.0.15.0. I left the database in E:\MySQL Database
>> and removed the MySQL folder in the Program Data folder. Also removed
>> the MySQL folders out of the Programs folder.
>> I recently installed MySQL 8.0.16.0 as new. The default location of
>> the database folder is C:\ProgramData\MySQL\MySQL Server 8.0\Data. How
>> can I make the MySQL server see the old databases? I copied the
>> folders of the databases out of the old database folder into the
>> current database folder, but they don't show up after I restarted
>> MySQL80. Then I changed in the my.ini file the line
>> C:/ProgramData/MySQL/MySQL Server 8.0/Data into "E:/MySQL Database". I
>> thought this might point the server to the old database location.
>> Restarting the MySQL service did not work, as it crashed. MySQL did
>> not want to start again. So I uninstalled it completely, and
>> re-installed it from fresh.
>> Hence my question: how can I now achieve that MySQL can see the old
>> databases?
> > If they are C-ISAM databases copying them into the new folder and > restarting mysqld works >
Thanks.
I did and it worked - but I couldn't change the database folder. Please
see the other answer.
Fokke Received on Wed Jun 05 2019 - 21:07:14 CEST