howto move mysql freebsd without dump

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

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>