Re: How to re-activate databases

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

>
> Many thanks in advance.
>
> Fokke Nauta

-- 
"Socialist governments traditionally do make a financial mess. They 
always run out of other people's money. It's quite a characteristic of them"

Margaret Thatcher