At 09:40 14/08/2001 -0600, Dan Haynes wrote:
Hi!
This problem will be fixed in the next release
Win32 3.23.41. Instead of integer will use float
number and a handle exception to avoid the box
message error when a not valid value is retrieved
from the server.
Regards,
Miguel
>Having trouble with
> My ISP provides me with a MySQL database. I have installed MyODBC and MySQL
> on my Windows2000 machine. Can you tell me if its possible to replicate the
> database to my own computer, make changes and these be replicated back to
> the database hosted by my ISP ?
You will have to do it manual
> This is after a mysqld restart -- It restarted, but didn't work because
> this single mysqld process wouldn't die. I even tried to kill it "kill
> 24424" and it still wouldn't go away -- not letting me restart mysqld.
>
> What is going on here?
kill -9 24424
i.t
---
Hi,
I have a table with approx 500 encrypted users passwords, and I need to
insert {crypt} at the beginning of each one ->
eg..
Sample password:
$dfij98unoc8jew9048urf
would become:
{crypt}$dfij98unoc8jew9048urf
Any suggestions are greatly appreciated.
Regards,
Michael
Thank you
- Original Message -
From: "Grigory Bakunov" <[EMAIL PROTECTED]>
To: "Lists Servers Email" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 11:16 PM
Subject: Re: Linux to NT
> Date |Tue, 14 Aug 2001 22:55:47 -0700
> From |"Lists Servers Email" <[EMA
Ok here's the current method I'm using to find non-distinct records in a
table:
1) SELECT DISTINCT column1 FROM table WHERE column2='something'
2) I get an array and mash it together [PHP: $biglist =
"'".implode("','",$column)."'";]
3) SELECT column1 FROM table WHERE column1 NOT IN($biglist);
Date |Tue, 14 Aug 2001 22:55:47 -0700
>From |"Lists Servers Email" <[EMAIL PROTECTED]>
Hello!
LSE> Is it possible to Replication from Linux database to NT?
Yes it's possible. Read about it here
http://www.mysql.com/doc/R/e/Replication.html
___
Tuesday, August 14, 2001, 3:47:19 PM, Michael T. Babcock <[EMAIL PROTECTED]>
wrote:
>> Does anybody knows a way to write a helper script to detach
>> misbehaving daemons from tty on startup?
> I doubt its the 'right way', but I often use " < /dev/null > /dev/null"
> to redirect standard input an
Is it possible to Replication from Linux database to NT?
Thanks Kevin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
Date |Tue, 14 Aug 2001 10:43:36 +0100
>From |"Mariusz Muszalski" <[EMAIL PROTECTED]>
Hello!
MM> Look at this MS SQL:
MM> Declare @BF char(10)
MM> Declare @BL char(10)
MM> SET ROWCOUNT 1
MM> Select @BF=Date From Results Where GameID=1 Order by Date ASC
MM> Select @BL=Date From Results Where Gam
>Description:
I am using the recommended ./configure options as specified by:
http://www.mysql.com/doc/S/o/Solaris.html. I am unsure how to
specifiy the GNU ld - the output from ./configure shows that I am
using the Solaris ld. Perhaps that is the problem? I run
Date |Tue, 14 Aug 2001 12:50:20 +0200
>From |"Sylvain BARTHELEMY" <[EMAIL PROTECTED]>
Hello!
SB> Hi,
SB> How can I add a new type to MySQL ?
If you mean column types then no, you can't but i think
in mysql we have all column types for all needs.
__
Date |Tue, 14 Aug 2001 23:19:51 +0800
>From |Kenneth <[EMAIL PROTECTED]>
Hello!
K> Hello mysql,
K> I'm trying to install mysql from source in a redhat 7.1 machine but
K> got the following errors(under section 'compile status'). I tried the
K> same in my redhat 7.0 without any problem. Please g
Date |Tue, 14 Aug 2001 11:47:16 -0500
>From |"Faine, Mark" <[EMAIL PROTECTED]>
Hello!
FM> GCC:
FM> Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.0/specs
FM> Configured with: ../configure --disable-nls --disable-libgcj
FM> --enable-languages=c++,f77,objc
FM> Thread model: posix
Date |Tue, 14 Aug 2001 16:19:13 -0500
>From |"Vien Huynhle" <[EMAIL PROTECTED]>
Hello!
VH> BlankI am getting this error when trying to install mysql
VH> checking for tgetent in -lncurses... no
VH> checking for tgetent in -lcurses... no
VH> checking for tgetent in -ltermcap... no
VH> checking fo
Date |Tue, 14 Aug 2001 21:12:50 -0600
>From |"s. keeling" <[EMAIL PROTECTED]>
Hello!
SK> Please suggest some newsgroups I can monitor to help me learn mysql?
SK> Thanks. I've done the 'L' thing with slrn and *sql*, and this
SK> mailing list shows up. :-)
SK> I've just spent a very enjoyable w
> > > > my $dbh = connect("DBI:mysql:database:localhost", "user",
> "password");
Well I uncovered an interesting thing. If I use the regular old
bin/mysql client to connect to the database (both on the same machine)
and I run: ./mysql -uroot -p -h localhost
Then run netstat -an , it sho
you should Managing Users with PHP Sessions and MySQL
as per this tutorial:
http://www.webmasterbase.com/article.php?aid=319
then you will always have the $userid or $uid (or whatever you wanna call
it )from LOGIN when you need it as a key to restrict a given mysql user to
access only those rows
Please suggest some newsgroups I can monitor to help me learn mysql?
Thanks. I've done the 'L' thing with slrn and *sql*, and this
mailing list shows up. :-)
I've just spent a very enjoyable weekend with mysql and perl DBI. Way
cool. I've been looking forward to this for too long.
I hope thi
Naturally, the answer is: it depends.
What is your application supposed to do? What languages are you versed in?
Does your data need to be accessible via the web?
At the very least, you will be needing the ODBC driver for MySQL, MyODBC.
It's available from the MySQL web site. Other than that, ke
SORRY FOR ANY CROSS POSTING
Dear All,
I have a plan to build a database application using mysql as it database
engine
What is the best development tools if I using a Microsoft NT environment.
I'll be happy if you share your experience
Regards
Christian
--
On Tue, Aug 14, 2001 at 10:11:30PM +0100, Neil Tompkins wrote:
> Hello,
>
> My ISP provides me with a MySQL database. I have installed MyODBC
> and MySQL on my Windows2000 machine. Can you tell me if its
> possible to replicate the database to my own computer, make changes
> and these be replic
On Tue, 14 Aug 2001 [EMAIL PROTECTED] wrote:
>I used mysqladmin to create a database and set the grant properties to
>root@localhost with the password, but now am unable to use mysql at all.
>How can I rectify this problem? When I try to access mysql I get
>'Access denied for user root@localhost'
.1 can not be represented exactly on a binary machine. there must be an
approximation stored in the fractional bits of the floating point
representation. there are more fractional bits in a double than in a float.
so the approximation is better. see the user manual for exact sizes.
At 12:51 PM
On Tue, 14 Aug 2001, Gerald Clark wrote:
>You are connecting TO host www.4cdg.com, but the permission table entry
>list the hosts you connect FROM.
>
Actually, it is just one host...I am running on FreeBSD and I have
to specify the hostname on the command line.
>You need to grant privileges to
Dunno if this will help or not, I'll just throw it out for consideration.
I'm just learning PHP, Javascript etc. and tend to make a lot of mistakes in
my scripts at this point.
When I write a script that executes a binary on the Apache server (NT 4.0
SP6a) and it goes off into na-na land, I ter
> >>Thanks for all the replies, I have followed the instructions in the
> manual
> >>and am still getting
> >>an error, here is the message:
> >>---
> >>simrad_4# safe_mysqld --skip-grant-tables &
> >>[1] 57953
> >>simrad_4# Starting mysqld daemon with datab
Earlier I told you all about the mysqld problem I had with my dual-athlon server.
Well, more hunting and I find this:
6:26pm up 4:55, 1 user, load average: 3.05, 28.62, 26.85
106 processes: 103 sleeping, 3 running, 0 zombie, 0 stopped
CPU0 states: 28.
Werner Stuerenburg <[EMAIL PROTECTED]> on 08/14/2001 11:55:37 PM
Internet mail from:
Please respond to Werner Stuerenburg <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: I blew it big time... locked myself out of mysql
I think it is
grant all on *.* to 'root'@'localhost' id
At 16:41 Uhr -0400 14.8.2001, Hans Zaunere wrote:
>sort of thing. Would it be better to just switch to TCP/IP sockets?
>
> > > my $dbh = connect("DBI:mysql:database:localhost", "user", "password");
Well it seems like you ARE using INET TCP/IP sockets, since there is
'localhost' there (which go
Which Linux 7.0 are you using?
I'll assume you're talking about Redhat. So why don't you just download
the mysql rpm and install it instead of doing it from source?
Good luck,
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
--
I'm relatively new to MySQL and am drawing up some ideas for writing a
support/trouble tracking database for my company. I envisioned a single
database with seperate tables for various data I would be storing
(IP/Connection info table, Machine Inventory Table, etc). Each table would
have data for
On Tue, 14 Aug 2001 13:39:48 -0700, "Nate Sanden" <[EMAIL PROTECTED]>
wrote:
>>Hey im pretty new to mysql, but I made a basic html form and used php to post it to
>my mysql database. It goes in fine, but it only carries the first word in each input
>box. So say for "description" I put in "My li
post some code. Make sure you're using quotes in the right places.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 14 Aug 2001 13:39:48 -0700
"Nate Sanden" <[EMAIL PROTECTED]> wrote:
> Hey im pretty new to mysql, but I made a basic html form and used p
Hello,
My ISP provides me with a MySQL database. I have installed MyODBC and MySQL
on my Windows2000 machine. Can you tell me if its possible to replicate the
database to my own computer, make changes and these be replicated back to
the database hosted by my ISP ?
Thanks for any help
Neil
--
Title: Blank
I am getting this error when trying to install mysql
# ./configure --with-low-memory --prefix=/usr/local/mysql loading
cache ./config.cachechecking host system type...
i586-pc-linux-gnuchecking target system type...
i586-pc-linux-gnuchecking build system type... i586-pc-linux
>>I am very new to the encrypt and decrypt data process and would like
to know how do I able to encrypt a string and store to MySQL and retrieve
the data and decrypt it at the later time.
Grab a copy of mcrypt (search http://freshmeat.net/ for it) and read
the docs for it -- its a good idea t
On Tue, 14 Aug 2001, Bruce Stewart wrote:
> How about a UNION query...?
Too bad MySQL doesn't support them yet ;)
-dave
/*==
www.urth.org
We await the New Sun
==*/
-
Before posting, please ch
Title: Blank
I am getting this error when trying to install mysql
# ./configure --with-low-memory --prefix=/usr/local/mysql loading
cache ./config.cachechecking host system type...
i586-pc-linux-gnuchecking target system type...
i586-pc-linux-gnuchecking build system type... i586-pc-linux-
[EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM
Internet mail from:
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: I blew it big time... locked myself out of mysql
On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PR
Hey im pretty new to mysql, but I made a basic html form and used php to post it to my
mysql database. It goes in fine, but it only carries the first word in each input box.
So say for "description" I put in "My little white dog" it only stores "My" in the
database. Would appreciate any insight
> Connect() does that for you.
> The mysql library handles the communication to the server.
> You just use the supplied functions.
> Are you sure it was sockets you were running out of?
Well the supplied functions have been used. How could I confirm that the system was
in fact running
out of so
I am trying to do a nested if, but it appears to break my query...
Here is a sample of what I am trying to, basically validating email
addresses out of a db:
select IF( (LENGTH( emailaddr ) <= 1 ||
NOT LOCATE( "\@",emailaddr ) ||
LOCATE( " ",emailaddr ),
(IF address.ts >= 2001081300,
Shu Xiao <[EMAIL PROTECTED]> writes:
> BTW, if I want to upgrade to new rpm version, what should I do.
> The RPM program will take care of upgrading itself?
If you get the new version of mysql in rpm format (eg. from Rawhide),
'rpm -Uvh mysql*rpm' should take care of it.
--
Trond Eivind Glomsr
At 12:33 AM 8/14/2001 -0400, Trond Eivind Glomsrød wrote:
>Shu Xiao <[EMAIL PROTECTED]> writes:
>
> > Hi,
> >
> > I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which
> > include MySQL rpm installation, I saw the file named mysqld under
> /etc/init.d .
> > I set up symlink
Adive, put the Spammer from the e-mail into an access file and
stamp reject next to it.
On Wed, Aug 15, 2001 at 01:14:25AM +, Dan Mitchell wrote:
> REAL MONEY
>
> Subject: Fw: .AS SEEN ON NATIONAL TV
>
>
> >
>
> >
> > > Subject:REAL MONEY
> > >
> > > Dear Friend & Fu
Thank You so very much. Your way was great, fast and efficient. Here is
my line of code:
insert into sub2 (email,list_id) select email, list_id from subscribers;
Thanks Again
Steve Buehler
At 03:31 AM 8/14/2001, you wrote:
>I'd do it this way:
>
>insert into table table_new
>select f
What is your /etc/my.cnf? Do you see mysql daemon running? (use ps -ef)
Maybe it is under /tmp/mysql.sock. You need to change the configuration
and restart server.
Shu
At 01:28 PM 6/1/2006 +0530, sachin wrote:
>Hello,
>I am working on RH Linux 7.0
>MySql is not working at all.
>My MySql file
Thank you for all your valuable help and input. I now got some idea to do
the job. Greatly appreciated.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Michael Tam" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 12:16 PM
Subject: Re: encrypt/decryp
On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PROTECTED] wrote:
>>Thanks for all the replies, I have followed the instructions in the manual
>>and am still getting
>>an error, here is the message:
>>---
>>simrad_4# safe_mysqld --skip-grant-tables &
>>[1] 579
Connect() does that for you.
The mysql library handles the communication to the server.
You just use the supplied functions.
Are you sure it was sockets you were running out of?
Hans Zaunere wrote:
> Ok. I didn't write these scripts, as they were in place when I arrived at this
>position, how
I have resolved this problem. The program doing the mysql_real_open had been
compiled with the thread library by a "cc -Kthread ..." compile. When
the -Kthread option was removed the problem went away.
- Original Message -
From: "Steve Rickard" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROT
Joel Fowler <[EMAIL PROTECTED]> writes:
> I've also reported this problem to Red Hat' Bugzilla as I understand
> they're responsible for the /etc/logrotate.d/mysql script. It's
> Bugzilla [Bug 51711] "Changed - MySQL looses bin-logs during
> logrotate".
3.23.41-1 uses a new method for flushing l
If all you're looking for is a trivial hiding of the data, then I'd
suggest doing a rot13 on the string. I highly doubt there is a native
SQL function that does this, so you'll need to write your own function
in whatever interface you're using. Perl/PHP/whatever.
Rot13 is a simple rotation of
Thanks for all the replies, I have followed the instructions in the manual
and am still getting
an error, here is the message:
---
simrad_4# safe_mysqld --skip-grant-tables &
[1] 57953
simrad_4# Starting mysqld daemon with databases from /var/db/mysql
simra
Michael,
I just did something like this, and used the ENCODE/DECODE. Works well.
Basically you want to assign a "special key" for the encoding/decoding of the
data you want to encode/decode. The column type should be either a BLOB or
TINYBOLD, as it's stored in a binary format, depend on the siz
REAL MONEY
Subject: Fw: .AS SEEN ON NATIONAL TV
>
>
> > Subject:REAL MONEY
> >
> > Dear Friend & Future Millionaire:
> >
> > AS SEEN ON NATIONAL TV:
> >
> > Make over a half million dollars every 4 to 5 months from your home for
an
> investment of only $25 U.S. Dollars on
I've also reported this problem to Red Hat' Bugzilla as I understand
they're responsible for the /etc/logrotate.d/mysql script. It's Bugzilla
[Bug 51711] "Changed - MySQL looses bin-logs during logrotate".
Joel Fowler
===
At 01:16 PM 8/14/01 -0500
No, unfortunately they just seem to be gone along with the integrity of
most good recovery strategies.
Joel Fowler
==
At 01:16 PM 8/14/01 -0500, Gerald Clark wrote:
>I don't recall ever losing a log.
>Are you sure logrotate isn't renaming it?
>
>Joel Fowler wr
Hi all,
I am very new to the encrypt and decrypt data process and would like to know how
do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it
at the later time.
I understood it sorts of contradict the point of security but I just want to use
it to cove
Ok. I didn't write these scripts, as they were in place when I arrived at this
position, however
from looking through them, it appears the actual connection to MySQL happens with
something like:
my $dbh = connect("DBI:mysql:database:localhost", "user", "password");
The above is a perl line.
These scripts should not be creating their own sockets.
The should be connecting to the one socket that the mysql server creates.
Hans Zaunere wrote:
> We have had a MySQL/Apache/Perl combo running fairly smoothly. However
> the other day MySQL seemingly went crazy, and brought the rest of the
I don't recall ever losing a log.
Are you sure logrotate isn't renaming it?
Joel Fowler wrote:
> I agree that Red Hat has an issue with safe_mysqld and logrotate.
> However, in my opinion MySQL has a much more serious problem.
> In a logging system there shouldn't be any subtle ways to drop reco
>Description:
mysql 3.23.41 doesn't build properly on IA32 with assembly and innobase enabled.
3.23.40 didn't have this problem
Configure statement in spec file ("%configure" is a standard rpm macro, specifying
CFLAGS and CXXFLAGS and various prefixes)
%configure --without-debug \
--wi
On Tue, Aug 14, 2001 at 10:14:58AM -0700, [EMAIL PROTECTED] wrote:
>
> I used mysqladmin to create a database and set the grant properties
> to root@localhost with the password, but now am unable to use mysql
> at all. How can I rectify this problem? When I try to access mysql
> I get 'Access den
I agree that Red Hat has an issue with safe_mysqld and logrotate.
However, in my opinion MySQL has a much more serious problem.
In a logging system there shouldn't be any subtle ways to drop records let
alone entire logs.
Kill -HUP is exactly that -- a very poor design leading to a
big trap - o
> Your query will work in every case, EXCEPT when either "Current" or
> "Temporary" has 0 rows, because then there's nothing to join. I'm not sure
> if doing a join is a "clean" way of doing this though.
>
> If you know that "Current" will never be empty (but "temporary" might be),
> then this que
> How about a UNION query...?
Hmm.. that construct is a little ugly for me - I think I'd rather just
issue two quick queries in each table. Thanks for the tip though.. I
missed that one.
> I've got two tables, "Current" and "Temporary", Current has a row with
> login='keric', Temporary doesn't.
This link, http://www.mysql.com/doc/P/r/Problems.html is a life-saver. Check
out A.9 for your specific problem.
Hans
[EMAIL PROTECTED] wrote:
> I used mysqladmin to create a database and set the grant properties to
> root@localhost with the password, but now am unable to use mysql at all.
>
We have had a MySQL/Apache/Perl combo running fairly smoothly. However
the other day MySQL seemingly went crazy, and brought the rest of the
system down; no sockets were available, even to ssh into. After a few
minutes, enough sockets were available to ssh into, however MySQL seemed
to far gon
Dave Jolly wrote:
>
> Hi,
>
> There seems to be a round-off problem with FLOAT.
>
> Here's a scenario to replicate it...
>
> <-->
> $ mysql
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1149 to server version: 3.23.41
>
> Type 'help;'
Your query will work in every case, EXCEPT when either "Current" or
"Temporary" has 0 rows, because then there's nothing to join. I'm not sure
if doing a join is a "clean" way of doing this though.
If you know that "Current" will never be empty (but "temporary" might be),
then this query would wo
Actually, I ran this test:
[root@dagger /root]# hdparm -Tt /dev/sda
/dev/sda:
Timing buffer-cache reads: 128 MB in 0.93 seconds =137.63 MB/sec
Timing buffered disk reads: 64 MB in 13.92 seconds = 4.60 MB/sec
And that does seem pretty bad, doesn't it? Is there optimization for SDA
like t
How about a UNION query...?
-Original Message-
From: Eric Anderson [mailto:[EMAIL PROTECTED]]
Sent: Tue, 14 August 2001 18:56
To: [EMAIL PROTECTED]
Subject: SELECT .. OR from multiple tables
I've got two tables, "Current" and "Temporary", Current has a row with
login='keric', Temporary
Sorry, but this system has quad 15K RPM SCSI hard drives running RAID 0+1.
I don't think hdparm applies to that.
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: "Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Ryan Shrout" <[EMAIL PROTECTED]
I used mysqladmin to create a database and set the grant properties to
root@localhost with the password, but now am unable to use mysql at all.
How can I rectify this problem? When I try to access mysql I get
'Access denied for user root@localhost'. I have tried, from the command
line, with -uroot
Hi,
There seems to be a round-off problem with FLOAT.
Here's a scenario to replicate it...
<-->
$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1149 to server version: 3.23.41
Type 'help;' or '\h' for help. Type '\c' to clear the buffe
I've got two tables, "Current" and "Temporary", Current has a row with
login='keric', Temporary doesn't.
The following query:
mysql> select * from Current, Temporary where Current.login='username'
or Temporary.login='username'
-> \g
Empty set (0.01 sec)
obviously doesn't work. I want to k
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Arturs Aboltins writes:
>> From: [EMAIL PROTECTED]
>> To: [EMAIL PROTECTED]
>> Subject: MYSQL bug with if and datetime fields
>>
>> >Description:
>> In queries where datetime field is in "WHERE" condition, the same
Anybody seen this before:
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H
-I/export/home6/temp/mysql-3.23.41/include -DHAVE_RWLOCK_T -o mysqlbinlog
mysqlbinlog.o mini_client.o net_serv.o mini_client_errors.o
This just happened a second time today... that is the most frequent yet.
Please, you have got to help me on this!
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: "Ryan Shrout" <[EMAIL PROTECTED]>
To: "Tonu Samuel" <[EMAIL PROTECTED]>
Cc:
This is happening to me also!
I have a Dual P-III, 550, 896MB RAM.
Suddenly mysql says it has connections busy
most of them "LOCKED", and then suddenly they start working on all of them
at the same time. This creates a load average similar to .
Is this a problem related to Linux, or is it a MyS
You could use a separate flags table that contains the
parent record key, flag name, and flag value.
You can then add and delete flags at will.
Philip Mak wrote:
> I have an application that requires the storage of various flags (by
> "flag", I mean a variable that is either 1 or 0).
>
> What'
- Original Message -
From: "Ryan Shrout" <[EMAIL PROTECTED]>
To: "Tonu Samuel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 5:21 PM
Subject: Re: Mysql causing severe load problems on Dual-Athlon server?
> Update -- The problem I described happened again, an
Having trouble with e-mail servers this morning and not sure if my
subscription request made it. If this has been reported already or is the
incorrect mailing list for this issue, please excuse and point me in the right
direction.
Had a internet connection failure last night and due to what appea
I have a user on my system with a normal shell account, and a normal MySQL
account that owns a database.
How can this unpriviledged user back up his database using mysqlhotcopy?
I've run into two problems:
1. He has to login as the MySQL root user in order to be able to execute
"FLUSH TABLES".
Update -- The problem I described happened again, and this time I was able
to get the "mysqladmin processlist" done. Here are the results from that.
Can you help me find my problem based on this information?
Thank you!!
Here is the "top" header: 11:09am up 4 days, 20:15, 1 user, load
averag
Henry,
if you do not want to use transactional InnoDB tables,
add
skip-innodb
to your my.cnf or my.ini file.
If you want to use InnoDB tables, follow the instructions:
To use InnoDB tables you must specify configuration parameters in the MySQL
configuration file in the [mysqld] section of the
Hi,
I'm trying to connect to a mysql database from linux
using the driver mm.mysql-2.0.2-bin.jar. The connect
is successfull, but when I want to retrieve some
records from the database, I get the message
"error reading communication packets". Do someone has
an idea, what it can be?
Thanks and be
Hello mysql,
I'm trying to install mysql from source in a redhat 7.1 machine but
got the following errors(under section 'compile status'). I tried the
same in my redhat 7.0 without any problem. Please give me some ideas
on the following matters:
1. Should I update the gcc compiler using the upd
I have an application that requires the storage of various flags (by
"flag", I mean a variable that is either 1 or 0).
What's a good way of doing this? I've thought about two ways:
Method 1: Make a TINYINT column for each flag
I can use TINYINT NOT NULL datatype for storing each flag. The
disad
I've got a fairly simple MySQL system here using replication, one master
and one slave.
Looking at the system the other day and the database logs are sure building
up. Is there
any standard way ("best practice") - preferably automated - to keep these
under control?
If not, I've have a go at doi
How to translate this to mySQL:
--
IF NOT EXISTS
(
Select Number From Results Where GameID=1
)
begin
INSERT INTO Results
(
GameID,
Date,
Number
)
VALUES
I noticed from the archives that some people had problems
configuring the MySQL source. They were getting the same
error message as I was getting, about termcap and curses
libraries being missing, but nobody seemed to work out
exactly what was wrong or what needed installing.
On Linux Mandrake 8
Now again I want to tell sorry to everyone who was shoked by my letter
which told that we do not give answers without money.
The truth is that MySQL developers have about 20 different mailing lists
to read in priority order. We have mailing list for people who pay for
support and their mails get
I have two servers running mysql on UnixWare 7.1.1. The 1st (uwdev1) is on
level 3.22.25 and has been running for more than a year with no problems at
all. The 2nd (sqlsrv1) is new and is running 3.23.39. The same databses are
on each server. Eventually all mysql databases will be on the sqlsrv1
s
MySQL does not support multi table updates yet either.
Yosi Oren wrote:
> Hi,
> You are trying to use nested select for that update wich MySQL do not
> support insted use :
> update table set field = value from table inner join table where bla = bla
> .
>
> Sincerely,
>
To avoid the "Fatal Embrace" where two users each lock a table, and
then attempt to read the table the other locked, you must lock
all table you intend to use for the duration of the lock.
The manual clearly states that a subsequent lock or unlock command
will first unlock all the tables you curre
This really is not a MySQL issue, but a Red Hat issue.
Don't logrotate the MySQL bin logs.
Joel Fowler wrote:
> Environment: Red Hat 7.1
> mysqld 3.23.36-log
>
> /etc/my.cnf as follows:
>
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
1 - 100 of 128 matches
Mail list logo
