Move MySql datafile to different location
 

Dear all,
I want to move the location of MySql data file by setting datadir variable but I cannot find the variable in my.cnf file.

Should I set the variable in my.cnf, or is there any other configuration file beside this one?

Regards,
ethereal1m

Yes, you can add it to [mysqld] section. A simplier way, I suggest you use symlink to change datadir location.

nice, thanks for fast reply!