Home / server / Questions / 368975
Accepted
Highway of Life
Asked: 2012-03-13 13:35:28 +0800 CST

How to set a specific directory location for individual MySQL database?

  • 772

Is it possible to set each database in MySQL to use a separate datadir?

I'm running a userdir development (sandbox) server and would like to put the MySQL data files for the database(s) for that user in their /home/<user>/mysql directory. How would you do this?

  • Linux Ubuntu Server 10.4
  • MySQL Server version: 5.1.41
  • Storage Engine type: InnoDB
linux ubuntu mysql home-directory

1 Answers

  1. Best Answer

    If you are not using INNODB or the innodb_file_per_table, then just stop the database server, move the database folder to whatever location you like, then create a symbolic link to the new location from the mysql folder. Mysql will still need access to the files, so you can't simply change the permissions so that particular user owns the directory/files though. Please do test first with test data.

    • 2