Is it possible to set datadir to contain some other location other than /var/lib/mysql

[RENOY RAY]

Hi Experts,

Is it possible to know if we can mention some other location to contain a MySQL DataBase, in another partition which has the same file system, which has more space.

Wanted to know if it is possible to set the 'datadir' in 'my.cnf' file to contain the some extra paths as well. For e.g. I wanted it to refer to /media/<partition_name> along with the current /var/lib/mysql.

This would mean setting it to something like :

datadir = /var/lib/mysql ; /media/<partition_name>

FYI -> /var/lib/mysql contains the actual data for the MySQL Databases.

But my only worry is that how would the MySQL server know which DataBase to be handeled in which path mentioned. Do we have an option to specify DB Spaces as well?

I would be grateful to receive your comments.

Many thanks,
Renoy.

Regards,
Renoy