Search code examples
mysqlwindowsduplicate-data

MySQL duplicating all data at C:\ProgramData\MySQL and C:\Users\All Users\MySQL?

Running out of storage space on disk (machine running win7 SP1 x64), was looking into what files were taking up the most space, noticed that MySQL is storing same data at the following 2 locations:

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

All files in both folders are of the same size, same modification date, etc. The tables have been encrypted with Encrypting File System. Basedir and datadir in C:\ProgramData\MySQL\MySQL Server 5.6\my.ini are as follows:

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

I am wondering why the data is being stored in both places, and what would happen if we were to move the folders elsewhere.

Thanks in advance!

Solution

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

    Only C:\ProgramData actually exists as a "real" folder. C:\Users\All Users is a symbolic link to C:\ProgramData. That is, C:\Users\All Users points to C:\ProgramData, so if you navigate to the former, you are automatically redirected to the latter. That is why they appear identical.