Moving MySQL database
iaccounts at ibctech.ca
Fri Sep 3 07:09:42 PDT 2004
> On Fri, Sep 03, 2004 at 09:42:36AM -0400, Bart Silverstrim wrote:
>> I have a server that is rapidly filling the var partition with a
>> database. I'd like to move it to a subdirectory somewhere under
>> Is there a document that would outline a "best practices" approach
>> doing this? My first instinct was to stop the mysqld, do a mv on
>> /var/db to /var/db2 to rename it, copy the data to a /usr/local/db
>> folder and alter permissions on it to match /var/db, then make a
>> softlink between /usr/local/db and /var/db and restart mysqld so
>> wouldn't need any reconfiguring and everything, I would *think*,
>> keep working...only now it will be working off a far more spacious
> I'd do it this way:
> i) Stop mysql
> ii) Remove (pkg_delete) the mysql-server package
> iii) Move the database files to their new location, taking care to
> preserve ownership, permissions, timestamps etc.
> iv) Reinstall the mysql-server port setting a different DB_DIR on
> the make command line:
> # make DB_DIR=/usr/local/db install
> v) Make sure that the home directory of the mysql user account is
> the same as you set DB_DIR to. The port should take care of
> that, but it won't hurt to double check.
> % grep mysql /etc/passwd
> mysql:*:88:88:MySQL Daemon:/usr/local/db:/sbin/nologin
> vi) Restart the mysql server. Verify that your data survived the
> And that's it: you're done.
Won't a simple symlink of /var/db/mysql to a new location (ie.
/usr/db/mysql) after the directory is moved perform the same task,
without the need to re-install?
I've never done this, but it may work, and save some troubles.
> Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks
> Savill Way
> PGP: http://www.infracaninophile.co.uk/pgpkey Marlow
> Tel: +44 1628 476614 Bucks., SL7 1TH
More information about the freebsd-questions