Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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!

like image 396
Sebastian Avatar asked Sep 30 '13 19:09

Sebastian


1 Answers

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.

like image 65
Franck Dernoncourt Avatar answered Oct 21 '22 16:10

Franck Dernoncourt