Schema directory './mySmartHome' already exists. This must be resolved manually (e.g. by moving the schema directory to another location) [duplicate]
Im trying this in Mysql 8.0:
" CREATE SCHEMA test
; "
but an error appears:
"Error Code: 3678. Schema directory '.\test' already exists. This must be resolved manually (e.g. by moving the schema directory to another location)." enter image description here
Where can I find that directory to eliminate it? OS: Windows.
windows 10 home (Microsoft Windows [Versión 10.0.18362.418]).
I installed in program files(
C:\Program Files\MySQL\MySQL Server 8.0)
<DIR> bin 14/10/2019 13:26
<DIR> docs 14/10/2019 13:26
<DIR> etc 14/10/2019 13:26
<DIR> include 14/10/2019 13:26
<DIR> lib 25/06/2019 12:23 336,955
LICENSE 25/06/2019 12:23 101,805
LICENSE.router 25/06/2019 12:23 687
README 25/06/2019 12:23 700
README.router 14/10/2019 13:26
<DIR> share
In the directories where the database is stored there is a "test" folder.
You must rename or delete the "test" folder in order to create a new database or a new schema called "test" because doing so generates a folder with that name, but since a folder with that name already exists, the error it gives you occurs.