to move mysql on freebsd without using a dump file follow these steps:
- stop mysql
- copy /var/db/mysql to its new location
- chown -R mysql:mysql
- modify /etc/rc.conf and add line mysql_dbdir=”
“ - modify /usr/local/etc/rc.d/mysql-server and change mysql_dbdir=”/var/db/mysql” to the new location of your mysql directory
- Start up mysql: /usr/local/etc/rc.d/mysql-server start