Ubuntu – Moving a single MySql database to a separate physical disk

I am trying to move a single MySql database to another physical disk in my Ubuntu machine. I am using Ubuntu 17.04.

the external drive is mounted in /etc/fstab as follows (last line):

#zoneminder external drive
/path/to/new/location/zoneminder/images /var/cache/zoneminder/images none defaults,bind  0 2
/path/to/new/location/zoneminder/events /var/cache/zoneminder/events none defaults,bind 0
/dev/disk/by-uuid/a98ab607-15eb-4089-9197-7d26c3576cf9 /path/to/new/location ext4 x-gvfs-show 0 0

I have tried the following steps:

stop mysql service:

sudo service mysql stop

Change owner of the mounted drive (I need to update the fstab entry to incorporate this,but one problem at a time!):

chown mysql:mysql /path/to/new/location

move to mysql folder

cd /var/lib/mysql

copy database (called zm) to the new location

sudo rsync -av zm /path/to/new/location/zm

rename old database

sudo mv zm zm.old

create symbolic link to the database we rsynced

sudo ln -s /path/to/new/location/zm

move to the new database location

cd /path/to/new/location

doing an ll at this point shows me that mysql is the owner of /path/to/new/location/zm

set file permissions

sudo chmod 700 zm
cd zm
sudo chmod 660 *

add the new location to apparmor

sudo nano /etc/apparmor.d/usr.sbin.mysqld

add

/path/to/new/location/ r,
/path/to/new/location/** rwk,

(re)start services

sudo service apparmor restart
sudo service mysql start

Log into mysql:

mysql -u root -p

open the new database

use zm;

show tables

show tables;

and here I get an error:

ERROR 1018 (HY000): Can't read dir of './zm/' (errno: 13 - Permission denied)

I've also tried chmod 777 and chmod 777 * in /path/to/new/location without success