Is it possible to have two databases hosted on a single MySQL instance, but have the files stored in two different physical locations?

For example:

db1 stored in: C:/ProgramData/MySQL/MySQL Server 5.1/Data/

db2 stored in: E:/MySQL/MoreData/

I know there's a datadir setting in my.ini that specifies where to store databases by default. Is there any way to override this at the database level?

I suppose I could use shortcuts, but is there a built-in way to do this in MySQL?


Use symbolic links, or in your case, the MySQL workaround for Windows, the .sym file.

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.