changing data directory

[Archanak]

Hi,

I changed the data directory of mysql through my.cnf file.

my.cnf has the details.

"#" indicates the i have changed accordingly to the main directory.

I want to move my tables from /var/lib/mysql to /home/db.

I changed the permission to:-
sudo chown -R mysql:mysql /home/db/*

[mysqld]
 
datadir=/var/lib/mysql
#datadir=/home/db
 
socket=/var/lib/mysql/mysql.sock
 
#socket=/home/db/mysql/mysql.sock
set-variable=max_allowed_packet=16M
 
 
[mysql.server]
user=mysql
 
basedir=/var/lib
#basedir=/home/db
 
[safe_mysqld]
 
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
 
#err-log=/home/log/mysqld.log
#pid-file=/home/run/mysqld/mysqld.pid
 

But still it is giving an error:-

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I don't what to do?

pls help!!

with regards
Archana

[r035198x]

Hi,

I changed the data directory of mysql through my.cnf file.

my.cnf has the details.

"#" indicates the i have changed accordingly to the main directory.

I want to move my tables from /var/lib/mysql to /home/db.

I changed the permission to:-
sudo chown -R mysql:mysql /home/db/*

[mysqld]

datadir=/var/lib/mysql
#datadir=/home/db

socket=/var/lib/mysql/mysql.sock

#socket=/home/db/mysql/mysql.sock
set-variable=max_allowed_packet=16M


[mysql.server]
user=mysql

basedir=/var/lib
#basedir=/home/db

[safe_mysqld]

err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#err-log=/home/log/mysqld.log
#pid-file=/home/run/mysqld/mysqld.pid


But still it is giving an error:-

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I don't what to do?

pls help!!

with regards
Archana

Is the mysql.sock file in that folder?

[Archanak]

Is the mysql.sock file in that folder?

i can't copy mysql.sock file

[r035198x]

i can't copy mysql.sock file

Why not?

[pbmods]

Heya, Archanak.

Is mysqld running?

[Archanak]

Heya, Archanak.

Is mysqld running?

Hi,

ya if i give the original datadir then it runs otherwise no.

[pbmods]

Heya, Archanak.

I assume that you are shutting down mysqld and relaunching it between my.cnf revisions?

[justchecking1234]

Hi everyone... I'm configuring a simple master-slave replication and it's not that hard if you do it in linux, since it's unix I thought it was the same deal in MAC OS X 10.4...but nope. In linux u have to modify the /etc/mysql/my.cnf for the master but there is no such folder as /etc/mysql in Mac, so which file should I modify? many many thanx...

[pbmods]

Heya, JustChecking. Welcome to TSDN!

It depends on the configuration options when the software was compiled.

Try /etc/my.cnf

[hgyorgy]

Hi!

You must change the mysql user's home dir to new one in /etc/passwd file (because it run chrooted)

Gy.