I recently installed mysql on a new system and the client on works with root?
Whats up?
ruben@www2:~ !mys
mysql -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ruben@www2:~
--
__
Brooklyn Linux Solutions
On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote:
We've managed to reproduce this pretty reliably at Yahoo and are
working to track and fix the bug. If we find a resolution, I'll post
a note here.
There have been a few threads regarding high CPU utilization on
FreeBSD systems.
Yeah,
hi guys
im working with some unicode data , store it in mysql db and retrieve it
now its storing the data fine when i use longtext or mediumtext
EXCEPT for a few characters it gives BOXes fo those characters in the
web-browser
the boxes suddenly increase their numbr of existance if i
Hi all,
I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
tried 51. No dice. It does not handle load, CPU and the load average go
through the roof. I'm using Red Hat Linux 7.2 and the official mysql
binaries. It appears to be slow to connect, causing 0.5 to 1.0 second
delay
Of course it's running. I can only get in as the root user
of the system
On 2002.06.23 03:51 Brandon McCombs wrote:
Ruben I Safir wrote:
I recently installed mysql on a new system and the client on works with root?
Whats up?
ruben@www2:~ !mys
mysql -p
Enter password:
You can achieve a similar thing with the WHERE column IN (SELECT column FROM
table WHERE ..) subselect. In the current version of MySQL, this is not yet
supported, but I've heard fearies tell that it will be in version 4.1, or
else some other version to be released in the somewhere near future.
Ruben I Safir wrote:
I recently installed mysql on a new system and the client on works with root?
Whats up?
ruben@www2:~ !mys
mysql -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ruben@www2:~
mysqld isn't running. Launch
Hi all:
I am running mysql-max 3.23.51 on linux 2.4.x and
my shell is bash. The 'huponexit' shell option
is off. The mysqld (mysql-max daemon) is
probably not important for this discussion, any
other daemon would do as well.
Firstly, I can start mysqld (or other programs)
asynchronously by
Hi there,
I must start out by saying that i am a newbie in the Mysql arena. If i
can i will give a bit of background information. Where i work we
currently have a MS SQL 7.0, It has a database on there of support calls
(100,000 records) that i would like to take and import into Mysql. Thus
On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote:
Hi all,
I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
tried 51. No dice. It does not handle load, CPU and the load average go
through the roof. I'm using Red Hat Linux 7.2 and the official mysql
[Please CC: directly to me, I'm not subscribed]
Hi,
maybe a pointer to the documentation is sufficient, but does
mysqld uses linux-threads or processes?
And is there way to control them? After I start up mysqld I
see 3 processes with ps. After some time (e.h. 12 hours)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Cal --
...and then Cal Evans said...
%
% TjL,
%
% To start with:
Thanks for the titles!
...
% Work your way through both books in a couple of months and then spend every
% waking hour organizing data into tables for a couple of years and you'll
I do not understand string comparison. Why doesn't the
following work:
SELECT id, songname FROM songs WHERE songname = Empire;
All I get is: Empty set (0.00 sec)
I know the string exists in the database:
In record 135 exists:
Empire |
| 135 |
Do I have
Thanks, that worked for song named Empire, however,
when I checked other song names such as songname
called One I get two results:
| id | songname |
+++
| 35 |
You're Still The One |
| 57 |
One |
+++
2 rows
well I have problem and I don´t know where ask for help,
so i´m trying you.
My problem is i´m developing my project using mysql
4.0.1, in a single computer (not net), OS windows 98,and
using Delphi 5. well SOMETIMES (NOT IN ALL RECORDS) when
i try to edit a record the program send me an
* toby -
im working with some unicode data , store it in mysql db and retrieve it
now its storing the data fine when i use longtext or mediumtext
EXCEPT for a few characters
Try using longblob or mediumblob.
--
Roger
sql
I tried posting this on the bug list and it rejected it.
I've got this bug in a php script of mine and I think it's because of MySQL.
I have a value I am inserting into a database and above and below my query I
can echo out the value and it is correct, but the query keeps assuming it is
127 No
* [EMAIL PROTECTED]
Thanks, that worked for song named Empire, however,
when I checked other song names such as songname
called One I get two results:
| id | songname |
+++
| 35 |
You're Still The One |
| 57 |
One |
Hi,
Your column comid is probably declared as a tinyint which has a range
between -128 and 127 (for not UNSIGNED column).
If you want to allow larger values, change the column type accordingly.
(Take a look here :
http://www.mysql.com/doc/C/o/Column_types.html
)
Regards,
Jocelyn Fournier
I don't think this is a bug, you probably choose TINYINT datatype for the
column, and the maximum value a TINYINT column can have is 127, so anything
over 127 will automatically be changed to 127 silently by MySQL. Choose an
appropriate column datatype for your field.
See:
* Chris Beasley
I tried posting this on the bug list and it rejected it.
I've got this bug in a php script of mine and I think it's
because of MySQL.
I have a value I am inserting into a database and above and below
my query I
can echo out the value and it is correct, but the query keeps
SELECT id, songname FROM tablename WHERE TRIM(BOTH ' ' FROM songname)=One;
See: http://www.mysql.com/doc/S/t/String_functions.html
Gurhan
- Original Message -
From: [EMAIL PROTECTED]
To: Jan Peuker [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, June 23, 2002 8:58 AM
Subject: Re:
I'm trying to extract information from MySQL with Microsoft Access but
it will not pull a query with BIGINT columns correctly. I'm using the
newest ODBC driver, version 3.51.03 and MySQL Server Alpha 4.0.1. I've
installed the ODBC driver, configured the DSN, and can access all other
types of
OK I must say I don't think much of this filter if it couldn't tell
it was a relevant question. After all, there's a select statement in
it!! Anyway, any help or comments appreciated. Since initially
sending this, I've learned why my predecesser did it this way -- eight
hours later, and it's
Hi, members,
I'm relatively new to mySQL. I have several databases up and running but
am facing one recurring, and quite annoying, problem: mysqld is shutting
itself down. Here's the sequence that results in the shutdown:
020623 0:29:23 /usr/libexec/mysqld: Binlog closed, cannot RESET MASTER
Markus Fischer wrote:
[Please CC: directly to me, I'm not subscribed]
Hi,
maybe a pointer to the documentation is sufficient, but does
mysqld uses linux-threads or processes?
mysqld uses threads (you already found the right documentation).
And is there way to
php will close the connection when the script finishes unless you are using
mysql_pconnect which opens a persistent connection.
http://za2.php.net/manual/en/ref.msql.php
Paul Roberts
[EMAIL PROTECTED]
- Original Message -
From: Joseph Bueno [EMAIL PROTECTED]
On Sun, Jun 23, 2002 at 08:02:45PM +0100, Paul Roberts wrote :
php will close the connection when the script finishes unless
you are using mysql_pconnect which opens a persistent
connection.
Yup, ever resource besides persistent ones are cleaned up
upon script termination.
From:
I wrote earlier:
select b.id, a.aid, a.wid, a.start, a.length
into outfile 'newindex.txt'
from wordindex a, wordforms b
where a.wordform = b.wordform
order by b.id, a.id, a.wid, a.start;
I've actually sat down and tried this at the mysql command line.
-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : dimanche, 23. juin 2002 23:07
À : [EMAIL PROTECTED]
Objet : MySQL Query using ASP
Hi all !
once again thanks for the help you provide me by being so active on this
mailing list :)
I have a litle problem
OOPS sorry
I found the answer by myself
It was just the % symbol that was misplaced
:))
-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : dimanche, 23. juin 2002 23:09
À : [EMAIL PROTECTED]
Objet : RE: MySQL Query using ASP
-Message d'origine-
De
Hi,
I hope I'm at the right list!
I'm trying to start mysql -I have installed the db.
Now I'm getting the following:
[localhost:~] lloyd% sudo safe_mysqld --user=root
[1] 630
[localhost:~] lloyd% Starting mysqld daemon with databases from
/usr/local/mysql/data
020623 20:25:20 mysqld ended
I'm trying in vain to build the latest version of MySQL 3.23.51 (downloaded
today) on a new AIX box we've recently setup. It has the latest IBM
patches for the VisualAge C++ compiler v5, bringing it up to rev 5020.
When building, there are two problems.. One is that the configure script
Hello,
What version of UNIX are you running?
Solaris, Linux, FreeBSD, BSDI?
You can find that out my typing in uname -a
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 11:01 AM
Subject: help starting up mysql
Hi,
I hope I'm at the
hi,
i checked the manual, but i want a confirmation here: Mysql for window
doesn't have UDF, right?
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
oops, Mac OS X.
Lloyd
on 6/23/02 10:16 PM, Danny, typed:
Hello,
What version of UNIX are you running?
Solaris, Linux, FreeBSD, BSDI?
You can find that out my typing in uname -a
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24,
See below:
oops, Mac OS X.
on 6/23/02 10:16 PM, Danny, typed:
Hello,
What version of UNIX are you running?
Solaris, Linux, FreeBSD, BSDI?
You can find that out my typing in uname -a
. . .
Hi,
I hope I'm at the right list!
I'm trying to start mysql -I have
I couldn't ./configure and make mysql.The mistake is:
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
I couldn't ./configure and make mysql.The mistake is:
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
Hi, Can anybody tell me how i can calculate the months between two dates in
mysql.
thanks in advance
Regards
D K Dubey
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Consider taking a look at the manual:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Perhaps read parts of it, too.
Fix your PC's date (the current year for most of us is 2002). Many of us who
receive e-mail dated in the past filter it to /dev/null.
Van
--
41 matches
Mail list logo