Date: Thu, 26 May 2005 18:45:23 +0100 From: "Barry Byrne" <barry.byrne@wbtsystems.com> To: "'Matt Virus'" <mattvirus@navix.net>, "'freebsd'" <freebsd-questions@freebsd.org> Subject: RE: Mysql vs /var partition... Message-ID: <200505261745.j4QHjOIe029795@mail.wbtsystems.com> In-Reply-To: <429604F3.1050806@navix.net>
next in thread | previous in thread | raw e-mail | index | archive | help
> -----Original Message----- > From: owner-freebsd-questions@freebsd.org > My mysql database is growing, it has subsequently filled the /var/db > partition to capacity. > I tried moving the mysql dir and symlinking it to /var/db/mysql which > didn't work. I also tried mount_null from the /usr partition to the > /var/db/mysql folder...in both instances, the mysql server > will not start. > Is there another way around this problem or do i need to > somehow resize > my /var partition? Matt: Most likely a permissions problem. I generally create a new directory on a different partition for the mysql data. You might want to use tar to preserve your permissions Something like this should work: Enusre mysql server is stopped mkdir /data/mysql chown mysql:mysql /data/mysql chmod 700 /data/mysql cd /var/db/mysql tar cf - . | ( cd /data/mysql ; tar xvf - ) mv /var/db/mysql /var/db/mysql.old ln -s /data/mysql /var/db/mysql Restart mysql Check the ownerships/permissions of the existing /var/db/mysql to be sure of what you need. - Barry
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200505261745.j4QHjOIe029795>