You can define different database location with simple symlink create new database witrDB

$ mysql -u witr -p > CREATE DATABASE witrDB; > quit

list all stored databases

$ sudo ls /var/lib/mysql/

witrDB must be listed stop mysql service

$ sudo service mysql stop

move witrDB to different location

$ sudo mv /var/lib/mysql/witrDB /drive/myDrive/myDatabases/

create symlink

$ sudo ln -s /drive/myDrive/myDatabases/witrDB /var/lib/mysql/witrDB

restart mysql service

$ sudo service mysql start

If mysql server jobs start fails:

1. ensure that linux user have rights on your new database directory

$ chown youruser.yourgroup /drive/myDrive/myDatabases/witrDB

1. look for apparmor config

$ sudo vi /etc/apparmor.d/usr.sbin.mysqld

add these two lines: /mnt/perso/mysql.perso/ r, /mnt/perso/mysql.perso/** rwk,

$ sudo service apparmor restart

1. restart mysql service and try again

$ sudo service mysql restart