Home / server / Questions / 158218
Accepted
Rob Sobers
Asked: 2010-07-08 06:17:42 +0800 CST

Can I specify where my database files are stored *per database* in MySQL?

  • 772

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?

mysql database

1 Answers

  1. Best Answer

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

    • 7