7

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?

Warner
  • 23,756
  • 2
  • 59
  • 69
Rob Sobers
  • 333
  • 1
  • 4
  • 13

1 Answers1

7

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

crb
  • 7,998
  • 1
  • 38
  • 53