Creating a database on a different disk

Hi...

I know that if I do a CREATE DATABASE blah, it creates a database in
the default location defined in the my.cnf file.

What I want to do is create a new database but on a different disk
drive.

Anyone know how to do it or what a workaround is so I can do this?

Strange to me that MySQL doesn't appear to have this feature, common in
all other RDBMSs.

Joe

JoeT wrote:
> Hi...
>
> I know that if I do a CREATE DATABASE blah, it creates a database in
> the default location defined in the my.cnf file.
>
> What I want to do is create a new database but on a different disk
> drive.
>
> Anyone know how to do it or what a workaround is so I can do this?
>
> Strange to me that MySQL doesn't appear to have this feature, common in
> all other RDBMSs.
>
> Joe

You mean this section of the manual?
http://dev.mysql.com/doc/refman/5.0/en/disk-issues.html