help needed to mount data from /var/lib/mysql

[balaraju mandala]

Hi Everybody,

I need small help from you. In my Linux box i have limitation of Size in
partition. I have only 5 GB space for /var. MySQL is installed in this
partition only. I want to give another path like /home, where i have 120GB
of space. Somebody told me that we need to change the data path of MySQL,
but he is not sure of that. Can anybody knows abt this?

Re: help needed to mount data from /var/lib/mysql

[chris smith]

On 8/19/06, balaraju mandala [EMAIL PROTECTED] wrote:

Hi Everybody,

I need small help from you. In my Linux box i have limitation of Size in
partition. I have only 5 GB space for /var. MySQL is installed in this
partition only. I want to give another path like /home, where i have 120GB
of space. Somebody told me that we need to change the data path of MySQL,
but he is not sure of that. Can anybody knows abt this?


Edit the my.cnf and change the data path.

Then read this page:

http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html

about how to set up your new environment.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: help needed to mount data from /var/lib/mysql

[ViSolve DB Team]

Hello,

You can change the MySQL data path in /etc/my.cnf  by editing the 
configuration parameter datadir with new data path. Once you done the 
changes in my.cnf, reboot the MySQL server.


Thanks,
ViSolve DB Team


- Original Message - 
From: balaraju mandala [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Saturday, August 19, 2006 12:28 PM
Subject: help needed to mount data from /var/lib/mysql



Hi Everybody,

I need small help from you. In my Linux box i have limitation of Size in
partition. I have only 5 GB space for /var. MySQL is installed in this
partition only. I want to give another path like /home, where i have 120GB
of space. Somebody told me that we need to change the data path of MySQL,
but he is not sure of that. Can anybody knows abt this?







No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.3/423 - Release Date: 8/18/2006


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: help needed to mount data from /var/lib/mysql

[balaraju mandala]

Hi All,

Thank you for u r reply. But i am unable to find my.cnf, is i need to create
this file.

Re: help needed to mount data from /var/lib/mysql

[balaraju mandala]

I am unable to start server after shifting to new location.

i tried to start 'mysqld' but it was failed. A blank mysql.sock file is
creating. Entries of log files are also not reporting any problem.

Re: help needed to mount data from /var/lib/mysql

[balaraju mandala]

if i search for any process running i am getting following thing.

[EMAIL PROTECTED] mysql]# ps -ef | grep mysqld
root 18389 1  0 13:09 pts/300:00:00 /bin/sh /usr/bin/mysqld_safe
--defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid
mysql18422 18389  0 13:09 pts/300:00:00 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usr --datadir=/home/mysql
--user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/home/mysql/mysql.sock
root 18725 15850  0 13:47 pts/300:00:00 grep mysqld

i am new to this concept please help me.