I am running MySQL on Windows XP. My data directory is: c:/database/data/
I want to create a new database but store it's data on m:/database/data/
Is it possible to keep the existing data on c:\ and the new data in m:\?
Yes, using NTFS symbolic links. Create a link in your database directory, pointing to m:\database\data\yourdatabasename.
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
5 years ago