Home / server / Questions / 174741
Accepted
NinjaCat
Asked: 2010-08-27 02:37:07 +0800 CST

Is it possible to store a new mysql database on another drive?

  • 772

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:\?

windows mysql

1 Answers

  1. Best Answer

    Yes, using NTFS symbolic links. Create a link in your database directory, pointing to m:\database\data\yourdatabasename.

    • 2