i have installed new database server on ubuntu

mysql version is 5.5.35

im trying to execute select load_file('/usr/home/aaa.com/medya_data/ver.txt') and im sure ver.txt file is exist but medya_data folder mapped as symbolic link

if i try without symbolic link folder the query is working well

here is my.cnf file :

# * Basic Settings
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
# datadir               = /var/lib/mysql
tmpdir          = /data/mysql/tmp
# lc-messages-dir = /usr/share/mysql
# skip-external-locking
symbolic-links  = 1

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address          =
# * Fine Tuning

thanks for advice


You can use a hardlink instead if the symlink path is on the same file system.

|improve this answer|||||
  • Could you explain a bit more ? This answer is not clear enough as is...Thank you – krisFR Apr 12 '14 at 16:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.