Fionn Behrens wrote:
On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote:
You can have both, AFAIK. The general query log keeps all queries,
including SELECTs. Binlog only has data-modifying queries.
Thanks very much for your answer.
Maybe the fact that binlogs apparently are quite different
On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote:
> You can have both, AFAIK. The general query log keeps all queries,
> including SELECTs. Binlog only has data-modifying queries.
Thanks very much for your answer.
Maybe the fact that binlogs apparently are quite different from normal
text lo
Fionn Behrens wrote:
We recently switched to mysql5 and while we were at it we also changed
our logs from text to bin as suggested by the migration script we had
(probably created by debian people).
Now I unfortunately had to reconstruct what had happened during a faulty
run of our application a
I am not able to install Mysql on my 2003 server at home.
error 1045!!
I get an accesd denied for user [EMAIL PROTECTED]
I need the full error, but have some questions:
1. Are you sure that you set a root password?
2. Are you using the command line client or some other administrative tool?
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
If you feel that there are too much sockets in a TIME_WAIT have a look here:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
Logg, Connie A. wrote:
> Two days ago, a system that has been running f
No I don't think this indicates orphaned sockets, having many sockets for
mysql in the state TIME_WAIT state is quite normal, as a socket has to be
created for every connection and once a connection is established the socket
goes into a TIME_WAIT state( i am not sure for how long though), the 'show
Hello.
4.0.17 is old enough. You may switch to the debug version and attempt to
find the clues in debug or trace files. Can you reproduce an error on the
latest release (4.1.9 now)? Do you lost connection to the server with
other statements, than 'SHOW DATABASES'? Please answer on this questi
d my mysql user have access to write into my errorlog file
and in my directories.
David
David Marois
-Message d'origine-
De : Michael Dykman [mailto:[EMAIL PROTECTED]
Envoyé : 3 février, 2005 10:02
À : Marois, David
Cc : "MySQL List"
Objet : Re: help please : ERROR 2006: MySQL
max_allowed_packet - one has client, another has server.
> Run mysql with --max_allowed_packet=16M and mysqld with the same value.
> May be you have some ulimits which cause such behaviour?
>
>
> -----Message d'origine-
> De : Marois, David
> Envoyà : 2 fÃvrier, 2005
Hello.
Does the problem remain? What is in the error log? Please, send
us information about MySQL and operating system versions. There are
two variables: max_allowed_packet - one has client, another has server.
Run mysql with --max_allowed_packet=16M and mysqld with the same value.
May be yo
sage-
>> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
>
>> Sent: woensdag 2 februari 2005 12:46
>> To: [EMAIL PROTECTED]
>> Subject: Re: help please : ERROR 2006: MySQL server has gone away
>>
>> Hello.
>>
>> What's the value of the inter
L PROTECTED]
>
>> Sent: woensdag 2 februari 2005 12:46
>> To: [EMAIL PROTECTED]
>> Subject: Re: help please : ERROR 2006: MySQL server has gone away
>>
>> Hello.
>>
>> What's the value of the interactive_timeout system variable? See:
Hello.
I've asked you about interactive_timeout, not wait_timeout.
Mark <[EMAIL PROTECTED]> wrote:
>> -Original Message-
>> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
>> Sent: woensdag 2 februari 2005 12:46
>> To: mysql@lists.mysql.com
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: woensdag 2 februari 2005 12:46
> To: mysql@lists.mysql.com
> Subject: Re: help please : ERROR 2006: MySQL server has gone away
>
> Hello.
>
> What's the value of the interact
Hello.
What's the value of the interactive_timeout system variable? See:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
http://dev.mysql.com/doc/mysql/en/gone-away.html
"Marois, David" <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: iso-8859-1, 19
Hello.
You can enable logging on the server. See:
http://dev.mysql.com/doc/mysql/en/log-files.html
You need the error log, query log, slow log. But be careful!
Heavy loaded server can produce a lot of messages and your
files will grow quickly. If you use InnoDB, you can enable
the InnoD
Thanks Martin,
No I do not have that option unfortunately. I really do suspect that it has
nothing to do with mysql and that rather it is the router/IPs configuration
and called them upon this, but they said all is fine. So I frankly have no
clue where to go from here.
thanks again for any sug
Are you sure the mysql service is running? You can either check in the
control panel, but an easier is way is to launch
WinMySQLadmin, which should come with your distribution. Check in the
bin directory for the following file winmysqladmin.exe. Launching this
program will start the service aut
PM
To: Dan Williamson
Cc: [EMAIL PROTECTED]
Subject: Re: Help Please - Cannot query server remotely
Sounds like you just got here? The updated version of glibc is causing a
conflict. You can either go back to the old version or wait for the fix
from RedHat. Info on this is on bugzilla.redhat.com.
From: "borracho 138" <[EMAIL PROTECTED]>
> Many thanks for the reply - nice to know that I'm not the only one with
this
> issue(!)
> Seems like my problem is related to 2 areas:
> - I'm concerned about the lack of memory 'freeing' with the system, but a
> kernel upgrade may fix that
Don't have t
From: "borracho 138" <[EMAIL PROTECTED]>
> I've searched for more information on these issues, without luck.
>
> The system randomly spirals out of control - load avg increases very
> rapidly, resulting in loads of 200-300 in 2/3 minutes. At other times the
> server is fine, handling the busiest
PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 12, 2002 4:16 PM
Subject: Re: help please, patter matching problem
> No closing quotes in prepare.
>
> Also, I've never seen code that's looks quite like that; this may be
> cleaner:
>
> $sth=$dbh->pre
No closing quotes in prepare.
Also, I've never seen code that's looks quite like that; this may be
cleaner:
$sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name=%$sname%");
$sth->execute();
- Original Message -
From: "Dan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturda
* Dan
> Can someone tell me what's wrong with this code:
>
> $sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name=?);
>
> $sth->execute("%$sname%");
You should use the LIKE operator:
Name LIKE "%roger%"
http://www.mysql.com/doc/S/t/String_comparison_functions.html >
--
Roger
--
On Sunday 02 December 2001 01:12 pm, Ian Moss wrote:
> I'm trying to run mysql 3.23 on suse linux.
Ian:
We need some more info to be able to help you.
What SuSE version?
Please also post a full report about your system with mysqlbug...
--
MySQL Development Team
For technical support contract
Aha, much appreciated...your words "therefore the target table may not
appear in the SELECT clause" have made it clear to me...but can I assume
that if I was to use aliases, then I would be able to sneak past this
problem? :)
John :^)
Benjamin Pflugmann wrote:
> Hi.
>
> As is described so
Hi.
On Tue, Oct 02, 2001 at 03:53:12PM +1000, [EMAIL PROTECTED] wrote:
> Aha, much appreciated...your words "therefore the target table may not
> appear in the SELECT clause" have made it clear to me...but can I assume
> that if I was to use aliases, then I would be able to sneak past this
> prob
Hi.
As is described somewhere (http://www.mysql.com/doc/R/E/REPLACE.html),
REPLACE mainly behaves like INSERT and therefore the target table may
not appear in the SELECT clause (as described here:
http://www.mysql.com/doc/I/N/INSERT_SELECT.html).
Sorry, but it seems you have to use a temporary t
Hi,
When I try and use the REPLACE function such as:
REPLACE INTO table1 SELECT table2.ID, table2.Modified FROM table1 INNER JOIN table2 ON
table1.Company=table2.Company;
I get:
ERROR 1066: Not unique table/alias: 'table1'
Here is the description of both tables:
mysql> describe table1;
+---
I am struggling with this myself right now. I posted a similar question to
this group earlier in the day and it must be a poser because no one has
responded.
I fear that the only way to do this with a single sql statement is using the
replace command:
Let's say you have 2 tables like this:
Main
Dear Santosh,
if you change the grant table entries (e. g. in mysql.user) manually,
you will have to execute
FLUSH PRIVILEGES
from the MySQL command line in order to tell the server to reload the
grant tables.
Granting privileges is better with the GRANT command, which will
automatically m
try to download and install updated JDBC driver matching with your MySQL
version and JDBC/JDK versions.
- Original Message -
From: "santosh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 4:07 PM
Subject: help please
> Hai all,
>
> I am using MySQL version
Date |Tue, 31 Jul 2001 11:59:29 -0500
>From |"Chuck Barnett" <[EMAIL PROTECTED]>
Hello!
CB> Hello, I am getting this error in the .err file
CB> 010731 9:48:22 Can't start server: Bind on TCP/IP port: Address already in
CB> use
CB> 010731 9:48:22 Do you already have another mysqld server runn
/usr/libexec/ld.so loads the dynamic libraries, It goes down a path set by
LD_LIBRARY_PATH,
get the location where the libary is in and put it in the path, should be
that simply. find / -name "libpthread.so.14*" -print , might help. BTW that
was a solaris answer but should be the same on openbsd
CREATE TABLE namelist (
name CHAR(60),
id SMALLINT AUTO_INCREMENT)
You will find much useful information at http://www.mysql.com - check
the documentation section. I also use the O'Reilly book "MySQL and
mSQL" by Yarger, Reese and King, which has detailed in
I think you are looking for something like:
create table namelist (ID int not null auto_increment, name char(60), ...);
?!?
Cheers, Nessi
>At 15:21 04/07/01 , you wrote:
>>I move from MDB to mySQL, I got a question concern how to create a auto
>>digital number field in mysql table,
>>
>>crea
You meaaan, auto incrementing field ???
If so
CREATE TABLE t_name (id INT AUTO_INCREMENT);
Workds.
But there's no "auto digital number" thingy
Sent on Jul 4 by Web Mailing List to [EMAIL PROTECTED]
websig> I move from MDB to mySQL, I got a question concern how to create a auto
digit
day, June 09, 2001 12:29 AM
Subject: Re: Help Please!
> Rohit Peyyeti wrote:
>
> >This is what it says now when I run mysqld_multi start 2:
> >
> >perl: warning: Setting locale failed.
> >perl: warning: Please check that your locale settings:
> >LANGUAGE =
/english
Thanks!
Rohit Peyyeti
- Original Message -
From: Paul DuBois <[EMAIL PROTECTED]>
To: Rohit Peyyeti <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 8:47 PM
Subject: Re: help please
> At 7:19 PM +0530 6/1/01, Rohit Peyyeti wrote:
> &g
At 7:19 PM +0530 6/1/01, Rohit Peyyeti wrote:
>hello all:
>
>how can i run multiple instances of mysql server? i also looked
>at mysqld_multi but i guess there is a problem with that too.
>here is the error what it gave:
>
>ABORT: Bad GNR: mysql2 See mysqld_multi --help
>
>i also defined GNR in /e
>I just want to create a webbased mailing tool using
>PHP/Mysql...I've done using the fuction mail()...But if i need to have a
>option 'Attachment' then in which way i can do that.
This_is_a_PHP_question.. have a look at the manual at www.php.net also,
checkout www.phpbuilder.com www.devshed.co
e for percent.
I want can do this calculation in one line. :) Currently I use two SELECT
statements, the first to get the total, then use that value to calculate for
the percent.
jerome
From: "Rus" <[EMAIL PROTECTED]>
To: "jerome auza" <[EMAIL PROTECTED]>, <[EM
Did you try
select count(*), sum(amount) from table1;
you also can use
... count(if(field=value,1,NULL)) ...
- Original Message -
From: jerome auza <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 2:49 AM
Subject: Help please: getting the total from the resu
Won't a "Drop TABLE" work?
Brady...
Original Message Follows
From: "Crystal D. Silver" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: help please?
Date: Tue, 13 Feb 2001 14:01:48 -0800
Hi,
My host gives me a MySQL database, and I've had no trouble
DELETE FROM tableName;
Jiang
- Original Message -
From: "Crystal D. Silver" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 3:01 PM
Subject: help please?
> Hi,
>
> My host gives me a MySQL database, and I've had no trouble getting
purchased
> cgi scripts to
drop table...
On Tue, 13 Feb 2001, Crystal D. Silver wrote:
> Date: Tue, 13 Feb 2001 14:01:48 -0800
> From: Crystal D. Silver <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: help please?
>
> Hi,
>
> My host gives me a MySQL database, and I've had no trouble getting purchased
> cgi scri
On Tue, 13 Feb 2001, Crystal D. Silver wrote:
> in the documentation about how to just plain DELETE everything in the
> database (i don't want to delete the installed database itself, just go back
> down to where there's nothing in it, so I can start over)...could somebody
> tell me what to do?
Go to the MySQL Contributed page and go from there to get the Zeos MySQL
components. (They may be under Borland Delphi, but they come with components
for C Builder 4 and 5)
Either that, or you can just use the standard TDataSet components and use
MyODBC to create the data source.
- Original
Before you do, check out the Delphi components on the mySql home page.
I'm sure your aware that you can use Delphi components in BCB.
Sean
>From: "Justin C. Darby" <[EMAIL PROTECTED]>
>To: "Alain Morlans" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]&g
At 15:48 10/01/2001 +, Alain Morlans wrote:
Hi!
>Hi!
>
>I would like to coonect top mysql using Borland C++ builder on a windows
>plataform.
>
>Do you know what is the best way to do it?
There are several way to do it. The best, you decide according
with your preference:
- You can use the
50 matches
Mail list logo