howto move mysql freebsd without dump

Steve Stonebraker
November 17, 2011

to move mysql on freebsd without using a dump file follow these steps:

  1. stop mysql
  2. copy /var/db/mysql to its new location
  3. chown -R mysql:mysql
  4. modify /etc/rc.conf and add line mysql_dbdir=”“
  5. modify /usr/local/etc/rc.d/mysql-server and change mysql_dbdir=”/var/db/mysql” to the new location of your mysql directory
  6. Start up mysql:  /usr/local/etc/rc.d/mysql-server start
Tags: , ,