create database with specific data file location in Mysql for one database at runtime

Question

Hi All,

Can anyone give any input on how to create database in mysql where it should create its data file at runtime instead of storing it on default location specified in my.cnf.

Is there any way for doing this in mysql anyone come across.

Thanks in advance.

Answer 1

Use a --datadir option to specify the new data directory location each time you start the server.

link