Increase space for /var/db/
Hello, I have a 4.5 FreeBSD server with mysql database. only 250MB was allocated to /var/db. Our database is increasing so fast that now i need to expand the memory for /var/db. I guess one way to do is to install a new hard drive and then mount it to /var/db. But i would like to know if there is any other way to solve that problem. Is making a soft link a good idea. i have 70GB in /usr/ so i would like to map /var/db/ to some location in /usr/. Please let me know if anyone has any suggestions. Thanks in advance, Naveen. - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Increase space for /var/db/
In the last episode (Dec 17), samy lancher said: Hello, I have a 4.5 FreeBSD server with mysql database. only 250MB was allocated to /var/db. Our database is increasing so fast that now i need to expand the memory for /var/db. I guess one way to do is to install a new hard drive and then mount it to /var/db. But i would like to know if there is any other way to solve that problem. Is making a soft link a good idea. i have 70GB in /usr/ so i would like to map /var/db/ to some location in /usr/. Please let me know if anyone has any suggestions. That's what I do. $ ls -l /var/db/pkg lrwxr-xr-x 1 root wheel 20 Apr 14 2003 /var/db/pkg@ - ../../usr/var_db_pkg -- Dan Nelson [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Increase space for /var/db/
Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Dec 17), samy lancher said: Hello, I have a 4.5 FreeBSD server with mysql database. only 250MB was allocated to /var/db. Our database is increasing so fast that now i need to expand the memory for /var/db. I guess one way to do is to install a new hard drive and then mount it to /var/db. But i would like to know if there is any other way to solve that problem. Is making a soft link a good idea. i have 70GB in /usr/ so i would like to map /var/db/ to some location in /usr/. Please let me know if anyone has any suggestions. That's what I do. $ ls -l /var/db/pkg lrwxr-xr-x 1 root wheel 20 Apr 14 2003 /var/db/pkg@ - ../../usr/var_db_pkg Hello, thanks for the quick response. Is this a soft link?, what happens to the existing data in /var/db. I do not want to loose that data. thanks, -- Dan Nelson [EMAIL PROTECTED] - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Increase space for /var/db/
In the last episode (Dec 17), samy lancher said: thanks for the quick response. Is this a soft link?, what happens to the existing data in /var/db. I do not want to loose that data. I did this: $ cd /var/db $ mv pkg /usr/var_db_pkg $ ln -s ../../usr/var_db_pkg pkg -- Dan Nelson [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Increase space for /var/db/
On Wed, 17 Dec 2003 08:04:58 -0800, samy lancher wrote: I have a 4.5 FreeBSD server with mysql database. only 250MB was allocated to /var/db. Our database is increasing so fast that now i need to expand the memory for /var/db. I guess one way to do is to install a new hard drive and then mount it to /var/db. But i would like to know if there is any other way to solve that problem. Is making a soft link a good idea. i have 70GB in /usr/ so i would like to map /var/db/ to some location in /usr/. Please let me know if anyone has any suggestions. First time I had to do this I did the link suggestion that other people have posted. But you have another cleaner option w/ MySQL. There is a my.cnf file where you can set a DATADIR variable (I think that's what it's called) to set the path for the database files. Then you can point that to /usr/mysql or whatever. Just read up on my.cnf and how it's used for more info. It either goes in /etc or /usr/local/etc I think. The reason I'm vague is that I don't do it that way myself. I use the /usr/local/etc/rc.d/ scripts (which I don't think were used in 4.5?) so I have an option right within the mysql-server.sh script there for setting the datadir (DB_DIR). ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Increase space for /var/db/
On Wed, 17 Dec 2003 14:32:50 -0800, samy lancher wrote: thanks for the response. you are right, for 4.5 freebsd there is no reference of DB_DIR in mysql-server.sh. I looked for my.cnf in /etc and /usr/local/etc, but i did not find it in those folders. i feel that this file does not exist in my system. any suggestions? The file doesn't exist by default I don't believe. You have to create it if you want MySQL to use it. If you do a search on my.cnf on the MySQL website you'll come up with lots of documentation on the syntax of its contents. Good luck! ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]