I am using the latest version of mysql (winxp/mysql ver 4.0.12) and i am having trouble getting mysql to work with sym links. i have mysql running on my local machine and have a database that is located elsewhere on the network.
i have created a .sym file that points to the location of the data. the database is listed as a database when i connect using sqlyog, but when i try to access it i get a 1049 error.
i have experitmented a little and tried to map it to a local drive letter instead of a network path. i have found that the sym file will only work if i have it mapped to a location on my physical local hard drive beginning with 'c:'.
here is the contents of the .sym files i have tried and their results:
data.sym:
contents:
file2mhhs
results:
error 1049
data1.sym:
contents:
z:
results:
the z drive is mapped to file2mhhs, still gives an error 1049
data2.sym:
contents:
c:mhhs
results:
i moved the database contens over to my local machine and it works… but i need to have the database on the network
data3.sym:
contents:
z:
results:
the z drive is mapped to my local directory c:mhhs, gives an error 1049
is this a sqlyog error or a mysql error? any help is appreciated.
Matt