SQL
Hi, all!
I have a problem after migration from 4.0.20 to 4.1.2
I have a table `analit`.
this is the result of show create table:
CREATE TABLE `analit` (
`d` date NOT NULL default '-00-00',
`service` binary(16) NOT NULL default '',
`price` char(50) NOT NULL default '',
`type`
At 22:54 -0700 6/4/04, jerome greene wrote:
Where do you run the verify programs from? Are they ran from the
command prompt? Do I copy the keys?
Thanks
What is the context of these questions?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL
Hi,
I have a question about MySQL queries. First I will explain the situation,
then I will provide an example.
Situation:
I have the tables 'offer', 'contact' and 'offer_contact'. Table 'offer'
contains data about offers, table 'contact' about contacts. Table
'offer_contact' tells which
Hello:
I am posting this message on freeRADIUS, vpopmail mysql lists. This may
get few people upset but please read
I am trying to install (on RH9), qmail, vpopmail, mysql, Courier-IMAP,
squirrelmail, etc., with backend data on MySQL. On another computer I have
installed RH9 freeRADIUS
Hello,
The windows binary of 4.1.1 was around 20 MB. With
4.1.2 it has increased to 34 MB. Thats a big jump ?
Karam
__
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General
Hi,
I am on a redhat, i read a lot of doc on the problem I hav but noway to
advance, mysql won't start and won't tell anything :
[EMAIL PROTECTED] [~]# service mysql start
[EMAIL PROTECTED] [~]# mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
At 19:21 +0200 6/5/04, pourave wrote:
Hi,
I am on a redhat, i read a lot of doc on the problem I hav but noway to
advance, mysql won't start and won't tell anything :
mysql is a client program.
The server is named mysqld.
[EMAIL PROTECTED] [~]# service mysql start
[EMAIL PROTECTED] [~]# mysql
I think that I'd look at postfix and dbmail. Postfix and dbmail both
allow userdata to be stored in MySQL databases. dbmail will also put the
message store in a mysql database. Very nice, very fast. RH9 has hit
eol. Gentoo rocks.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
At 19:21 +0200 6/5/04, pourave wrote:
Hi,
I am on a redhat, i read a lot of doc on the problem I hav but noway to
advance, mysql won't start and won't tell anything :
mysql is a client program.
The server is named mysqld.
I know under redhat a script call service is used to start
At 20:05 +0200 6/5/04, pourave wrote:
At 19:21 +0200 6/5/04, pourave wrote:
Hi,
I am on a redhat, i read a lot of doc on the problem I hav but noway to
advance, mysql won't start and won't tell anything :
mysql is a client program.
The server is named mysqld.
I know under redhat a
On 04.06.2004 21:09 (+0200), Mark Maggelet wrote:
Hi.
I'm having this problem on 4.1.2, when I run myisamchk -o on my table I
get a bunch of these lines:
[...]
Would you please not reply to a mail to create a new thread? This
message will be displayed somewhere deep inside another thread and
On 04.06.2004 20:46 (+0200), Sasha Pachev wrote:
Subquery optimizer is still is a very early stage in 4.1. Much more often than
not, a carefully crafted join, union, or a sequence of queries using a temporary
table will be faster. In fact, I wonder if it is even possible to write a
machine
Okay. What does the MySQL error log say. Anything?
Do you know where can I find it ?
Dates are old 031222 ! ...
[EMAIL PROTECTED] [/var/log]# tail mysqld.log
/usr/sbin/mysqld: ready for connections.
Version: '4.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306
031222 12:57:02
I think he's talking about download MySQL, and verifying the binary
using MD5.
There is a link right above the downloads for verification of the binary.
http://dev.mysql.com/doc/mysql/en/Verifying_Package_Integrity.html
The contents of the page @ that URL suggest using GNU Privacy Guard.
David
I am converting a form that was originally designed to be Email
Submitted into a Submit-to-PHP-Page Form (which will then insert the
data into a MySQL Database).
I expect no problems in actually scanning the submission to extract
the data but I have some questions on the design of the Tables
Klaas Geldof [EMAIL PROTECTED] wrote:
I have a question about MySQL queries. First I will explain the situation,
then I will provide an example.
Situation:
I have the tables 'offer', 'contact' and 'offer_contact'. Table 'offer'
contains data about offers, table 'contact' about
Hi,
Does anybody have experience with FreeBSD 5.x
Mysql ?
FreeBSD 4.x and mysql seems to be awful combination due to threading , but I have no
tried FreeBSD 5.x with mysql under heavy load
Thanks,
Peter Zyumbilev
Project Manager
Mansion Productions Inc.
AIM: peterZmansion
YMS:
This is my first email to the list, so be nice ;-)
I'm having some difficulty with a subquery that I'm trying to do, and was
wondering if anyone here can shed some light on the issue...
This query returns a result as expected:
SELECT id FROM client_list WHERE name=Some Company
(the id returned
On Sat, 5 Jun 2004 19:48:44 -0600
Daniel Isenhower [EMAIL PROTECTED] wrote:
This is my first email to the list, so be nice ;-)
Welcome, this is a very helpful list...
I'm having some difficulty with a subquery that I'm trying to do,
and was wondering if anyone here can shed some light on the
If you need it to work, I'm afraid you're out of luck. Think about
what a IN (x,y,z) means. It's basically the same as a = x or a = y
or a = z. So wifi_list IN (NULL) is like wifi_list = NULL,
which is never true.
Thanks for the reply Paul, and I get that NULL is a special case value,
First off, I assume you are using a version of mysql able to handle
sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries)
Ugh... I feel dumb :) I'm using 4.0
FWIW, this is an easy query with a JOIN:
SELECT id FROM work w
INNER JOIN client_list cl ON cl.id = w.client_id
WHERE
At 18:50 -0700 6/5/04, Daevid Vincent wrote:
If you need it to work, I'm afraid you're out of luck. Think about
what a IN (x,y,z) means. It's basically the same as a = x or a = y
or a = z. So wifi_list IN (NULL) is like wifi_list = NULL,
which is never true.
Thanks for the reply Paul, and
anyone know why the mysql daemon fails to start after I set the root
password according to this:
http://dev.mysql.com/doc/mysql/en/Default_privileges.html
I use the command:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');
This
Hi,
I am using the following code but not getting a
connection. :( Can someone tell me what I am doing
incorrectly?
Thanks, Scott
package database_test;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import
Sorry guys if I was not clear.
I have copied mysql-4.0.20a-win.zip to my computer. On the downloads page it is
suggested that I verify the integrity of the packages that I downloaded. I am trying
to fine out how to do this. I first have to unzip the file first. Do I copy the code
from MD5
I have redhat9. I removed the RPM install of MySQL, and instead installed 3
copies of MySQL-4.0.20 BINARY distributions into my /usr/local/ directory,
under the helpful instructions of Thierno Cisse.
However, it seems like now, the PHP RPM installation cannot find the mysql
extension. When I
26 matches
Mail list logo