I am running RH 2.1 ES, i recently upgraded to 3.23.56-1.72. I am using
mysql as a backend for postfix MTA. I use webmin to add new users to my
database. Today, after upgrading, there was a distinct problem. I
added a user, left a field blank, it was the relocate_to feild, which
unless i put so
I am guessing that you are trying to find a MySQL data type of "Currency",
which does not exist.
I generally use a column that is DECIMAL(150,2) for US currency.
--Scott
At 01:32 PM 10/2/2003, Fabio Bernardo wrote:
I´m having some problems with currency´s fields. Actually I dont know what
mys
At 21:07 -0500 10/2/03, Brad Teale wrote:
Hi All,
I asked earlier about a query being slow, possibly due to MySQL 'Using
temporary; Using filesort' when processing the query. I have done some
testing, and it appears that no matter what data set is used, MySQL always
performs a select with a 'gran
At 9:33 +0800 10/3/03, â§ïíâ wrote:
Hi mysql :
Client O.S. is Windows 2000 Professional
MyODBC Version is 2_50.39 for windows
Mysql Database Engine version 3.23.52
Mysql server O.S. Redhat 8
Error Message :Host 'pc100' is not allowed to
connect to mysql server (#1130)
Could you hel
Hi mysql :
Client O.S. is Windows 2000 Professional
MyODBC Version is 2_50.39 for windows
Mysql Database Engine version 3.23.52
Mysql server O.S. Redhat 8
Error Message :Host 'pc100' is not allowed to connect to mysql server (#1130)
Could you help me fix this problems .
thank you
Hi All,
I asked earlier about a query being slow, possibly due to MySQL 'Using
temporary; Using filesort' when processing the query. I have done some
testing, and it appears that no matter what data set is used, MySQL always
performs a select with a 'grant by' clause using the temporary and files
At 17:06 -0500 10/2/03, Christensen, Dave wrote:
You're going to have to see where the files were installed. It was easier
with Red Hat 7.3 because the Kpackage program would tell you where the files
were installed. I don't know how you find that info out with Red Hat 8.0 or
9.0.
You can use rpm
Aparrently my binlogs grew and grew and ate up all the space on their
partition.
At this point, I see this on the master
mysql> show master status;
Empty set (0.00 sec)
and this on the slave:
mysql> show slave status\G
*** 1. row ***
Mast
At 17:32 -0300 10/2/03, Fabio Bernardo wrote:
I´m having some problems with currency´s fields. Actually I dont know what
mysql´s field typeI have to choose..^
I wanna input this value: U$32.00 but, when I write the query: Select
'field' from table it returns..
'32' and not 32.00.
Wh
At 16:43 -0400 10/1/03, [EMAIL PROTECTED] wrote:
I need to know the syntax to link two tables together that are in two
seperate DB's using the ODBC drivers in PHP. Can anyone help with an
example?
Depends on what you mean by "link two tables together." if you're trying
to perform a join, you can
Hi list,
I have the following problem and here is the message that displays the
console when I try to connect
"Warning: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent"
Greetings
Mikel
__
Ugh, ok, somehow the client package did not install. When I searched for
files I found it odd that the client binaries were the ones missing. I must
have fat fingered the rpm -i command. I installed them and it's working now.
:-P
Roger
-Original Message-
From: Christensen, Dave [mailto:[
At 14:02 2/10/2003 -0400, Matt Babineau wrote:
Hi,
it says the wait_timeout is still 28800 which is too long!
Any ideas?
mysql> show variables like "wait_timeout";
+---+---+
| Variable_name | Value |
+---+---+
| wait_timeout | 28800 |
+---+---+
1
Yeah mysql is reading the config file, because I have set other options
like query_cache_size...so I'm not sure :-(
On Thu, 2003-10-02 at 18:09, Jeremy Zawodny wrote:
> On Thu, Oct 02, 2003 at 02:02:34PM -0400, Matt Babineau wrote:
> > Hey All--
> >
> > I have MySQL 4.0.14 running on Redhat Linux
On Thu, Oct 02, 2003 at 02:02:34PM -0400, Matt Babineau wrote:
> Hey All--
>
> I have MySQL 4.0.14 running on Redhat Linux and it won't accept my
> change to the wait_timeout config option!
>
> In the my.cnf file I have a line
>
> wait_timeout = 60
>
> but when I restart mysql and go into
Hey All--
I have MySQL 4.0.14 running on Redhat Linux and it won't accept my
change to the wait_timeout config option!
In the my.cnf file I have a line
wait_timeout = 60
but when I restart mysql and go into the server and type SHOW VARIABLES;
it says the wait_timeout is still 28800 whi
You're going to have to see where the files were installed. It was easier
with Red Hat 7.3 because the Kpackage program would tell you where the files
were installed. I don't know how you find that info out with Red Hat 8.0 or
9.0.
-Original Message-
From: Harrell, Roger [mailto:[EMAIL P
I am installing MySQL 4.0.15 on Red Hat Linux 8. I ran the rpms for server
and client. It installed and started mysqld but none of the command set
seems to be on the system anywhere. No mysql, mysqladmin, etc. The docs
don't give much help after running the rpms. After secton 2.1.2 it refers
to se
On Tue, Sep 30, 2003 at 09:36:46PM +0100, Seun Osewa wrote:
> Hi Jeremy,
>
> Hmmm ... I guess the meat of my suggestion is that it be made
> available on a per-transaction basis because in many applications
> some transactions are more "critical" than others. So even on
> systems where there are
Running 4.0.15a. The second select's FOUND_ROWS() returns the wrong number of rows.
To test yourself:
create database test1234;
\r test1234
create table test (id int, primary key (id));
insert into test values (1), (2), (3), (4), (5);
select SQL_CALC_FOUND_ROWS * from test where id > 3 limit 0, 1
Hi all!
I'd like to replace the values of nIndex field in NewOrder table with
the values of the same field in the table InvMast...
In MySQL 4 it is like this:
"UPDATE neworder, invmast SET NewOrder.nIndex = InvMast.nIndex WHERE
neworder.sItemNo = invmast.sItemNo"
The problem is this does not wo
At 3:12 PM -0700 10/1/03, Bill Doerrfeld wrote:
FYI. A 3rd party developer has just come out with an awesome Web
browser based GUI for managing MySQL databases. Check it out!
To: <[EMAIL PROTECTED]>
Date: Wed, 01 Oct 2003 15:15:51 -0400
Subject: [ANN] INTRODUCING LDMLMySQL
From: Jim Van Heule <[
I´m having some problems with currency´s fields. Actually I dont know what
mysql´s field typeI have to choose..^
I wanna input this value: U$32.00 but, when I write the query: Select
'field' from table it returns..
'32' and not 32.00.
Which select statement do i have to write?
tha
[EMAIL PROTECTED] wrote:
In MYSQL documentation the following line is
Some cases are not supported by LOAD DATA INFILE:
1. Fixed-size rows( FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty)
and BLOB or TEXT columns
I defined a column in a table as type TEXT. I then loaded values using LOA
M. Dee,
yes, this is a known bug. I already fixed it in spring, but then
inadvertently wiped out the changes :(. Let us try to keep this bug in mind
so that it gets fixed soon.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQ
In MYSQL documentation the following line is
Some cases are not supported by LOAD DATA INFILE:
1. Fixed-size rows( FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty)
and BLOB or TEXT columns
I defined a column in a table as type TEXT. I then loaded values using LOAD
DATA INFILE into the tabl
Hello,
I am trying to compile MySQL 4.0.15a on a Solaris system. I am not
having much luck and would appreciate some help.
Here is the error and I will tell all information I can think of that
might help:
gcc -O3 -DDBUG_OFF -I/usr/local/openssl/include
-I/usr/local/openssh/include -I/usr/l
What are the configuration you are using? What's the size of your buffers?
What's your system?
Maybe increasing sort buffer and key buffer will be good.
;)
Alexis
Quoting Brad Teale <[EMAIL PROTECTED]>:
> Hello,
>
> The problem:
> I have the following query with is taking upwards of 2 minute
I have searched the web and a couple book stores for a book that can refer to covering
MySQL with ASP. I called MySQL to see if they had a reccomendation and they referred
me to the maling lists.
Thanks in advance...
Michael
_
Hello,
The problem:
I have the following query with is taking upwards of 2 minutes to complete
and we need it faster, prefer less than 30 seconds (don't laugh):
select modelhr, avg(f.temp-b.temp), avg(abs(f.temp-b.temp)),
stddev(f.temp-b.temp), stddev(abs(f.temp-b.temp)), count(f.temp-b.temp) fro
Hi folks,
I just set up a slave server and it seemed to be working alright,
catching up with the new data, and then the server suddenly went away.
Looking at the slave's data directory, there are approximately 2
relay-bin files. I can't even restart the server now, because it gets a
sig
Hi,
I am working on set up the new apache server on Linux using Mysql
databases,
and moving all the files from old server to new one.
Problem I have is how to set the mod_auth_mysql on the new one?
I need to have MySQl authentication when users to get in the website.
Old machine Apache ver
On 2 Oct 2003 at 11:41, Harald Fuchs wrote about Re: Is something like this even
possible? (Result
>
> I think I found a solution. For 4.1:
>
> SELECT r1.*
> FROM mytbl r1, (
> SELECT x1.category, x1.itemid, COUNT(x2.category) AS rank
> FROM mytbl x1
> LEFT JOIN mytbl x2 O
>Description:
I have a mysql server running with ansi option.
When I run my database create script I get:
ERROR 1005: Can't create table './pinball/B.frm' (errno: 150)
This seems to indicate that that:
150 = Foreign key constraint is incorrectly formed
On Thu, 2 Oct 2003 07:33:55 -0700 (PDT)
shahanawaz lakhani <[EMAIL PROTECTED]> wrote:
> Our MySql version : "mysql Ver 11.12 Distrib
> 3.23.32, for pc-linux-gnu (i686)"
upgrade first.
3.23.32 is _very_ old version.
---
WBR,
Antony Dovgal aka tony2001
[EMAIL PROTECTED]
--
MySQL General Mailin
Hi ! I am facing a real strange problem, this is the
third time some of my .MYI files are missing from the
database in the past 10 days. I restored the backup
but after a couple of days i observed that again some
of them were missing. This way i am really loosing
very crucial data, i would really
I need to know the syntax to link two tables together that are in two
seperate DB's using the ODBC drivers in PHP. Can anyone help with an
example?
Thanks
Terry L.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
Hi,
I forgot to mention that the table contains more information, it has
more columns than just a and b. These extra columns contains the actual
information that I'm looking for.
I.e. the mentioned table could be looking like this:
+--+--+--+--+-+---
| a| b| da
Hi,
I have this table where the columns and rows are organized like this:
+--+--+
| a| b|
+--+--+
|1 |1 |
|2 |1 |
|2 |2 |
|2 |3 |
|2 |4 |
|3 |1 |
|3 |2 |
+--+--+
I want to run a select that gives me one row fo
"Andrew Pattison" <[EMAIL PROTECTED]> wrote:
>
>> I have a strange problem with MySQL 4.0.15 . When I delete an entire
> table,
>> then run a repair on that table, it recovers all the rows which I just
>> deleted! Also, if I do a "check table" I can see that the files on disk do
>> not appear to h
Quoting Roman Neuhauser <[EMAIL PROTECTED]>:
> # [EMAIL PROTECTED] / 2003-09-25
> 14:59:33 +0100:
> > CREATE TABLE `pheno` (
> > `id` smallint(5) unsigned NOT NULL
> auto_increment,
> > `relevant` enum('y','n') default NULL,
> > `phenotype` varchar(50) NOT NULL default
> '',
> > PRIMARY KE
41 matches
Mail list logo
