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

The socket hets created when you start the server It might be in the mysql home dir, it might be in /var/run. See if its declared in my.cnf Sent via BlackBerry from T-Mobile -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

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

hi experts ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) iam facing the above error while connecting the mysql database. i am also checked the mysql.sock socket file is not in /tmp. could you please help me to fix this problem. what i have to do now

MySQL Community Server 5.0.87 has been released

Dear MySQL users, MySQL Community Server 5.0.87, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts. The release is now ava

RE: Using IF in a query to set a variable then sort on said variable

An additional field is pretty much impossible since that case would change throughout the day unfortunately. But thank you all for your assistance, will do some testing. Jeff -Original Message- From: Jaime Crespo Rincón [mailto:jcre...@warp.es] Sent: Monday, October 26, 2009 12:52 PM T

Re: Using IF in a query to set a variable then sort on said variable

2009/10/26 Jeff : > Perhaps case is the way to go, I'll look into that this morning. > > Unfortunately there are three groupings. So my IF or CASE needs to check for > example: > > if timezone = 3,5,6,7 then 1 > if timezone = 1,2,4 then 2 > if timezone = 8,9 then 3 Yes, Case function is the way t

Re: MySQL - determine last date of shutdown and analyze

In the last episode (Oct 26), machiel.richards said: >I hope someone can help me out here as I am still new with MySQL. > > I am trying to determine when last a MySQL database was shut down and > when last the tables were analyzed. The server logs startups and shutdowns in the mysqld erro

RE: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

>-Original Message- >From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] >Sent: Monday, October 26, 2009 5:29 AM >To: Jerry Schwartz >Cc: [MySQL] >Subject: Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1 > >Thanks for the response Jerry. I suppose my main question is it

RE: Using IF in a query to set a variable then sort on said variable

Perhaps case is the way to go, I'll look into that this morning. Unfortunately there are three groupings. So my IF or CASE needs to check for example: if timezone = 3,5,6,7 then 1 if timezone = 1,2,4 then 2 if timezone = 8,9 then 3 So, it's a bit more complicated than I tohught it would be. I o

ANN: Database Workbench 3.4.1 Pro released!

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: " Database Workbench 3.4.1 Pro" Version 3.4.1 includes bugfixes in addition to the new features in version 3.4.0 Changes Highlights in 3.4 and previous versions --

Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

Thanks for the response Jerry. I suppose my main question is it possible/recommended to run ODBC 3.51 which version 5 of MySQL - or is it highly recommended to use ODBC 5.1 ? Regards Neil On Fri, Oct 23, 2009 at 7:24 PM, Jerry Schwartz wrote: > The UTF-8 issue was the only thing that really c

MySQL - determine last date of shutdown and analyze

Hi all I hope someone can help me out here as I am still new with MySQL. I am trying to determine when last a MySQL database was shut down and when last the tables were analyzed. Can someone please assist in this and let me know if this is possible.