Hi,
Iam getting the error Can't connect to local MySQL server through socket whenever
Iam trying to start mysql prompt.
Kindly Help. Following is the trace. Iam using an Unix Solaris8.
svtlab7/opt/mysql/bin% mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server
Jens Porup wrote:
G'day,
A different tack on my problem.
mysqldump is giving me the following error:
rack002:~# mysqldump -u root -p rt2 rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping
table 'Attachments' at
Somewhere about Tue, 10-Aug-2004 at 02:19PM +0200 (give or take), Carsten Pedersen
wrote:
| Hi Patrick,
|
| On Tue, 2004-08-10 at 12:16, Patrick Connolly wrote:
| Is this the most appropriate list to mention misprints? There doesn't
| seem to be an indication where additional suggestions are
Sometimes,my php program query the mysql using SELECT.
And I got this error,
mysql error: Record has changed since last read in table 'table'
mysql error number: 1020
The table is HEAP type,and this error will appear sometimes.
Not always.
Why did me get this error?Any suggestion?
I am using
Does anyone know of any good MySQL training centres
in the UK,
preferably in the north? Ive googled but couldnt find
anything suitable, mostly down south.
Michael Mason
Business Support Services
Arras People
Tel: 01706 342310
Mobile:
07793 782287
Fax: 01706 642754
Visit
Hi,
i've a rather large table (~ 1.800.000 rows) with five CHAR columns - let's say col1,
col2, , col5. Col1has the primary key. The columns col2,col3,col4,col5 hold
strings of variable length. I need to find duplicate entries that have the same value
for col2,col3,col4 col5 but (and
Currently your timeout values are set for four hours. I would first attempt
to adjusty these to whatever suits your needs. Then connect and see if the
connections are disconnected.
-Original Message-
From: Linda
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 8/17/04 9:13 PM
Subject: Re:
Either the socket has been removed or is in a different location than you
think. Try connecting by host and port. I would also verify with a database
restart that the socket is being created where you think it is. If you
continue to have issues look over this page to see if it helps.
Hi,
My name is Carl Millen, and I am writing you this email from my home here in
sunny Queensland, Australia. The reason for this email is that you and I share
something in common...
At some point in our lives we contemplated or tried to start a home business.
Don't worry; I'm not trying to
Hi All
I am very confused about MySQL 4.1.3. I have problems with the character set
and the collation. Under 4.0.20 I had never such problems.
I downloaded the beta-files from version 4.1.3b and zipped it to c:\mysql.
Then I loaded my data within a script with load data infile into my
I guess it depends what the code is written in.
If the application is based on a lot of Oracle Stored Procedures then
you would have to port those stored procedures to a language suitable
for MySQL.
If the application was written in Java or Perl using JDBC or DBI then
porting the application
This is not a mysql problem, it is a phpmyadmin problem. You must be using
2.6.0 rc1, download 2.6.0 beta 2 and you won't have the problem any more. I
have complained to them about it, but not exactly sure what they are going
to do.
Donny
-Original Message-
From: Martin Rytz
Question I have wondered about: Is it a good practice to put html in a
text field, then (eg. via php) when the marked-up text renders in a
user's browser it's good looking html. If not, then I'd just sandwitch
field content in a p/p when it's rendered. Though, seems like it
would mess-up fulltext
I have two columns in a table: start_time and end_time. Both are of
types DATETIME
When I select rows from table, I want to select only those rows where
the current time falls between start_time and end_time
Can someone help with the SELECT syntax for this?
Best Regards
Vishwa Rao
Does the date matter, or only the time?
If date matters (you want to find all records between 2004-06-01
10:00:00 AND 2004-06-03 18:00:00):
SELECT columns FROM table WHERE start_time = '2004-06-01 10:00:00' AND
end_time = '2004-06-03 18:00:00'
If only time matters( you want to find all records
Vishwa:
Sorry -- I used a specific time value as an example, but since you were
asking about current time, you would use CURTIME():
SELECT columns FROM table WHERE DATE_FORMAT( start_time, '%H:%i:%s' )
= CURTIME() AND DATE_FORMAT( end_time, '%H:%i:%s' ) = CURTIME();
Wes
On Aug 18, 2004, at
Please read:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html for more
details.
I haven't tested it but this formula comes to mind :
SELECT field_list_goes_here
FROM table_name_goes_here
WHERE CURTIME()= TIME(start_time)
AND CURTIME() = TIME(end_time)
Yours,
Shawn Green
Edd:
The best way is likely dependent on some factors that involve your storage
engine(s) (e.g. MyISAM, Innodb, etc) and the nature of the media you plan
to use to move the file created.
The smallest file you can produce is via mysqldump. Your 4GB db includes
all of your indexes. When using
All:
I created this script to analyze the tables on a periodic basis. It
accounts for changes in the schema by using a database table called SysTable
in each db to be analyzed.
Create table SysTable
TableName varchar(255) not null
);
We run this once per week now using a CRON job.
Hi all, i have a MySQL driven web system that searches a pretty big DB of
property info. (10 data tables, about 50,000,000 total rows, average 300
concurrent users)
There are actually 2 databases that feed this site, one is meta info, and isnt
hit that heavily. Lets call those DB's 'data' and
After running in production for about seven months, our dumps on one of
our BDB tables performed with 'mysqldump --quick' began failing with the
message:
'mysqldump: Error 1030: Got error 12 from table handler when dumping
table `reference` at row: 504979'.
We got this error about five months
At 08:37 AM 8/18/04, leegold wrote:
Question I have wondered about: Is it a good practice to put html in a
text field, then (eg. via php) when the marked-up text renders in a
user's browser it's good looking html. If not, then I'd just sandwitch
field content in a p/p when it's rendered. Though,
Thanks, it works now. I have related question.
I am calling this from perl.
my @values= $dbh-do(SELECT start_date FROM TableSLA WHERE NOW()-
Start_Date = 0 );
This returns the number of rows that satisfied the condition instead of
returning an array of values for start_date.
Also If I have to
On Wed, 18 Aug 2004 11:37:03 -0400
leegold [EMAIL PROTECTED] wrote:
Question I have wondered about: Is it a good practice to put html in
a text field, then (eg. via php) when the marked-up text renders in
a user's browser it's good looking html. If not, then I'd just
sandwitch field content
I got it working, please disregard the perl related question.
-Original Message-
From: Viswanatha Rao [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 1:15 PM
To: [EMAIL PROTECTED]
Cc: 'Wesley Furgiuele'; [EMAIL PROTECTED]
Subject: RE: select rows by compare on datetime column
Hi, all:
In my solaris account, there is a .my.cnf file for me to access
mysql in remote machine.
In the current file, it is configured as:
host=sg1p.net.tamu.edu
socket=/tmp/mysql.socka
If I want to add other remote machine name as netinfo.tamu.edu with
mysql in the .my.cnf file,
How can i
Victor Pendleton [EMAIL PROTECTED] wrote on 08/17/2004 10:54:14 AM:
Are there any errors being caught by the web form or being logged to the
MySQL error log?
I checked the log, there are no errors listed at all. It looks okay. No
error message appears when running the script. I double
I have to select mysql rows based on the following condition.
Time t1 = (current time - 4 hours);
Time t2 = (current time - 8 hours);
In my case, I want to select all those rows that have start times
(1) between current time and t1
(2) between time t1 and t2
... and so on
So I have to somehow
Hoping I can figure this out. Using MySQl
4.0.20-Standard.
I have a table (tried this both myISAM and Innodb)
with 12 fields, 3 are ints, 7 are varchars and 1 is
set to text.
Form is using a textarea for input into the text
field. Basically a copy and paste of rich text. (I'm
not concerned
The setting in the my.cnf is just a default setting. It's impossible to
have more than one default value. Whichever value you specify last is what
the setting will be.
When you need to connect to a second server, you need to open another
client and specify the hostname you want it to connect
- Original Message -
From: Stuart Felenstein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 3:49 PM
Subject: Strange Text Field
Hoping I can figure this out. Using MySQl
4.0.20-Standard.
I have a table (tried this both myISAM and Innodb)
with 12 fields,
What is the application you are using to insert and retrieve the blob data?
Is the data actually being inserted?
-Original Message-
From: Stuart Felenstein
To: [EMAIL PROTECTED]
Sent: 8/18/04 2:49 PM
Subject: Strange Text Field
Hoping I can figure this out. Using MySQl
4.0.20-Standard.
Can you log on as the web account and try to insert, update, select directly
from the MySQL monitor?
-Original Message-
From: Chip Wiegand
To: Victor Pendleton VPendleton
Cc: '[EMAIL PROTECTED] '
Sent: 8/18/04 2:41 PM
Subject: RE: I can delete, add, but not update
Victor Pendleton [EMAIL
What version of MySQL are you using? You have different options.
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Look at DATE_SUB() and SUBDATE()/SUBTIME().
The time part of the query would look something like DATE_FORMAT(
DATE_SUB( NOW(), INTERVAL 4 HOUR ), '%H:%i:%s' ), or
I understand about supplying the code and will. I'm
actually rebuilding it again.
Language is Php and Adodb and not to get to estoteric,
I'm using a RAD called Impakt which fits into
Dreamweaver.
Anyway, while I can supply the code, the weirdness is
that it won't work in one table but will in
In the table that fails, and the one that works, I'm
using some products from a company called Interakt. I
mentioned this in my last reply, however didn't
mention one part.
With this suite of tools , I can replace a text area
with a mini html / cms tool. Basic formatting etc.
Now in the 2nd
Are both of these fields defined as blob datatypes? Since one table works
and the other does not work this leads me to question whether the
application is performing consistently. Have you verified if data is entered
into that does not display as expected?
-Original Message-
From: Stuart
I'm running into the following error when I try to compile MySQL 4.1 on my
server. Any advice? I'm not sure what -lz is...
g++ -O3 -DDBUG_OFF -O3 -mcpu=i686 -felide-constructors -fno-rtti
-fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti
-rdynamic -o mysqld sql_lex.o
is there way to interrogate what is inside a column specifically a special
character?
thanks,
Martin Gainty
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
Okay, still not working in this one table so here is
all my info: I've also attached the table dump.
Thank you ,
Stuart
Error Code from attempted transaction:
-
Transaction failed!
Your SQL:
insert into LFWBank
Yong,
If that is the full contents of your my.cnf file, the message is self
explanatory: you have not specified a [mysql] section header before you
specify a recognized option. There is typically only one my.cnf file on
any machine (exceptions do exist). Each my.cnf file can contain both
--- Victor Pendleton [EMAIL PROTECTED] wrote:
Are both of these fields defined as blob datatypes?
Yes, the two tables (one working, one not) both are
set to text (I realize Blob is basically the same)
Since one table works
and the other does not work this leads me to
question whether the
--- Rhino [EMAIL PROTECTED] wrote:
Sorry I didn't answer this one before. No it does
not.
I typed 6 letters and it kicked it back.
And that was using just a regular text area
Stuart
Does your program store the data correctly if you
just put regular text in
the form field, rather than
I found the problem - it was in an include file, not with the script. It
had a variable that should have been changed from $address1 to $address,
but wasn't in that one particular file.
Anyway, thanks for the replies.
--
Chip
Victor Pendleton [EMAIL PROTECTED] wrote on 08/18/2004 01:09:25 PM:
- Original Message -
From: Martin Gainty [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 4:24 PM
Subject: contains?
is there way to interrogate what is inside a column specifically a special
character?
thanks,
Try the LIKE operator. For example:
select *
There is not a function equivalent to Oracle's dump but you could throw
together a substring loop that prints out the ascii value of each character.
-Original Message-
From: Martin Gainty
To: [EMAIL PROTECTED]
Sent: 8/18/04 3:24 PM
Subject: contains?
is there way to interrogate what is
In the last episode (Aug 18), Stuart Felenstein said:
Okay, still not working in this one table so here is all my info:
I've also attached the table dump.
Thank you ,
Stuart
Error Code from attempted transaction:
-
Transaction failed!
Dan,
Don't hate me for saying this but you are the MAN!
Yep, it was Contact Email. Oops !
It works great now
Thank you all!
Stuart
--- Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Aug 18), Stuart Felenstein
said:
Okay, still not working in this one table so here
is all my
When loading a new InnoDB database, I received the error:
Error: The table 'property' is full
I was quite surprised to get this error. When looking at the file sizes, i
notieced that InnoDB tables on 4.1.3beta take up at least twice the space on
the filesystem as MyISAM tables on 4.0.2
Is this
Thanks.
I used
SELECT Start_time, End_time FROM Table WHERE Start_time - DATE_SUB(
NOW(), INTERVAL 4 HOUR ) =0
It works.
-Original Message-
From: Wesley Furgiuele [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 3:11 PM
To: Viswanatha Rao
Cc: [EMAIL PROTECTED]
Subject: Re:
Hi Folks --
I'm running into some issues with large prepared statements, and would love some
feedback about approaches or tweaks that I might have overlooked :)
I'm working on a large-scale database for scientific data -- lots of individual
detector values and whatnot, that unfortunately need to
Im trying to update multiple columns at once but
cannt do it in an efficient way.
What I am trying to do is:
Update table temp,
When: ( Q1A=1 AND Q1E=1 AND Q1F=1 AND Q1G IN
(,NA) ) THEN SET (Q1E=6,Q1F=5, Q1G=999),
OR When ( (Q2A=1 AND Q2E=1 AND Q2F=1 AND Q2G IN
(,NA) THEN SET
-lz means to link with libz (the zlib library http://www.gzip.org/zlib/),
but the error is that it couldn't be found. Do you have zlib? I'd expect
yes, or configure should have complained.
Michael
Casey Allen Shobe wrote:
I'm running into the following error when I try to compile MySQL 4.1 on
You don't want to do that. You are using a function of your Start_time
column in your comparison. That prevents the use of any index on
Start_time, so a full-table scan will be required. Always compare a column
to a constant (or a range), if at all possible. Fortunately, that's easy in
Assuming that column Q3F in your example is really Q2F, the query is doing
exactly what you told it to do. Rows which match your WHERE clause are
being updated according to your SET clause.
As I understand you, there are two different sets of rows you wish to
update. The first set are the
Yes, that makes sense.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 9:05 PM
To: Viswanatha Rao
Cc: 'Wesley Furgiuele'; [EMAIL PROTECTED]
Subject: Re: select rows by compare on datetime column - more on time
decrement
You don't want
56 matches
Mail list logo
