Hi Mike and Hiram, Thanks a lot for your answers.
My purpose is that MYSQL uses an individual directory, like /data/mysql instead of sharing system directory /var/lib. I will check our script login.pl. Thanks & Regards Wuqi -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Pheasant Sent: Tuesday, May 05, 2009 2:54 PM To: WANG Wuqi Cc: Hiram Clawson; [email protected] Subject: Re: [Genome] MySQL database re-location Hi Wuqi Its safest to leave the socket in the original location. Its a unix-domain socket and takes up no space. Alternatively, if you want everything in /data/mysql, the safest bet is to reset your my.cnf to the defaults and move the whole /var/lib/mysql directory to /data/mysql and put a symlink from /var/lib/mysql -> /data/mysql Cheers M On Mon, May 4, 2009 at 7:31 PM, WANG Wuqi <[email protected]> wrote: > Hi Hiram, > > > > Because space not enough, our MySQL database(version 4.0) is migrated ( > eg. relocated) from /var/lib/mysql to /data/mysql. > > In my.cnf, I set > > datadir=/data/mysql from /var/lib/mysql and > > socket =/data/mysql from /var/lib/mysql, > > > > MySQL databse can start and work well but our genome browser mirror site > encounters below errors: > > -------------------------------------start mysql by user mysql: > > Software error: > > DBI connect('database=acl;host=localhost','atif',...) failed: > > Can't connect to local MySQL server > > through socket '/var/lib/mysql/mysql.sock' (2) > > at /var/www/cgi-bin/login.pl line 36 > > > > For help, please send mail to the webmaster (r...@localhost), > > giving this error message and the time and date of the error. > > > > ---------------------------------start mysql by user: > > Internal Server Error > > The server encountered an internal error or misconfiguration > > and was unable to complete your request. > > > > Please contact the server administrator, r...@localhost and inform > > them of the time the error occurred, > > and anything you might have done that may have caused the error. > > More information about this error may be available in the server error > log. > > > > Apache/2.0.52 (CentOS) Server at ucsc.gis.a-star.edu.sg Port 80 > > ----------------------------------------. > > > > When re-set > > socket=/var/lib/mysql (original path) and > > datadir=/data/mysql (new location), > > > > Genome browser mirror site works well, everything is ok. > > > > I want to know whether "socket=/var/lib/mysql" in Genome browser mirror > > is as default one, if yes, how to change this socket? , if no, where is > > wrong for this new socket path? > > > > > > Thanks & Regards > > > > Wuqi > > > > > > > > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome > -- Michael Pheasant Associate Project Scientist UCSC Genome Browser Email: [email protected] Skype: mpheasant Phone: +1-831-459-1424 Location: Engineering2 Room 515 Post: CBSE, UC Santa Cruz, MS:CBSE/ITI 1156 High Street Santa Cruz, CA 95064, USA _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
