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
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
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
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 not
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
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:
Can audio or video files be attached to a mysql table?
VH
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:
[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
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
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
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]
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
p
--- Chris [EMAIL PROTECTED] wrote:
You could try
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
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'
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 up
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
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
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
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
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.
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. Thanks -
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 |
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í
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;
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:
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
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
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
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
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
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]
-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 General
-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 you're running
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
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:
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 its
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
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
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
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 many
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
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]
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]
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
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]
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.
3)
There is a command or function to call a shell script through mysql?
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
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,
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
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
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í
There is a command or function to call a shell script through mysql?
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
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
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
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
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
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
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
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, but mysql
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 tablename modify columnname double(3,2) unsigned
zerofill, etc.
The MySQL docs are not
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 can I
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 relationales
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
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
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:
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.
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
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,
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,
here's what
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
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
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 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
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
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
Hi Thai,
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
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
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
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
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
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
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
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 sendmail
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
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 wrote:
And the
86 matches
Mail list logo