Hello mysql,
after FLUSH QUERY CACHE
in error.log
021127 17:25:17 mysqld started
021127 17:25:19 InnoDB: Started
/usr/local/mysql/bin/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it
Is there a good tutorial somewhere on the join command. No matter what
I do
it just doesn't work. Obviously I'm doing something wrong, but the
MySQL
manual just doesn't help at all.
Try this link.
http://www.devshed.com/Server_Side/MySQL/Join/page1.html
One of the best books for understanding
Hello,
I recently upgraded to Visual Studio .NET to realize that I can no longer
compile my Visual C++ 6.0 projects that use the MySQL++ classes with Visual
C++ .NET. I get an error relating to the iterator and how it is templated (I
don't have the exact error with me now). Has anyone else run
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
On 12/4/02 9:04 AM, Mike At Spy [EMAIL PROTECTED] wrote:
How can I tell what port number mysql is running on? I need it for a chat
program. :)
Thanks,
-Mike
Default is 3306
/h
-
Before posting, please check:
Show Variables Like 'port';
PB
-
How can I tell what port number mysql is running on? I need it for a chat
program. :)
Thanks,
-Mike
-
Before posting, please check:
http://www.mysql.com/manual.php
On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote:
How can I tell what port number mysql is running on? I need it for a chat
program. :)
3306
A google search would have found the answer in no time.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL
mysql show variables;
3306 is the default.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 9:05 AM
To: [EMAIL PROTECTED]
Subject: mysql port number
How can I tell what port number mysql is running on? I need it for a chat
On Wed, Dec 04, 2002 at 12:21:06PM -0500, Jason Hall wrote:
I have a problem here.
I cannot connect to a particular server remotely at certain times.
I get the error remote connection is blocked because of many
connection errors. I can login locally on the box.
Ok.
To resolve this
I have used Access to MySQL pro and it worked for a few of my databases.
http://www.convert-in.com/acc2sqlp.htm
Chris
-Original Message-
From: Sandeep Murphy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 8:39 AM
To: MySQL List
Subject: access-mysql
Hi,
Can anyone
Michael,
I was able to repeat the bug on Linux now.
It seems to happen if I set max_binlog_size to 2M in the SLAVE. The relay
binlog gets split into several 2 MB pieces. It does not happen always, but I
have a randomized test which produces the error in 1 minute.
I was not able to repeat the
The problem shows up when receiving the response of the query which
tells me that the query was OK but rows affected.
Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina
-Mensaje original-
De: Egor Egorov [mailto:[EMAIL PROTECTED]]
I can concur - you pay a little, but you get a much better product with this one.
Ian Zabel wrote:
The only one I found that creates a good schema that only needs minimal
massages, and imports all the data correctly is Access-To-MySQL. It's
not free though, but they have a trial. Once I went
On Sat, 2002-11-30 at 13:42, Pae Choi wrote:
I do not know about MySQL marketing strategies. But as far as
GPL goes, it even encourge to sell.
Does the GPL allow me to sell copies of the program for money?
Yes, the GPL allows everyone to do this. The [1]right to sell copies is part
of the
On Sat, 2002-11-30 at 10:51, Mark wrote:
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
To: Pae Choi [EMAIL PROTECTED]
Cc: Tonu Samuel [EMAIL PROTECTED]; Darney Lampert
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, November 30, 2002 5:30 AM
Subject: Re: LEGAL
On Mon, 2002-12-02 at 14:45, Darney Lampert wrote:
Sorry continue this subject ... I´m the author original question, LEGAL
information about MySQL.
But I Think that my question is simple and the other answers do not make
sense to me.
I never said that I change original MySQL source code,
Hello,
I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM
Indices.
I would like to set replication (one master and one slave).
My question is:
When I OPTIMIZE TABLE table1, ... on the master will the slave be updated
or if I want to optimize the same tables on the slave I
Look!
I already unsubscribed this. Do you understand what that mean?
I have no interest to dealing with MySQL and have no time for
this.
You must understand that this thread was started from someone
who were interested to sell his/her product that utilize MySQL. And
I was trying to help both
On Thu, 2002-12-05 at 14:42, Beauford.2003 wrote:
Adolfo,
Thanks for the info, but can you elaborate on it, 'cause basically I am just
not getting the concept. No way no how can I get these joins to work.
mysql describe songs; (this contains an ID field and the title of the song
and the
I'm looking for something that will take mySQL databases and show me
graphically how the tables all relate to each other. At the very least,
show me boxes with the schema in each one and allow me to draw lines as
I see fit (or use the foreign keys of InnoDB tables). This could then be
printed to
Hallo.
I have this query:
SELECT table1.id
FROM table1
LEFT JOIN table2 USING(id)
WHERE table1.a=1 and table2.b=1
table1 is MyISAM and table2 is InnoDB.
I want a shared mode lock on the table2. Is it possible, or i should
split this query?
--
Have a nice day.
On Wed, Dec 04, 2002 at 05:18:26PM -0500, Adam Nelson wrote:
Don't let this list fool you. SQL Server is a very good product.
It is far superior to Mysql in every way except cost and the fact
that it doesn't run on unix.
This smells a lot like flaim bait on a MySQL list...
Jeremy
--
Jeremy
John,
Am I mistaken or does 2002-02-31 translate into February 31, 2002? If it
does ...
Your observation is interesting.
The MySQL manual says the query should set all zeroes if the date value is
illegal. This does happen if you enter 32 days for a month, for example.
Furthermore, I got two
From: DELETED TO PROTECT THE GUILTY
[Four original lines and SEVERAL HUNDRED quoted lines deleted]
PLEASE folk, trim up your quotes a bit!
Nothing spells newbie so much as mindlessly including everything anyone has ever
written on a topic. And when two of you go at it with each other, it's
Sorry,
should be the lpad function:
http://www.mysql.com/doc/en/String_functions.html
LPAD(str,len,padstr)
Returns the string str, left-padded with the string padstr until str is
len characters long. If str is longer than len' then it will be
shortened to len characters.
mysql SELECT
What you want is the rpad function:
http://www.mysql.com/doc/en/String_functions.html
RPAD(str,len,padstr)
Returns the string str, right-padded with the string padstr until str is
len characters long. If str is longer than len' then it will be
shortened to len characters.
mysql SELECT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 4 Dec 2002, R. Hannes Niedner wrote:
On 12/4/02 9:04 AM, Mike At Spy [EMAIL PROTECTED] wrote:
How can I tell what port number mysql is running on? I need it for a chat
program. :)
Default is 3306
And with -P=123 or --port=123
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 4 Dec 2002, Philip Molter wrote:
Compiling on Solaris 8 x86
- mysql 3.23.53
- gcc version 2.95.2 19991024 (release)
CC=gcc CFLAGS=-O3 -fno-omit-frame-pointer CXX=gcc CXXFLAGS=-O3
-fno-omit-frame-pointer -felide-constructors
No. It is not what I want.
This is a normal aggregation.
The sum function will be called once for each
group (SalespersonNm) and it will return one row.
What I have asked is : if I have 10 rows, can I return 12?
It's rude, but that's the idea.
Thanks,
Felix
DL Neil wrote:
Felix,
Is is it
The idea is simple:
I want to implement some temporal computation
on timeseries like normalization and interpolation
to smooth the data and fill the missing values.
So, for example if have a table like that:
starttime,endtime,counter
12:00,12:30,34
13:00,14:00,25
you see that for 12:00 the
i read in several places (like in recent osnews.com newspiece and some
other prior postings to this list) that mysql 4.0.x is supposed to be
stable now. but the front page of mysql.com still lists 4.0.5 under
development.
so does the mysql developers suggest that mysql is still unstable or
On Wednesday 04 December 2002 22:35, Stefan Hinz, iConnect \(Berlin\) wrote:
Hello Stefan,
The communication buffer (between client and server) is set to 1 MByte by
default. You can change this either by starting the server with a different
option or by setting the appropriate variable in the
Its more to do with the amount of memmory than its speed.
As MySQL will try and load as much data (tables) into memmory as posible the
more the better. The next thing is disc speed.
Simon
-Original Message-
From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]]
Sent: 04 December 2002
Hi
Just try this
select distinct(a.id) from test a , test b where a.code = 23 and b.code = 45
and a.id = b.id
Regards,
-Arul
- Original Message -
From: Robert Gehrig [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 10:52 PM
Subject: Select Problem
-Original Message-
From: David Axmark [mailto:[EMAIL PROTECTED]]
In this case there is not distribution so no fee is needed. We would
like to be paid in this case also but there is legal requirement for a
license if you do not distribute.
Missing 'no'?
- rick cronan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ledet, Mike wrote:
| I'm running Mysql 3.23.52 on a Redhat 8.0 installation booting to Gnome.
| The machine is a dual AMD 1800, 1 gig of ram, one Ultra ATA IDE drive, and 2
| 18 gig scsi 10,000 RPM drives on a RAID controller running Raid 0.
|
| I've
Thanks for advice,
--- Adam Nelson [EMAIL PROTECTED] wrote:
I've posted my comments before but the important
thing is that P4 is
largely unnecessary as it doesn't have instructions
that apply to server
applications (mostly).
thats mainly what I was asking for. I'll go with pIII
than.
So,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 5 Dec 2002, Andrew Sitnikov wrote:
after FLUSH QUERY CACHE
key_buffer_size=402649088
read_buffer_size=2093056
sort_buffer_size=2097144
max_used_connections=115
max_connections=200
threads_connected=6
It is possible that mysqld
Cesar,
Wednesday, December 04, 2002, 2:31:13 AM, you wrote:
CA I'm using MyCC to make changes to a remote DB, but I found a problem
CA while trying to update a record... does anyone knows what's wrong with
CA this?
CA UPDATE maraadmins SET adminpassword = password(1234) WHERE adminid = 3
The
Hello list. I'm new here. I programmed dBase several lifetimes ago and now
fumble with Access when I have to. I've just purchased a license to a
vBulletin message board, which employs PHP and MySQL, so it's time I FINALLY
get around to learning these two.
I am at my first hurdle. I uploaded
Neal:
What you are really asking is: Does MySQL support stored procedures?
The answer is ... at this point ... no. Implementation of stored procedures
is on the 'to-do' list, but it will be awhile before you see it.
There are some work-arounds ... do a search of the archive for this list, or
Hi Michael,
The ten last dates appear as a default result of a Archives page. When I
enter for the first time in the page, it give me the last ten Files that was
uploaded. In the same page, I can ORDER BY the ten last dates results by
COD, DATE, NAME or FILE. So, when I click in some os then,
On Wed, 4 Dec 2002, Heikki Tuuri wrote:
what MySQL version you are running? On what OS?
Version 3.23.53-max-nt-log on Windows Professional 2000
What does SHOW CREATE TABLE tabdocumentoconsultado; print?
I created again all the tables of the database called bdatena.
Now that the table is no
Neal,
I need to build a cache mechanism for a website and I thought I'd use
MySQL
for persistance. The problem is that I need it to schedule a cleanup task
every 24 hours - to remove old cache records. MS SQL Server provides a
trigger for scheduling such tasks - I am looking for the
- Original Message -
From: David Axmark [EMAIL PROTECTED]
To: Darney Lampert [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 3:55 AM
Subject: Re: [OT] LEGAL information about MySQL.
I am the licensing guru for MySQL AB and one of the
founders.
With
DBTools works great on this matter. You find it at
http://www.dbtools.com.br/EN and is totally free.
[]s
Crercio
- Original Message -
From: Sandeep Murphy [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 12:39 PM
Subject: access-mysql
Hi,
Can
Datanamic is a very useful tool.
http://www.datanamic.com
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 8:58 PM
To: [EMAIL PROTECTED]
Subject: Graphical data visualization for RDBMS/SQL schema?
I'm looking for something that will
On Wed, 2002-12-04 at 22:32, Richardson, David E (MVC Corporation)
wrote:
On a single Linux box w/mysql 3.23.52 I have mysqld running and there are
about 20 databases live in the environment. I want to take one of the
databases offline but leave mysqld running with the other db's - without
thnx to all!
am checking this links out.. looks great! :)
-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: quinta-feira, 5 de Dezembro de 2002 12:30
To: MySQL List
Subject: Re: access-mysql
DBTools works great on this matter. You find it at
Hello!
I want to copy one table's structure to another (non existing) table, but i
didn't find any command or example to do that. Exactly, the situation is the
following:
A dynamic database structure has tables. We want to copy any of tha tables
(while we don't know that table's structure) to
I recently installed the following RPM's:
MySQL-3.23.41-1a.s390.rpm
MySQL-devel-3.23.41-1a.s390.rpm
MySQLclient9-3.23-22-6a.s390.rpm
MySQL-server-3.23.41-1a.s390.rpm
Afterwards, I was able to start the mysqld daemon ok and install an application I
downloaded for a demonstration of the
Hi,
I get this error/warning each time server reaches 623 connections and thus
no new clients can connect. What may I do to allow more clients?
I know that the limit on the size of `alarm_queue' is set in
mysys/thr_alarm.c, but is increasing the value in call of init_thr_alarm()
safe?
Regards,
Hi all and thx in advance for trying to fix my problem.
I'm instaling for the first time MySQL and when I try to test the program, I
receive an error like Cannot connect to localhost (100060)...How can I
configure the MySQL.
Thx again
Alex
Hi,
can anybody tell me how can i select,update, delete the records from two
table having same structure in the mysql.
For ex
MainTable
---
id(int)|val (varchar)
---
1 a
2 b
3 c
select req_number,
right(concat('00',trim(req_number)),6) as sort_req,
case
from req
order by sort_req;
Haven't tried it but it should work.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Norris, Joseph [mailto:[EMAIL
Cesar,
Thursday, December 05, 2002, 2:50:30 AM, you wrote:
CA The problem shows up when receiving the response of the query which
CA tells me that the query was OK but rows affected.
How many row were affected? 0? Was the password changed?
--
For technical support contracts, goto
Mariella,
Thursday, December 05, 2002, 4:15:52 AM, you wrote:
MDG I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM
MDG Indices.
MDG I would like to set replication (one master and one slave).
MDG My question is:
MDG When I OPTIMIZE TABLE table1, ... on the master will the
Richardson,
Thursday, December 05, 2002, 12:32:27 AM, you wrote:
RDE On a single Linux box w/mysql 3.23.52 I have mysqld running and there are
RDE about 20 databases live in the environment. I want to take one of the
RDE databases offline but leave mysqld running with the other db's - without
RDE
I am running a few AMD based servers in our offices here and have no
issues with them. The big question is, What kind of operations are you
most likely to see with your servers?
If the servers will be doing some heavy floating point operations stay
away from the Intel P4.
Hello
I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an
error when run mysqldump in order to backup my dbs. The error is following:
/usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server
during query
when retrieving data from server
I ran mysqldump
I saw some discussion on this topic last night, and forgot to put in my .02:
Whomever said that memory and hard disk hardware should be the focal point
in a new mySQL DB server, and not processors, I very much disagree with.
While I agree that ample and fast memory, in addition to an efficient,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kenneth,
I would download the source packages from php.net and explicitly
compile the mysql options into PHP. As an alternative, you can look
for the mysql-php library rpms on rpmfind.net. My linux webserver
(running apache and PHP 4.1.2) has
On 5 Dec 2002, at 14:44, Ol h Barnab s wrote:
SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null
and the SQL server creates a [temptablename] table with no records (or we
hope that ;) )
But we can't do this on MySQL server, 'cause MySQL isn't know the
SELECT...INTO
Hi,
I tried to compile mysql-3.23.49 on HPUX 11.11 system.
When I run:
CC=cc CXX=aCC CFLAGS=+DD64 CXXFLAGS=+DD64 ./configure
Everything is fine, no errors.
But when I run: make
I got:
cc: password.c, line 95: error 1000: Unexpected
symbol: char_val.
cc: panic 2017: Cannot recover from
Hi,
is there a possibility to query a column with a FULLTEXT-INDEX for a word fragment?
I mean if there's the word skyscraper in a column I want to find it looking for
sky and also looking for crap.
It seems to me it does not work with something like:
match(column) against(*crap*)
Regards
Alejandro,
Thursday, December 05, 2002, 4:03:23 PM, you wrote:
ACG Hi all and thx in advance for trying to fix my problem.
ACG I'm instaling for the first time MySQL and when I try to test the program, I
ACG receive an error like Cannot connect to localhost (100060)...How can I
ACG configure the
Daya,
Thursday, December 05, 2002, 4:14:02 PM, you wrote:
DKD can anybody tell me how can i select,update, delete the records from two
DKD table having same structure in the mysql.
DKD For ex
DKD MainTable
DKD ---
DKD id(int)|val (varchar)
DKD ---
DKD
Oláh,
Thursday, December 05, 2002, 2:44:24 PM, you wrote:
OB I want to copy one table's structure to another (non existing) table, but i
OB didn't find any command or example to do that. Exactly, the situation is the
OB following:
OB A dynamic database structure has tables. We want to copy any of
Mysql, sql,query
--- [EMAIL PROTECTED] wrote: Your message
cannot be posted because it appears to
be either spam or
simply off topic to our filter. To bypass the filter
you must include
one of the following words in your message:
sql,query
If you just reply to this message, and
* Daya Krishan Dubey
can anybody tell me how can i select,update, delete the records from two
table having same structure in the mysql.
select, update and delete are three different operations. From your
example data, it looks like you want to do select.
For ex
MainTable
* Michelle de Beer
I believe this question is solved by a join, but I
haven't really got a hang of it.
My table:
--
| uid | rootid | parentid | name |
--
| 1 | 0 | 0| name1|
| 2 | 1 | 1
- Original Message -
From: Michelle de Beer [EMAIL PROTECTED]
I believe this question is solved by a join, but I
haven't really got a hang of it.
My table:
--
| uid | rootid | parentid | name |
--
| 1 |
Hi:
You might find these articles from O'Reilly Network will help clear the
water.
http://www.onlamp.com/pub/ct/19
Doug
On Thu, 5 Dec 2002 07:46:03 -0800 (PST), Michelle de Beer wrote:
I believe this question is solved by a join, but I
haven't really got a hang of it.
My table:
On Wed, Dec 04, 2002 at 04:32:35PM -0500, Michael T. Babcock wrote:
information from a to b. Any ideas for a one-shot SQL command to do this?
I'm about to try selecting everything from b and the CommID from a as a
join into a temporary table, then REPLACE it back into b.
In case anyone
I believe this question is solved by a join, but I
haven't really got a hang of it.
My table:
--
| uid | rootid | parentid | name |
--
| 1 | 0 | 0| name1|
| 2 | 1 | 1| name2|
| 3 |
On Wed, Dec 04, 2002 at 05:06:54PM -0500, Ledet, Mike wrote:
I tried your TOP suggestion but didn't see anything out of the ordinary.
Swap size was constant (6400 or so) and didn't increase or decrease under
load.
Familiarize yourself with vmstat if you aren't already and then run
`vmstat 1`
Thanks - this is even better - I will give it a try.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 6:19 AM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: RE: WoW SQL is something!
select req_number,
Vinay,
Wednesday, December 04, 2002, 3:05:03 PM, you wrote:
VM I m developing a web based application using Tomcat, Struts, JSP, mysql.
VM I m using mysql 3.23.39-max-nt and mysql-connector-java-2.0.14 to access
VM mysql through java 1.3.1.
VM But sometimes the select query on 1 particular
Michal,
Tuesday, December 03, 2002, 7:19:08 PM, you wrote:
MF Its possible to use index on this query ??
MF select ..
MF from ..
MF where timestamp_col2002110100 and timestamp_col2001110100
MF I have index on timestamp column, but EXPLAIN says that not using any of
MF possible
Michelle,
Thursday, December 05, 2002, 5:46:03 PM, you wrote:
MdB I believe this question is solved by a join, but I
MdB haven't really got a hang of it.
MdB My table:
MdB --
MdB | uid | rootid | parentid | name |
MdB --
another trick that might work is just to deny access to everyone to the
database. if no one has access to it, then its as good as gone.
i don't know if MySQL would allow just
grant blah on *.* to user;
revoke all on disabled_db.* from user;
and alot of it depends on how the security is setup
Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£
ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ
ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǵĿռä
I am using BSDI 4.3, and downloaded MySql source code
3.23.53.
After untarring it, it passed ./configure
--prefix=/usr/local/mysql. But when I run make,
finally it says
make: don't know how to make mi_test_all. Stop
*** Error code 1
Your help will be appreciated
Shawn Xu
hi
MySQL 3.23.52
could not make my way throuh the JOIN statement.
i would like to accomplish something like what EXCEPT
does in other databases, with a full SQL-statement
after the EXCEPT.
xxxIDref is a foreign key.
first i have a table with users
ID Name
1 John Doe
2 Jane Doe
3 Me Myself
Hola,
Tenia instalado MySQL 3.23.53 en mi pc. He reinstalado todo el sistema y lo
he vuelto a instalar, pero no consigo arrancar el servidor sql. La
instalación la he hecho según indica el manual y tal como la habia hecho en
la otra ocasión.
Cuando quiero arrancar el servidor (/bin/safe_mysqld
Colin,
According to the docs this function wants a string and when I use the field
name it says unknown column.
Thanks anyway.
-Original Message-
From: Colin Kettenacker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 5:32 PM
To: Mysql_List (E-mail)
Subject: Re: WoW SQL
Evgeny,
- Original Message -
From: Evgeny Chuykov [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, December 05, 2002 12:28 PM
Subject: InnoDB shared lock with JOINs
Hallo.
I have this query:
SELECT table1.id
FROM table1
LEFT JOIN table2
I'm attempting to import 36 files of varying size from about 500kb to 80mb.
I've found that using the local infile import query on files that are
several mb in size takes up to a min per mb and much longer if it get's over
100mb. The system we're using has 500mb RAM and a 1600mHz processor. Is
Hola de nuevo, he mirado el log de mysqld, y pone lo siguiente:
bind on unix socket : permission denied
Donde reside el problema?
Gracias
___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis!
Descárgalo ya desde
Dear Carlos,
Got error: 2013: Lost connection to MySQL server
during query
when retrieving data from server
In your my.cnf / my.ini configuration file, set the value for the
communication buffer high (maximum is 16 MB):
[mysqldump]
set-variable = max_allowed_packet=16M
Restart the server,
Dear Olh,
SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is
null
In MySQL, you simply do:
CREATE TABLE temptable SELECT * FROM sourcetable LIMIT 0
That's even simpler, 100% reliable and FAST! :)
HTH!
--
Stefan Hinz [EMAIL PROTECTED]
Geschftsfhrer / CEO iConnect GmbH
I am forwarding Shawn's real question to the list, since I haven't got a clue :)
-Original Message-
From: shawn xu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 12:42 PM
To: Luc Foisy
Subject: RE: I can not post to this list after I have joined
Hi, Luc Foisy:
Oops. I should have been paying more attention to the lost connection
thread. What does the Lost connection to MySQL server during query error
message mean and where can I find more information about it?
I just installed the DBTools on a XP box. When I try to connect to by Linux
box, it gives me
yes...
it seems that you do not have mysql in the PHP module.
you can use --with-mysql in the php configure, but you should use
--with-mysql=/your/mysql/directory
PHP has included code for the default mysql build. try to use your own libs
and headers.
HTH
brian
sql, query, mysql
On
On Thu, Dec 05, 2002 at 09:41:24AM -0200, Felipe Moreno - MAILING LISTS wrote:
The ten last dates appear as a default result of a Archives page. When I
enter for the first time in the page, it give me the last ten Files that was
uploaded. In the same page, I can ORDER BY the ten last dates
hi
MySQL 3.23.52
could not make my way throuh the JOIN statement.
i would like to accomplish something like what EXCEPT
does in other databases, with a full SQL-statement
after the EXCEPT.
xxxIDref is a foreign key.
first i have a table with users
ID Name
1 John Doe
2 Jane Doe
3 Me Myself
Try use commit before use this statement...
5/12/2002 14:29:17, lpkvb [EMAIL PROTECTED] wrote:
Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£
ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ
thanks for your answer. Now the problem is worst. When I do a sql request
with mysql client and the number of register is a litte big, for example 50,
the error appears again:
mysql --debug -eselect * from table /tmp/lista.log
ERROR 2013 at line 1: Lost connection to MySQL server during query
I
I'm wondering if it's possible to specify multiple hosts for a user when
setting up permissions, but without using wildcards.
For example.. if I have these two GRANT statements:
GRANT SELECT on database.* to [EMAIL PROTECTED] identified by 'passwd';
GRANT SELECT on database.* to [EMAIL
Hi
We are having some problems with high load on our Internet line in the
MySQL office in Uppsala. And we might need to temporary ( about 12-24
hours) turn off the MySQL mailing lists.
If our current workaround will work we can stay up.
We should get a upgrade of our Internet line equipment
1 - 100 of 165 matches
Mail list logo
