Help having MySQL save data to secondary drive
What's up guys? I am currently in the process of setting up a MySQL database and need to store the info on a secondary hard drive instead of the main one.
This may sound like a silly question, but where can I change it in my config files (im assuming mysql_config) to properly have it save to the secondary drive instead of the first? I think the data by default is stored in the /data/ folder and if my secondary drive is name like "web2" do i have to edit the config files to point to like web2:/mysqldata/ if I wanted stuff stored in that folder?
Any help would be great :)