[Info-vax] Databases versus RMS

[Arne Vajhøj]

On 4/22/2012 8:21 PM, JF Mezei wrote:
> Arne Vajhøj wrote:
>> I assume that /var/mysql conatins the mysql system database
>> and possible some other system stuff.
>>
>> I would want to separate that from the user databases.
>
> I have the "datadir" set to /var/mysql
>
> Doesn't mean that all dataase  files will go there no matter to whom
> they belong and what they are for ?
>
> Is there a way to put specific application databases in their own
> respective directories ? (such a recipes database going to
> /myapps/recipe/data next to /myapps/recipe/programs

There are various ways to move things around.

For MyISAM you can specify DATA DIRECTORY and INDEX DIRECTORY
in CREATE TABLE.

The InnoDB data and log files can be placed outside
of datadir.

But thinking more about it, then I think you should just keep
it as is for now.

It works.

Arne