mysql change path

[Fran]

Hi there i have a problem with change of mysql path. I move the /var/lib/mysql to /mysql, all work okey when i joint to mysql from shell

----------------------------------------
# mysql -u da_admin -p
Enter password: *****

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 33 to server version: 4.1.11-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
----------------------------------------


well, now in DA panel i cant manage my database. Maby i must change some conf in DA for make this work ok. I need help.

thanks

 

[jmstacey]

Did you modify the directory MySQL is looking for it's data in, or adjust the symlink, whatever is done on rpm based installations?

 

[Fran]

i change/edit the /etc/my.cnf like this:

datadir = /mysql/mysql
socket = /var/lib/mysql/mysql.sock
basedir = /mysql/mysql
pid-file=/mysql/mysql/mysqld.pid

rsync -vrplogDtH /var/lib/mysql/ /mysql/mysql/
rsync -vrplogDtH /var/lib/mysql/ /mysql/mysql/

and mysql was restarted. mysql work fine in shell how u can see in the first post, but when i try this in management data base, this show me this cannot conect to data base