mysql change path

Fran

New member
Joined
Mar 12, 2006
Messages
2
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
 
Did you modify the directory MySQL is looking for it's data in, or adjust the symlink, whatever is done on rpm based installations?
 
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 :(
 
Back
Top