Does MySQL duplicate all data in C: \ ProgramData \ MySQL and C: \ Users \ All Users \ MySQL?

Starting storage on disk (running on a computer running win7 SP1 x64), studied which files take up the most space, noticed that MySQL stores the same data in the following two places:

C:\ProgramData\MySQL
C:\Users\All Users\MySQL

All files in both folders are the same size, the same modification date, etc. The tables were encrypted using the Encrypting File System. The basics and data are as C:\ProgramData\MySQL\MySQL Server 5.6\my.inifollows:

basedir="C:/Program Files/MySQL/MySQL Server 5.6/"
datadir="C:\ProgramData\MySQL\MySQL Server 5.6/Data"

I wonder why the data is stored in both places, and what happens if we move the folders to another location.

Thanks in advance!

+4
source share
2 answers

https://superuser.com/a/405105/116475 :

C:\ProgramData "" . C:\Users\All C:\ProgramData. , C:\Users\All C:\ProgramData, , , . .

+1

, script, ? mysql ? /!

basedir - MySQL installation.

datadir - MySQL data. ( !)

, ...

mysql> select @@datadir;

... !

? ! ( )!

0

All Articles