ok thanx
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Nikos Gatsis" <[EMAIL PROTECTED]>; "Victor Pendleton"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 19, 2003 2:58 AM
Subject: Re: [PHP-DB] TABLE_PRIV
> At 9:02 +0200 11/18/03, Nikos Gatsis wr
I have mysql on linux on two machines. Both version 4.0.16. On one
machine, it is reported as 4.0.16-standard and on the other machine it is
reported as 4.0.16-log (according to PHPMyAdmin). What is the difference
(obviously something with logging) and how can I change from standard to log
and v
Thanks. Have you tried it before? Does it work or not. I found that
the installation process is very complicated. There are 3 sendmail rpm
files. Do I need to install them before applying the patches?
Greg Donald wrote:
>
> On Wed, 19 Nov 2003, unplug wrote:
>
> > Is it possible for sendma
Hello all,
Please forgive what seems like a basic question, but I'm noticing that
my mysql server (4.0.16) is restarting every couple of days. I recently
upgraded from 3.23.53, and it was doing something similar. Problem is
that I'm not sure how to go about diagnosing this problem, and I'm
con
Hello All,
can someone tell me where to get the latest mysql API for Delphi (mysql.pas)
that works with mysql library version 4 ?
i already check the author's site.. and no update yet.
i also found some problem connecting to mysql version 4.1 alpha
with mysqlfront.. it says that the client did n
Hi all,
Is it possible for sendmail to work with mysql under linux
environment? I am finding a way to handle sendmail alias by using
mysql. Does anyone can tell me how to do it? Any reference site?
unplug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
At 9:02 +0200 11/18/03, Nikos Gatsis wrote:
And the columns:
Grantor, Timestamp Table_priv, Column_priv
what is up to?
Ignore the Grantor and Timestamp columns.
They're not used.
Thanx again
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Nikos Gatsis'" <[EMAIL PROT
Thank you. That sounds great but I have a few concerns.
Within the overall user edit session (I suppose this would be one big
transaction held for potentially several hours if I use only a single
database and row versioning), some series of changes must be handled as
their own tran
At 9:10 +0700 11/17/03, Thai Thanh Ha wrote:
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I don't know what is the problem. Please help me!!! Thanks in advance.
Joins can join up to 31 tables in MySQL.
Looks like you're exceeding that limit.
Regards,
Thai
SELECT t.
Hi Stephen,
You can always omit the connection id in PHP (unless you have multiple
connections open for some reason).
Matt
- Original Message -
From: "Stephen Fromm"
Sent: Monday, November 17, 2003 8:26 AM
Subject: php and passing implicit connection identifiers
> The connection iden
Typically, this is the kind of query I see at MS-SQL houses. :)
-- R. Deuce
- Original Message -
From: "Matt W" <[EMAIL PROTECTED]>
To: "Thai Thanh Ha" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 5:28 PM
Subject: Re: Please help DB Error: unknown error
>
Please reply to the list, not to me personally, so that
others can follow this discussion.
At 17:05 -0500 11/18/03, Denis Mercier wrote:
On Tue, 2003-11-18 at 16:40, Paul DuBois wrote:
At 16:21 -0500 11/18/03, Denis Mercier wrote:
>here's what im trying to do, i have a tar file in a blob field
>
Hi Gunnar,
I agree, this should be optimized.
It says in the Internals manual, I believe, that the code already exists
(in what version(s) I don't know) to optimize such searches on multiple
indexes but it just isn't implemented yet. Hopefully it will be soon...
Matt
- Original Message --
Hi Thai,
I think you're just joining wy too many tables! LOL
Matt
- Original Message -
From: "Thai Thanh Ha"
Sent: Sunday, November 16, 2003 8:10 PM
Subject: Please help DB Error: unknown error
> Hi all,
> I have a problem with my query on mySQL 4.0.
> DB Error: unknown error
> I
Hi Rob,
Since you're using 4.0.16, sounds like you are experiencing its
optimizer bug. From the ChangeLog for 4.0.17 (not released yet):
* Fixed optimizer bug, introduced in 4.0.16, when REF access plan was
preferred to more efficient RANGE on another column.
So hopefully the problem only exist
I've got a table with two indices -- one is a datetime with massive
cardinality, and another is a varchar with only 9 distinct values. The
optimizer seems to choose the varchar over the datetime in all cases
unless I specifically say USE INDEX(). Is there some way to make MySQL
"smarter" in this
On Tue, 2003-11-18 at 16:40, Paul DuBois wrote:
> At 16:21 -0500 11/18/03, Denis Mercier wrote:
> >here's what im trying to do, i have a tar file in a blob field
> >and i'm trying to retrieve it and pipe it directly into tar
> >to decompress it, without first writing it to the hard drive,
> >
> >he
Hallo,
MySQL ist selbst ein Datenbank-Server, d.h. man kann sich da hinverbinden,
Datenbanken anlegen, die wieder Tabellen enthalten. Diese Tabellen können
mehrere Spalten unterschiedlichen Typs haben, in die sich mit anderen
Befehlen (SQL-Sprache) Daten einfügen lassen (fast genau wie in Access,
Hi there,
I'm running MySQL 4.0.16-nt (previously 3.23.5x, same system, same problem)
on Windows 2000 Pro SP3 and almost constantly run against the following
error (or similar) when I try to alter something about the structure of a
table (MyISAM database):
Error on rename of '.\BlackBoard\uni_
KEVIN ZEMBOWER wrote:
The organization hired an outside consultant to
evaluate which SQL engine to go with. This is
what he sent to us:
...
"
SQL Server 2000 is a complete Relational Database
Management System (RDBMS) that also includes integrated
analysis functionality for OLAP and data mining.
At 16:21 -0500 11/18/03, Denis Mercier wrote:
here's what im trying to do, i have a tar file in a blob field
and i'm trying to retrieve it and pipe it directly into tar
to decompress it, without first writing it to the hard drive,
here's what i've tried so far,
I create a text file called test1:
us
At 14:05 -0600 11/18/03, Paul DuBois wrote:
At 4:47 PM -0300 11/18/03, adburne wrote:
There is a command or function to call a shell script through mysql?
Invoke mysql, then issue a \h command and look in the output for
the line that begins with "system".
I forgot to mention: The system command is
here's what im trying to do, i have a tar file in a blob field
and i'm trying to retrieve it and pipe it directly into tar
to decompress it, without first writing it to the hard drive,
here's what i've tried so far,
I create a text file called test1:
use my_db;
select * into dumpfile "/usr/lo
Ich hätte da einige Fragen an Sie !
A - Sie sprechen, wenn sie über MYSQL reden einmal von einer
"MySQL, die populärste Open Source SQL-Datenbank, wird von MySQL AB"
dann wiederum ist es ein
"MySQL ist ein Datenbank-Managementsystem"
oder ein
"MySQL ist ein relationa
>> How do I prevent data collision in the following scenario:
>> User A and User B are examining the same data (say a customer's >name
and address). User A modifies something (say the customer's >phone
number) and saves the transaction. User B modifies something >different
at the same time. How
>What command do I use to change the field type in my client_info >table
>from:
>
>referral_percent | tinyint(4) | YES | NULL
>
>to
>
>referral_percent | double(3,2) unsigned zerofill | YES | NULL
alter table modify double(3,2) unsigned
zerofill, etc.
The MySQL docs are not always that e
gerald_clark said:
> If you are going out throught NAT to the mysql server, there should be
> no problem.
> If you are trying to come into the server through NAT you will need port
> forwarding.
>
> adburne wrote:
>
>> Someone can make nat with mysql? I can do it with apache without
>> problems, b
Hi,
Thanks - I'm familiar with the passwd command...this was actually a
mysql question, as I wasn't asking how to change the password, but
rather: would changing the password affect anything that was part of the
processes supporting the database? I've been bitten by account
passwords hiding, and c
Hello,
I'm new to this list, and relatively new to SQL (well more rusty then new).
Anyhow, I really need some assistance with the following query. When I made
it up it worked fine, but then during my testing I deleted all of the info
from the gallery_info table and that blew this query outta the w
Hi Olaf,
Sorry for this misunderstanding.
Try something like this:
AND dayofyear(gebdatum) BETWEEN dayofyear(now()) AND
dayofyear(date_add(now(),interval 7 day))
OR (dayofyear(now()) > dayofyear(date_add(now(),interval 7 day)) AND
(dayofyear(gebdatum) < dayofyear(date_add(now(),interval 7 d
At 4:47 PM -0300 11/18/03, adburne wrote:
There is a command or function to call a shell script through mysql?
Invoke mysql, then issue a \h command and look in the output for
the line that begins with "system".
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Why do you want to login as mysql?
This really is not a mysql question, but
while logged in as root, enter the command:
passwd mysql
Myhre, Julie wrote:
Hello,
I started my current job with MySQL already installed on a Linux box,
and no one seemed to know what the mysql account's password was
If you are going out throught NAT to the mysql server, there should be
no problem.
If you are trying to come into the server through NAT you will need port
forwarding.
adburne wrote:
Someone can make nat with mysql? I can do it with apache without
problems, but mysql client freeze trying to co
There is a command or function to call a shell script through mysql?
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Someone can make nat with mysql? I can do it with apache without problems, but mysql client freeze trying to connect.
Thanx, Alejandro.
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
I have a table that has a field type DOUBLE. I need to put into it data
like '0.123' however any number less than .0001 (like .999) show
up in the field like '1e-05'
Also when I retieve the field in a PHP page it is return like '1e-05'.
Do I have the wrong column definition or am I doing
Has anyone tried MaxProxy, it claims to allow you to use any MySQL
pogram to access the their new MAX SAP solution. it seems to work, but
it causes
MySQL Control Center to crash, anyone else had this problem?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Hello,
I started my current job with MySQL already installed on a Linux box,
and no one seemed to know what the mysql account's password was I
want to know/change the Linux password so I can login as mysql. So far
it has been fine to become root and su to mysql, as I don't do it THAT
often, b
There is a command or function to call a shell script through mysql?
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Thanks for the reply Kim!
On Tuesday 18 November 2003 12:47 pm, you wrote:
> Hello Robert ,,
>
> I have no explanation , just a dummy question ,
> 1) Are all values u try to put into column 5 a float with . ?
Always floats.
> 2) what if u try with integer ?? without . ?
haven't yet tried.
>
for a server that is configured for 500 to 1000 max_connections, how
much RAM is recommended to support this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Robert ,,
I have no explanation , just a dummy question ,
1) Are all values u try to put into column 5 a float with . ?
2) what if u try with integer ?? without . ?
3) can u input float values in column 3 ?
4) are u running mysqlcc from same pc ?
5 could it be some settings with decimal p
is there a way to close aging sleeeping connections after they have
slept for a certain amount of time? a setting or something in mysql?
dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi folks
A query become with STATE set to STATISTICS and all queries after this
query are LOCKED.
What is the decision please.
Best Regards
Bogomil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>Description:
I have loaded mysql version 4.0.15 onto my G4 Mac running Darwin 6.8
Kernel.
We are running an application that interfaces with mysql in saving its
data. When I try to start up the application, I receive the following
error message:
dyld: /usr/local/monetra/bin/monetra can
In the last episode (Nov 18), Jrgen Winqvist said:
> I'm working with an application that uses a lot of tables. Apx 50k
> tables are accessed every 5 minuts and they are openened/closed
> constantly. There is a performance problem and i've changed the
> filesystem to reiserfs for better handling ma
I can't believe I'm saying this, but MySQL may not be the db of choice for your
particular app...
I figure you have few options:
1- keep db structure same, keep mysql, suffer performance issues
2- keep db structure, switch db, suffer migration costs
3- change db structure, keep mysql, suffer app
Hi Chris,
I know its not good to have that many tables but that's the way its
done. I can't see why a merge would help. It still has to open all the
tables.
regards
/jorgen
Chris Nolan wrote:
Hi!
Looking through the docs, MySQL's internals don't seem to lend
themselves well to having this
There recently was a thread discussing this with a very nice summary by the person who
had the issue... do a search on the archives for 'maintaining the size of a db' to
find the thread
> -Original Message-
> From: M.D. DeWar [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 18, 2003 1
delete from TABLENAME where CONDITION
- Original Message -
From: "M.D. DeWar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 3:50 PM
Subject: db maint
: Hello
: WARNING::Newbie.
:
: I have snort running and putting alerts into a mysql database.
: I see that
Hello
WARNING::Newbie.
I have snort running and putting alerts into a mysql database.
I see that its starting to get big.
How does one go about "cleaning" the db ?
or deleting old data ?
Thanks
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi!
Looking through the docs, MySQL's internals don't seem to lend
themselves well to having this many tables. Is there any chance you
could use MERGE tables to chuck a few of them together (admittedly I'm
guessing here).
Regards,
Chris
Jörgen Winqvist wrote:
I'm working with an application
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Prasad Budim Ram wrote:
> Hi,
>
> I'm getting the following error while connecting to a MySQL databases
> using JDBC. Any clues??
>
> "java.net.SocketException: errno: 48, error: Address already in use"
>
> Thanks,
> Ram
>
>
You don't say what OS yo
> -Original Message-
> From: Jorge Paiva (f2) [mailto:[EMAIL PROTECTED]
> Sent: 18 November 2003 15:14
> To: [EMAIL PROTECTED]
> Subject: [jp] Unions in mysql 3.22
>
>
> CAN I USE UNION cluse in mysql 3.22??
No! UNION is implemented in MySQL 4.0.0 and later.
- Barry
--
MySQL Genera
CAN I USE UNION cluse in mysql 3.22??
thank you ..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Two related questions.
1. I have a table with a "date" field. (Ex: '04/13/2002'). I want to get a list
of all UNIQUE values for that field (many entries from the same day), i.e., all
days with entries.
**
CREATE TABLE metrics_events_power {
mep_id int(11) NOT
it happened on 3 different machines (2*win2000 & 1*win2003)
we have a big logger running at the same time and it tells nothing partiular
about the disk activity.
else i have had a mysql 4.0.x + 4.1.0 beta at home taking a lot of requests
for a quite a long time now (requests are performed thru php
I'm working with an application that uses a lot of tables. Apx 50k
tables are accessed every 5 minuts and they are openened/closed
constantly. There is a performance problem and i've changed the
filesystem to reiserfs for better handling many files. I also increased
the open-file limit in both
Can you post what you are trying to do?
-Original Message-
From: Prasad Budim Ram [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 2:17 AM
To: [EMAIL PROTECTED]
Subject: Needing help for JDBC issue
Hi,
I'm getting the following error while connecting to a MySQL databases
usin
Are the crashes occurring on the same machines? Or random machines? Can you
track the disk activity at the time the table is being marked as corrupt?
Are you tracking the database activity?
-Original Message-
From: fabien marsaud [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 5
Jeremy,
Thanks very much. 'preciate it.
-Original Message-
From: Jeremy March [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 8:46 AM
To: [EMAIL PROTECTED]
Subject: Re: Changing field type
>What command do I use to change the field type in my client_info table
>from:
>referr
What command do I use to change the field type in my client_info table
from:
referral_percent | tinyint(4) | YES | NULL
to
referral_percent | double(3,2) unsigned zerofill | YES | NULL
ALTER TABLE yourtable CHANGE referral_percent referral_percent double(3,2)
unsigned zerofill default null;
or:
Someone can make nat with mysql? I can do it with apache without problems, but mysql client freeze trying to connect.
Thanx, Alejandro.
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
G'Day All;
MySQL on RedHat 9
working completely from the command prompt. I am so newbie I am
embareassed.
What command do I use to change the field type in my client_info table
from:
referral_percent | tinyint(4) | YES | NULL
to
referral_percent | double(3,2) unsigned zerofill | YES
On Mon, 2003-11-17 at 13:42, Harald Fernengel wrote:
> Hello John,
>
> ... We had some reports
> about uint<->int problems with MySQL, but I believe we fixed them all in Qt
> 3.3, so there should not be any problems.
>
> Best regards,
> Harald
I can confirm that the problem is fixed in 3.3. Th
Dear all,
The documentation for 4.0.xx states that for MyISAM tables:
Maximum number of keys/table is 32 as default. This can be enlarged to 64 without
having to recompile myisamchk.
HOW TO DO THIS ?? Have someone done this?
I am using MySQL 4.0.16 precompiled binaries for Solaris.
Thanks
Hi
I'm working with mysql 4.0.15 for some software of ours and we are experiencing a
random table crash.
we have 30 MyISAM tables in our database and we're using JDBC to connect to them.
Sometimes, very rarely, one of the tables crashes. It has nothing special compared to
the other tables (int
Bernard Clement wrote:
rsynch will do the job correctly only and only if the mysql server on both
sides are not running. Rsynch does not deal with files opened for writing
and my guess is that MySQL is opening the database (i.e. files) for writing.
It will work without stopping mysql server if
I think that it is more than backing up the database you want to do. If I am
right you want to synchronize the 2 databases in which case the answer is
replication. Replication is described in the reference manual of MySQL.
Bernard
On Tuesday 18 November 2003 04:59, Paco Martinez wrote:
> Is
rsynch will do the job correctly only and only if the mysql server on both
sides are not running. Rsynch does not deal with files opened for writing
and my guess is that MySQL is opening the database (i.e. files) for writing.
As for LVM (AKA Logical Volume Manager) I really do not see how it c
Just me has access to that machine...
And there's no LVM.
- Original Message -
From: "Simon Green" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 11:12 AM
Subject: RE: Backup question.
> Has any one use LVM to take a snapshot in MySQL and use this to back
Hi,
I wonder if a small enhancement to the
mysql planner/optimizer could be made.
The current (mysql4.0) optimizer only uses one index per SELECT.
Because of this some queries result in a slow fulltable scan
even if all used columns are indexed.
Example:
SELECT * FROM table1 WHERE columnA='x' O
Has any one use LVM to take a snapshot in MySQL and use this to back up
data?
Simon
-Original Message-
From: Paco Martinez [mailto:[EMAIL PROTECTED]
Sent: 18 November 2003 10:00
To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED]
Subject: Re: Backup question.
Is there any problem
Thank you.
Now I read tutorials at the new PHP web site, so my
old
scripts are refurbished and are functional.
I initialize every variable like this:
$var1 = $_POST['var1'];
for example, and values are correctly passed.
Mario
--- Chris <[EMAIL PROTECTED]> wrote:
> You could try http://us2.php.
Is there any problem executing "rsync /var/lib/mysql/data/" from one host to
another host and therefore having same file in obth machines??
Is it unsafe this method ??
Could be crashed meanwhile transferring ??
Thanks !!!
- Original Message -
From: "Christensen, Dave" <[EMAIL PROTECTED
I have 3 tables and want data from the first 2, but only want data from the third on
the rare times that there is a match in tables 2 & 3. If the conditions are not met in
table 3, I don't get the results i still want from table 1 & table 2.
Is there any way to do this in one query, without hav
Thank you. It was the king of advice that I needed,
because I was unaware of the existence of this
parameter.
I was struggling with the lack of mysql support when I
tried
to use the new RedHat 9. When I finally solved that
problem, I became confused with the inability to
transmit
variable values t
[EMAIL PROTECTED] wrote:
>
> Can audio or video files be attached to a mysql table?
>
You can store them in the BLOB columns:
http://www.mysql.com/doc/en/BLOB.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http:
> Can audio or video files be attached to a mysql table?
>
> VH
Very short question, but personally, i'd store the filenames and its
information into a media table rather than importing the binary data or it
would get huge !
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
Can audio or video files be attached to a mysql table?
VH
Hi,
I'm getting the following error while connecting to a MySQL databases
using JDBC. Any clues??
"java.net.SocketException: errno: 48, error: Address already in use"
Thanks,
Ram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mys
I think it would depend on what you are going to do with the
data once it is in the database. If it will only ever be used as a pure
text field, then leaving it as a varchar would not be bad. On the other
hand, if you want to be able to use any of the date fucntions or use it
as a date in
I have a table with one timestamp field named "timedate" (Unix_timestamp
format). I used the follow command but it's not working correctly:
mysql> select count(*) from tablename where date_format(timedate,"%Y-%m-%d")
between date_sub(now(), interval 1 DAY) and now();
Empty Set
This result is no
Hi,
This can be done using 3.23.49a, but it won't work, because the birthday
year is somthing like 1981 and now() returns 2003. That is exactly the
problem which I try to work out.
\Olaf
Peter Sap wrote:
Hi Olaf,
try something like this:
AND gebdatum between now() and date_add(now(),interva
And the columns:
Grantor, Timestamp Table_priv, Column_priv
what is up to?
Thanx again
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Nikos Gatsis'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 3:37 PM
Subject: RE: [PHP-DB] TABLE_PRIV
You could try http://us2.php.net/ , http://us3.php.net/ , or
http://us4.php.net/ .
This isn't a PHP mailing list, but I'll answer your question briefly.
The php.ini setting register_globals is set to 'off', so the $PHP_SELF
variable isn't getting created. Either change $PHP_SELF to
$_SERVER['PHP_
86 matches
Mail list logo
