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

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    Markdown is turned off in code blocks:
     [This is not a link](

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see

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>