CODEWITHSUNDEEP
c#mysql
Alexander
Alexander

Reputation: 607

Store mysql databases in the different folders

I need to save data to the different mysql databases. By default MySQL store DBs in X:\ProgramData\MySQL\MySQL Server 5.1\data. Is it possible to store different databases in the different folders? For example I want to store my db in x:\new_folder\ and the second one in z:\new. Also I want to configure paths to this folders with C#.

Upvotes: 2

Views: 951

Answers (2)

blocker
blocker

Reputation: 31

and another option innodb_file_per_table. which enforces mysql to keep each innodb data schema into separate subfolder.

14.3.3. Using Per-Table Tablespaces

Upvotes: 3

Ray
Ray

Reputation: 150

You could run one instance of MySQL server per user:

"In some cases, you might want to run multiple instances of MySQL on a single machine. [...] Or you might want to give different users access to different mysqld servers that they manage themselves. (For example, you might be an Internet Service Provider that wants to provide independent MySQL installations for different customers.) [...] The primary resource managed by a MySQL instance is the data directory."

-- http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html

Upvotes: 0

Related Questions