MySQL vs. SQL Server - DataFiles Granularity
I've migrated to mysql from SQL Server, and I can't seem to scatter my datafiles like I could on SQL Server. The MySQL Adin tool only allows "all datafiles for all databases to be in one location".
I have a windows server with three hard drives. I have the mysql installation files on drive 1, and have the data files for two mysql database on drive 2.
I want to move the data files for database 2 to drive three while allowing the data files for database 1 to remain on drive 2.
When I used MSSQL, granularity for specifying the location of data files was per database. So far, using mysql, I've only discovered granularity per "database server". The gui only allows you to specify the "data files location" for all databases. I want to place data files for different databases in different folders on different hard drives.
How can I do this?
Thanks in Advance,
Lonnie Lee Best
http://www.lonniebest.com/News
This posted was also placed here:
http://forums.mysql.com/read.php?34,74374,74374
http://forums.mysql.com/read.php?11,75121,75121
Subject
Written By
Posted
MySQL vs. SQL Server - DataFiles Granularity
March 18, 2006 09:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.