MySQL 4.0.12 max on AIX 4.3.2
Following are part of .err log file:
030615 1:29:44 Aborted connection 163 to db: 'New' user: 'happy' host:
`192.168.5.108' (Got an error reading communication packets)
030615 1:29:54 Aborted connection 167 to db: 'New' user: 'happy' host:
`192.168.5.108' (Got an
On 12-Jun-2003 Wong Zach-CHZ013 wrote:
> Hi
> 1 - I have a column whose datatype is longtext. Its content is
> 08/06/2003;
> I created a new column whose datatype is DATE. Its content is null now.
> How do write a SQL statement that
> inputs each row from 08/06/2003 in the
> old column to 2003-08-
If there's not a way to do this I would suggest it be added to the next version of
MySQL, but has anyone ever heard of an "EXCEPT FOR" clause that can be used in MySQL's
SELECT statements? For instance... "SELECT * FROM products EXCEPT FOR colors WHERE
sizes LIKE '%small%'"
Thanks...
Jed Huns
Hello,
I am new to the list, so pardon me if I am on the wrong one posting my question.
If so, please direct me to the right place.
My question is in regards to the efficiency of INSERT statements. I have gone over
some of the optimizations, and on a machine running the client and MySQ
I don¹t seem to be getting any messages, this is just a test, mysql query
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com Fax: 313.557.5052
[EMAIL PROTECTED]
Use sessions in PHP (super simple, just call session_start() at the top
of every page i.e. like in an include file) and use
$_SESSION['loginname']
I would strongly recommend using mod_auth_mysql for your authentication.
It's easy and probably more secure than anything you can write ;-) Plus
it let
I've been messing around making very simple web pages using PHP and connecting
to a MySQL database. I've tried using different users to connect and
different grants, but so far the ONLY user that can connect through these
pages is root, and we all know that isn't cool. I've done "grant all on *
If you mean a file as in an image or other binary data, you need to use a BLOB
field.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Joe Baptista" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, 14 June, 2003 19:57
Subject: howto store file
If you have the sgi_fam, you could place a file in a directoy everytime
you add a row. the sgi_fam module would inform your app that there was a
change on the filesystem. When the notification is made, your app can
then get the new value from the database.
I believe that one user suggested that
actually, its worse. upon re-reading you need to compile in the mysql
drivers for mysql.
configure --with-mysql=
Curtis
Subscriptions said:
> The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
>
>
> I've looked through google and I can't find anything that makes since
> to me.
You need to recompile PHP against the 4.0.nn headers.
Curtis
Subscriptions said:
> The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
>
>
> I've looked through google and I can't find anything that makes since
> to me. Can someone point me in a direction as to where I can find t
methinks you have other troubles. i've been running MySQL on K6II-266 for
a long time and its been running fine serving up several databases with
multiple users. 512MB of RAM currently but it had only 128 until
recently. Its running Linux (RedHat 7.2). I recently switched to 4.03,
but it had b
I need to store a file as mysql record. I assume I use the text variable
but have no idea how to read the file into the mysql record.
Please note I am not reading a file to a table - so not the LOAD DATA
INFILE function but a means of storeing the contents of a file as a
record. anyone know how
Hi
SELECT
COUNT(DISTINCT trEmail ) as clicks
, trEmail FROM table
GROUP BY trEmail
ORDER BY clicks DESC
will probably give what you are looking for
Peter
-Original Message-
From: Tim Thorburn [mailto:[EMAIL PROTECTED]
Sent: 15 June 2003 00:14
To: [EMAIL PROTEC
Hi,
I'm setting up a small tracking program for a site I'm working on -
basically it monitors all external web and email links that are clicked
from our site and stores them into a MySQL database.
Now I'm trying to extract the information from the database and display it
on screen with PHP. I
Your query seems relatively easy if you don't need the first test (in this case,
testID 2) explicitly printed.
mysql> SELECT * FROM tests WHERE testID<=7 AND connect>0;
+-+--+--+
| testId | connect | result |
+-+--+---
Miguel,
if you are running MySQL-4.0.13, please use
SHOW INNODB STATUS
to look at a detailed error message of the latest foreign key error.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support fro
Hi every one does anyone know if there are bugs on the statement ON DELETE
CASCADE, cause I have 2 tables as follows:
Reparacion |CREATE TABLE `Reparacion` (
`folio` bigint(19) NOT NULL default '0',
`idTipo` int(4) NOT NULL default '0',
`idAlmacen` int(4) NOT NULL default '0',
`idStatusGener
Simply I didn't know where the password was located in myphpadmin. I
wanted it secure but I wanted to be able to get to the data with myphpadmin
too. But now I know where it is I put the password in. And now I want to
protect phpmyadmin so that only folks with a username/password can access i
I think I have figured out what he wants:
He wants to set a root password (randomly) and then save it in
~root/.my.cnf so that the root user doesn't (apparently) need a password
to log into MySQL.
However, any other user trying to log in as root would need to know the
password.
Am I close?
-
i am using red hat linux 9 on x86
i have copied that the errno.h file from /usr/include
and put #include <"errno.h"> at the top of the file
here it is what it looke like..
__
/* mysql command tool
* Commands compatible with mSQL by David J. Hughes
*
* Wri
Paul DuBois wrote:
This indicates that in the GRANT statement, you typed '[EMAIL PROTECTED]'
rather than 'david'@'localhost' (the username and hostname should be
quoted separately). Try it again with them quoted separately and the
problem should go away.
Worked like a charm. Thank you very much!
-
At 11:51 -0400 6/14/03, David Shochat wrote:
This must be a very elementary question. I am a brand new user. I
was able to set the root password and can connect as root with no
problem. I created a database named remembrance. Where I got stuck
was when I tried creating a user. I tried to do it t
What kind of system is this?
If you put this line near the top of client/mysql.cc (say, after the
line that includes signal.h), does the compile proceed?
#include
(I'm assuming that you have an errno.h somewhere on your system.)
At 8:43 -0700 6/14/03, Gaurav Kumar wrote:
hello mysql users.
i ha
This must be a very elementary question. I am a brand new user. I was able to set the root password and can connect as root with no problem. I created a database named remembrance. Where I got stuck was when I tried creating a user. I tried to do it this way (as root):
grant all on remembrance.* t
At 1:53 -0400 6/14/03, John Chang wrote:
It worked!!. Thanks. Now how do I protect it so that not anyone
who points to it cannot get to it without putting in a
username/password?
You seem to have an odd set of goals.
First, you want to remove the password from your MySQL root account.
That is,
hello mysql users.
i have lately joined the wonderful world of mysql.
i downloaded tarball mysqla-3.23.54a.
./configure is not giving me any problem.
however on executing make to compile the source file i
am getting error
_
make[2]: Entering
Hi, sorry for my bad english.
I've a table where i store the result of a quality test.
If the test is passed then the result=ok and connect=0
If test fail then result=nok and, if it's the first test for the
product, connect=0
When i retest a failed product i've connect= previous testid of the
pro
Becoming Digital wrote:
The error is in FLOAT(1). Think about that for a moment. What's a float with
one-digit precision? It's an integer. :)
While I agree with your analysis the error was a missing comma. The
float(1), which I originally thought was array size of 1, appeared to
work fine.
-
Wong Zach-CHZ013 <[EMAIL PROTECTED]> wrote:
> 1- Is there a command to rename an existing database ?
Nope.
> 2- If not, how does one create a new database from an existing database ?
> could you show me the steps?
If your database doesn't have InnoDB table you can take down MySQL server, rename
I need a correct configure.in file. That file from site cannot be compiled in cygwin.
Please help me.
Iulian
Yes but it can be done?
If i'm not wrong actually db replication is only supported
between secondary db or not?
There are documents which explains how to build a two
master replicated server?
Thanks so much!
Roberto
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To:
John Utting wrote:
Hi,
I have installed MySQL v4.0.13 on a Win2K machine. the installation
directory is C:\mysql
I've installed it as a service using 'mysqld-nt -install' and the service is
running.
I've checked to se that it is working using 'mysqlshow', 'mysqlshow mysql' &
'mysqladmin version s
Try setting the user as [EMAIL PROTECTED]
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "John Utting" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, 14 June, 2003 07:57
Subject: Setting root password
Hi,
I have installed MySQL v4.0.13
Take a look at this section of the manual.
http://www.mysql.com/doc/en/LOAD_DATA.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Ben Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, 14 June, 2003 07:20
Subject: import weirdness
Hi,
I have installed MySQL v4.0.13 on a Win2K machine. the installation
directory is C:\mysql
I've installed it as a service using 'mysqld-nt -install' and the service is
running.
I've checked to se that it is working using 'mysqlshow', 'mysqlshow mysql' &
'mysqladmin version status proc'. All
Hello,
This is my first post to the list. I'm trying to import a text file
into a new database table. Items corresponding to the different fields
in the table are separated by commas. However, every time I try to
import the file, all entries are added to the first column in the
table. What am
The error is in FLOAT(1). Think about that for a moment. What's a float with
one-digit precision? It's an integer. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Chris Webster" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 10 June, 2
Recently I received a number of reports from users of my phpOpenTracker
software about the following MySQL error
Error: Can't open file: 'pot_visitors.MYD'. (errno: 145)
The error goes away after repairing the table in question.
Any idea how phpOpenTracker might trigger this?
Than
> You saved my day. Haven't laughed like this for long time ;-)
Seriously. I wish I was drinking more earlier so as to fully appreciate this
one.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "John Chang" <[EM
Hi,
On Fri, Jun 13, 2003 at 02:08:33PM -0700, jack ma wrote:
> I had updated a field for all the entries in a table
> by mistake, I need to undo that step. I dont have the
> database back up to an stisfactory level. Is there a
> way in MySQL I can step one action back? or undo one
> command that I
41 matches
Mail list logo
