how to move a directory from current partition/drive to a new partition/drive

[jlehtone]

Yes.

Note that once you have a filesystem, you have to mount it to somewhere else than /var/lib/mysql, at least temporarily.
Otherwise you cannot copy from /var/lib/mysql into the new volume.

If you will mount the new filesystem to /var/lib/mysql (and only there), then the entry in fstab is more similar to existing entries (i.e. not a "bind").
It is good to refer to filesystem with UUID. You can see UUIDs with:

Code: Select all

blkid

Note also, that if you have file X in /var/lib/mysql and mount something to /var/lib/mysql, then you cannot access the X, because it is hidden by the mount (yet occupies space within the '/' filesystem).

[StariBrko]

just want to inform you that everything passed as smooth as it is possible and works as a charm.

topic solved with success.

thanx again