I think you need to give us the SQL you are using to do the search - we'll
ba ble to see what your are trying to do better
Alan
-Original Message-
From: µÑ ¶Ì [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 15:37
To: [EMAIL PROTECTED]
Subject: a mysql question
I'm a
At the slave server of replication there are log files like
environment hostname-relay-bin.xxx.
For what these logs and how can I know which one I can delete safely?
p.s. sql, query : used to bypass spam filter. :(
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
Pada Thu, 17 Oct 2002 13:36:58 +0800 (CST)
µÑ ¶Ì [EMAIL PROTECTED] menulis:
I'm a chinese software engineer, and I has use mysql
for three years ago.Now,I get a matter from it.
recently,I'm deal big data use mysql first.every
table's data is one million,so user search the data
will use long
Thanks Joseph and Kelly. I think merge tables will be a good solution
for me.
Veysel Harun Sahin wrote:
Hello,
I have a problem with select statetement. I need to query and select
records from multiple tables which have the same column types. I have
done this with left join but my query
HI
I posted this question on PHP list as well.
I would like to be able to log all mysql queries made from php scripts.
I have had a couple of strange mysql lockups on my RedHat server, where
mysqld process won't even be killed, and since no user works with mysql
except through PHP, the normal
I set up two-way replication with two servers, A and B.
Since all queries go to only one server, it seems not to matter.
Anyway.
When A starts it registers itself to B, and vice versa.
I thought query SHOW SLAVE HOSTS to A should shows only about
B and B should do about A, but both show the
Use --log option when starting mysqld_safe(or safe_mysqld)
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
NeoWiz http://www.neowiz.com
-Original Message-
From: Petre Agenbag [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 17, 2002 4:05 PM
To:
I want to install mylua (stored procedures for mysql). I installed lua like
the instructions said. Then I do a configure:
./configure --enable-assembler --prefix=/usr/local/mysql --enable-assembler
--with-mysqld-ldflags=-L/usr/src/lua/lib -llua -llualib
When I try to do a make, I get the
Hi
Thanks for the prompt reply.
Can you please tell me where the logfile will be located if I start it
with the --log option? Will syslogd take over the function of the
logging, ie, do the log rotation etc. and if possible, could you give me
an example of how the log would look?
Sorry for asking
With --log[=filename] option to mysqld_safe, you can specify the path
and name of log file.
You may put the line like this to my.cnf file
log = filename
If absoulte path is not given, the path is considered one relative to
$data
directory, in my case /usr/local/mysql/var
and filename is
I have test install MySQL ver.4.0.x on RedHat Linux 7.2.
When I test query using MySQL Front(Under Windows) Select now() it's displayed:
'10/17/2002 3:10:20' PM, but when I test using telnet under command line
it's shown '2002-10-17 3:10:34'. In the client I'm using mysql.dll ver
3.23.52.
Any
I wonder if anyone knows when 3.23.53a will be released? I don't need an
exact time, just if it's due today, tomorrow or next week.
Regards
/Lars
-anti-spam-workaround sql query
-
Before posting, please check:
Hello Steeve,
Tuesday, October 15, 2002, 9:57:04 PM, you wrote:
SG We want to write a log of EVERY transaction made by the customer in a MySQL
SG database. Writing has to be very fast because customers are waiting for their
SG results. We want to add code using MySQL C API to the already
jfield,
Thursday, October 10, 2002, 1:33:10 AM, you wrote:
jazdc Description:
jazdc After adding a key to a nullable column, null values will
jazdc successfully join through to null values in other tables.
jazdc This only seems to happen when the index is added after
jazdc the row contains null
Hi!
I have three large files containing MySQL commands. However, when
importing them using mysql -u [username] -p [database] file.sql, I get
an error:
ERROR 2006 at line xxx: MySQL server has gone away
From reading more at mysql.com, it seems that MySQL reads these large
packets as errors on
Thanx guys!
but:
I'm not in the mood to try Greg's suggestion ... LOL!
I think I'll work around that with Escapade programming language. It's much easier to
handle.
If not:
I run a script that checks record by record in the first table if an update in the
second table is available then I
Hello Maximo,
Wednesday, October 16, 2002, 8:05:23 PM, you wrote:
MM nscd??
nscd - A Name Service Caching Daemon
It's a DNS-something for glibc..
MM I searched for that program and did not find it in linux.
MM How would you go about fixing that problem?
It will be fixed in 3.23.53a that will
Lars,
Thursday, October 17, 2002, 11:54:02 AM, you wrote:
LA I wonder if anyone knows when 3.23.53a will be released? I don't need an
LA exact time, just if it's due today, tomorrow or next week.
New build will be made in a couple of days.
--
For technical support contracts, goto
Erica,
Thursday, October 17, 2002, 12:24:53 PM, you wrote:
ED I have three large files containing MySQL commands. However, when
ED importing them using mysql -u [username] -p [database] file.sql, I get
ED an error:
ED ERROR 2006 at line xxx: MySQL server has gone away
From reading more at
Hi!
This is a bug in RedHat 8.0. Also an up-to-date RedHat 7.x is affected by
this bug.
Sollution:
Start mysql with --skip-name-resolve option.
More info:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=74943
---
Lars Andre
-Original Message-
From: Victoria Reznichenko
On Thu, Oct 17, 2002 at 05:47:02PM +0200, [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
Hi.
When will version 3.23.53a for windows users ?
I downloaded version 3.23.53 but in zip package were mysql version 3.23.52.
(innodb not working in this wersion on win98). What about this ??
Little mistake ?
I. Piasecki
-
STIBS,
Thursday, October 17, 2002, 12:26:34 AM, you wrote:
S I have a littlebig problem:
S I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this
S case a product number) is the same in both tables.
S OK, I did this:
S UPDATE table1 SET table1.field1 =
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
we've now replaced the faulty MySQL-Max 3.23.53 binaries with version
3.23.53a on our downloads section at
http://www.mysql.com/downloads/index.html - the mirror sites should catch
up on these changes soon as well. Please update, if you
It is in the clients RPM.
[EMAIL PROTECTED] wrote:
Description:
No mysqladmin was installed with the rpm. so I can't change the password.
-
Before posting, please check:
http://www.mysql.com/manual.php
Julia,
Thursday, October 17, 2002, 2:29:57 PM, you wrote:
JM This is what I've done:
JM created a database testdb in access with a table cop
JM exported the table as comma separated values into cop.txt
JM created a database called testdb in mysql,
JM created a table called cop of the same
26 matches
Mail list logo