mysql server data folder is not visible in windows

Question

I'm trying to locate data folder of mysql server 5.7

When I run this query

SHOW GLOBAL VARIABLES LIKE 'datadir';

I got my data dir path, but when I actually go there in c drive its not there.

Checked all hidden properties, all are fine.

Any help ?

Thanks. It probably doesn't exist yet. Check the answer from @Haralami... — Grantly
– Grantly, Commented Jan 6, 2016 at 12:08

Fakeer · Accepted Answer · 2017-09-11 20:51:31Z

2

It could be hidden. Default datadir on Windows 10 is C:\ProgramData which is normally hidden.

answered Sep 11, 2017 at 20:51

Fakeer

1,0541 gold badge15 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

harry · Accepted Answer · 2016-01-06 12:58:57Z

1

This link describes initializing the data directory on Windows or UNIX-like OSs.

For Windows

Because you have problems with finding the data directory I suggest you define it yourself.

First you have to make sure the following lines are in my.ini file:

[mysqld]
basedir=C:\\Program Files\\MySQL\\MySQL Server 5.7
datadir=D:\\MySQLdata # here you could put

The second line points to your MySQL Server installation. The third line to wherever you want your data directory to be. After saving the file. You could call following command:

C:\> bin/mysqld --defaults-file=C:\my.ini --initialize

With C:\my.ini pointing to your my.ini file. Hope this helps you

edited Jan 6, 2016 at 12:58

answered Jan 6, 2016 at 12:00

harry

3572 silver badges20 bronze badges

4 Comments

roy Over a year ago

am not getting any error that data dir doesn't exists. Can you help me how to do it ?

harry Over a year ago

I have added a more complete explanation

roy Over a year ago

I have added the lines given by you in my-default.ini file which is located at C:\\Program Files\\MySQL1\\MySQL Server 5.7, So that would my basedir ? And new data folder i have created at this path E:\\roy\\MySQLdata, so that would be my data folder right ? So when I start commands on cmd given by you to initialize shows error that bin doesnt exits something like that. Can you help me more ? Its becoming tedious !!

harry Over a year ago

Yeah, sure. You should put the lines I pointed you in my.ini. here is article, where you could find my.ini file Another useful thing to do will be to put --console at the end of the command, so Windows could output direct the error message in the console.

Collectives™ on Stack Overflow

mysql server data folder is not visible in windows

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related