Try:
rpm -Uvh mysql-version-etc ...
this will upgrade your mysql instead of installing the new one ..
Else what you can do is:
rpm -e mysql (remove mysql installation)
rpm -ivh mysql (install the new mysql version)
Grtz.
Luuk
On 24 Dec 2002 at 15:29, ECTeo wrote:
> When I try to install MySQ
When I try to install MySQL 4.0.6 by
rpm -i MySQL-VERSION.i386.rpm --force
Linux prompt me
MySQL conflict with Mysql-3.23.49-3
How to solve the problem?
-
Before posting, please check:
http://www.mysql.com/manual.
sir,
i would like to generate reports using mySQL but
unable to get any information related to it
could u please help me out or give some name of the
sites that will get me to get some solution
regards
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerf
Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£
ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ
ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǺͿռä
Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨Ñ¹µ¹Ò»
Is there any explination as to how this could happen. I had two fields that
somehow showed up as tinyint when they must have started out as char or
varchar. I changed them to char and tested it by adding data which worked.
I was able to then pull the characters back out of the database
successful
arlier versions of 4.0.x
>
> mysql> delete from product_order_main;
> GIVES THIS
> Query OK, 0 rows affected (0.10 sec)
>
> AND RESETS THE AUTOINCREMENT VALUE
>
> mysql> insert into product_order_main values
> (null,'rcl1','hh','ab',
Jeremy Zawodny wrote:
On Mon, Dec 23, 2002 at 03:53:14PM -0700, Mark Stringham wrote:
I know the MySQL password( ) function is irreversible. I have also
been told that storing passwords in plain text is a bad idea. Can a
get a few suggestions of good ways to store passwords in the db?
Using M
"Michael T. Babcock" <[EMAIL PROTECTED]> wrote,
> But MySQL doesn't guarantee correctness in time values in the first
> place. You can still insert "2002-02-31" as a date if you like
If you store a date in the database as a unix_timestamp in an unsigned int
column, and retrieve the value using t
On Mon, Dec 23, 2002 at 03:53:14PM -0700, Mark Stringham wrote:
>
> I know the MySQL password( ) function is irreversible. I have also
> been told that storing passwords in plain text is a bad idea. Can a
> get a few suggestions of good ways to store passwords in the db?
Using MD5() is one of my f
I know the MySQL password( ) function is irreversible. I have also been told
that storing passwords in plain text is a bad idea. Can a get a few
suggestions of good ways to store passwords in the db?
Thanks
Mark
sql, query
-
B
Hi everyone,
I am having problems with my php+mysql driven site, running on a freebsd
box. Mysql tends to lock up once-twice a day (or even more) and stop
responding to queries.
OS is:
# uname -rs
FreeBSD 4.6.2-RELEASE
Database is:
mysql-standard-4.0.6-gamma-unknown-freebsd4.7-i386, binary do
Hi, you can use a DateTime field, but it is possible to get duplicate
datetimes if you insert multiple queries fast enough.
At 04:17 PM 12/23/2002 -0200, João Borsoi Soares wrote:
I would like to use a datetime field as a key. I'm wondering if I will
have any problems with key violation. I foun
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Lenny Sorey wrote:
I'm going to try this one more time. Just trying to keep my question at the top so someone will read it and possibly respond.
Sorry to be a bother, but I've been working on this problem for three days with no succcess.
I store the
How will NPTL (http://people.redhat.com/drepper/nptl-design.pdf) effect
MySQL?
Will MySQL break when linked against glibc 2.3.1 which has NPTL built in?
Will MySQL be able to take advantage of NPTL to allow more threads on
Linux systems.
Absolutely. Perl is pretty quick, but it's still not a static compiled
language.
We end up doing a lot of server side calculations with basic math, and then
using MySQL functions to turn it into text, but that isn't always possible.
In our case, we tend to err on the side of the clients doing mo
values
(null,'rcl1','hh','ab','pending','yes','20021223',now());
Query OK, 1 row affected (0.10 sec)
mysql> select * from product_order_main;
+-+-+-+-+-+-+---
-+---
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, December 23, 2002 8:14 PM
Subject: Re: SOLVED! (was: Re: What is wrong with this query?)
> >It seems that the parent exit-ing while the
> >child is doing
Matt Young wrote:
>My sql command pipes its result to a perl program (in batch mode) . but the
>perl program has no waf to tell when the query is finished.
>HTTP uses a blank line to signal the end. but there is no such thing for
>mysql.
Why can't you append an extra line to your sql result
In the last episode (Dec 23), Matt Young said:
> My sql command pipes its result to a perl program (in batch mode) .
> but the perl program has no waf to tell when the query is finished.
> HTTP uses a blank line to signal the end. but there is no such thing
> for mysql.
If you are doing something
What about the semi-colon (;) or (\g)?
JFernando
** sql **
-Original Message-
From: Matt Young [mailto:[EMAIL PROTECTED]]
Sent: December 23, 2002 12:53
To: [EMAIL PROTECTED]
Subject: What terminates a query?
My sql command pipes its result to a perl program (in batch mode) . but the
per
Csongor Fagyal wrote:
I personally prefer TAI64 time (sub-second precision; see
http://cr.yp.to/libtai/tai64.html). For a comparison of how this
differs from UNIX time, see http://cr.yp.to/proto/utctai.html at the
same site. I'm surprised SQL hasn't been updated to support new time
formats
I do not understand why. It seems that the parent exit-ing while the child
is doing stuff, makes the child lose its query to MySQL (always more or less
at the same point). And this is really strange; for the parent has nothing
to do with MySQL. It is the child who makes the connection and does al
I personally prefer TAI64 time (sub-second precision; see
http://cr.yp.to/libtai/tai64.html). For a comparison of how this
differs from UNIX time, see http://cr.yp.to/proto/utctai.html at the
same site. I'm surprised SQL hasn't been updated to support new time
formats yet, but oh well.
Well,
> Can anyone share and/or comment about the use of Epoch time,
> especially the hazards?
Using timestamps you can synch all your times with the server via
'now()' and the like. If you use the epoch time on the client side you
might have problems. What those problems are, I couldn't say- but I h
I'm going to try this one more time. Just trying to keep my question at the top so
someone will read it and possibly respond.
Sorry to be a bother, but I've been working on this problem for three days with no
succcess.
I store the result(s) of a multiple select listbox in a MySQL version 4.0.2
On Monday 23 December 2002 03:05, Ray Kiddy wrote:
> I had used MySQL's myisampack utility to pack my tables, which makes
> them read-only, but now I want them to be write-able again.
>
> I have used "myisamchk --recover --unpack" (tried -ru as well) and the
> table is still read-only.
>
> What is
I would like to use a datetime field as a key. I'm wondering if I will
have any problems with key violation. I found in the document something
saying that timestamp fields are precise, like unix time, but I don't
want it to be changing on update. Does anyone has some experience with
it?
Thanks,
J
My sql command pipes its result to a perl program (in batch mode) . but the
perl program has no waf to tell when the query is finished.
HTTP uses a blank line to signal the end. but there is no such thing for
mysql.
-
Before po
> -Original Message-
> From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
> Csongor Fagyal wrote:
>
> > Oh and one more thing I am not really sure of: sometimes
> defining the
> > day as 3600*24 or the year as 3600*24*365 is not the best
> idea... just
> > think about leap
You want to look at 'group by acctSrv.accountID' rather than a compound
select.
On Mon, 23 Dec 2002, Adam Nowalsky wrote:
> Date: Mon, 23 Dec 2002 09:04:32 -0500
> From: Adam Nowalsky <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: sql help
>
> hi, wonder if the sql gurus can help with
I am attempting to build the latest version of MySQL on a HP-UX 11.00 system
but I have run into on problem over and over again. Once the service is
built, I run the make test command and the process fails at the "rpl01"
step and the test ends with an error code. I go ahead and test the install
>Description:
The table is corrupted after DELETE FROM ; command:
There is one table called tmprecord in my database used as temporary table
and for serialisation of changes in another table.
It's used under following schema only:
LOCK tmprecord as tmprecord WRITE, (loc
Interesting. How's the language support for TAI64? One of the nicest
things about Epoch time is that any Perl or C (and many other) program
anywhere (on UNIX!) knows how to turn that int into a time-zone aware
human-readable string.
Cheers.
-Dana
> -Original Message-
> From: Michael T.
Date/Time is such a tricky thing. I think that's we migrated toward the
simplest solution in the first place.
For days/weeks/months, I think the math cited below works pretty well. That
is, if we're not talking about calendar months. As soon as we need to query
based on calendar things, we tend
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 23, 2002 3:13 PM
Subject: What is wrong with this query?
> For month now I have been plagued by the "Lost connection to MySQ
> server during query" in a Perl program of mine that connects
On Saturday 21 December 2002 15:14, Paul P Komkoff Jr wrote:
> I tracked down the bug
>
> I have one table with BLOB field in it
> Then I execute queries like
>
> SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))
>
> here, keywords is a blob fields
>
> when (LOWER(keywords) LI
On Monday 23 December 2002 06:15, Andrew Schaefer wrote:
> I am having problems getting mysql working. I used the rpm packages to
> install the mysql and mysql-max. It seems like they are running because
> when I use telnet to try to connect to the port 3306 all I get is a message
> saying E Hos
On Monday 23 December 2002 17:54, Robert Berman wrote:
> SELECT Company_ID,
> COUNT(*)
> FROM Eric
> GROUP BY Company_ID;
> ++--+
> | Company_ID | COUNT(*) |
> ++--+
> | NULL | 10 |
> ++--+
1 row in set (
On Monday 23 December 2002 12:41, Akash wrote:
> I want to store NULLS or '0' in a column which is of type
> TimeStamp.
> According to MySQL implementation, if I give the default value of the
> column during table creation as NULL, it will store the current time in the
> timestamp colu
On Monday 23 December 2002 13:11, Ganesh Rajan wrote:
> iam facing a problem or situation that i have installed mysql 3.23.52 on
> Windows 2000 server..which will be my master... i want to setup my slave
> server which will be on RedHat Linux 7.1 with mysql 3.23.49...
>
> can anyone help me out on
On Monday 23 December 2002 04:20, luc2 wrote:
> Hello, I have FULLTEXT Indexes on 2 columns, Entry and EntryCountry. ( See
> Below )
>
> mysql> show index from entries\g
> +-++-+--+---+--
>- +-+--++
Gloria L. McMillan wrote:
I recently posted this query and it doesn't seem to be getting any responses.
Is there something important that I left unsaid, making this one tough to
answer or is it, perhaps, not addressed to the right list?
I'm sure you could find a full app that already does thi
Csongor Fagyal wrote:
Oh and one more thing I am not really sure of: sometimes defining the
day as 3600*24 or the year as 3600*24*365 is not the best idea... just
think about leap years. How do you handle that? And there are some
more "artifacts" in the Gregorian calendar, too...
But MySQL d
Dana Diederich wrote:
Can anyone share and/or comment about the use of Epoch time, especially the
hazards? I'm asking because I want to make sure that I haven't built a
comfortable little box that un-necessarily excludes some useful functions.
I use Epoch time myself, except where I use TIME
Hi. I noticed a couple of weird things with your script:
- The error "DBI->connect(myd) failed: Couldn't connect to..." is
happening I think because 'DBI:mysqlPP:myd' is in single quotes when you
call DBI->connect, and the syntax seems off. Maybe you'll have better
success if you follow the syn
Hi
Please, how can I do to make a table from a file.txt or to copy
postgresql's dumpfile?
Thank in advance
bruper
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Try doubling up your forward slashes so that they stop being special
characters.
c:\temp -> c:\\temp
-bill
Lisa He wrote:
Hi,
I have a question with regards to Load data infile...
I have a .txt file containging only path names e.g " C:\temp " in the
bodytext. this file is imported into the
>Description:
The mysqlhotcopy manpage suggests giving the password via the command
line option '--password'. This is higly insecure as every system user
is able to read it.
>How-To-Repeat:
RTFM ;-)
>Fix:
Please apply the following patch:
--- mysql-dfsg-3.23
Dana Diederich wrote:
This is a related but different question/comment.
In the six or so years of using MySQL, my various teams have never used
anything except an unsigned INT and UNIX Epoch time to record timestamps.
The given is, of course, we have always been a Perl/C/C++/UNIX shop, and we
wi
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject:Bug with CASE expression in Update statement
>Description:
CASE WHEN expres
I think you need the ODBC driver for plain text files to do so. It is
generally installed in Win32, but I do not know about Linux. As to use
MyODBC for that, I do not think it will work.
HTH
JFernando
** sql **
-Original Message-
From: Nikola Pentchev (ESA) [mailto:[EMAIL PROTECTED]]
S
This is a related but different question/comment.
In the six or so years of using MySQL, my various teams have never used
anything except an unsigned INT and UNIX Epoch time to record timestamps.
The given is, of course, we have always been a Perl/C/C++/UNIX shop, and we
will be for a long time, a
Hi,
I have a question with regards to Load data infile...
I have a .txt file containging only path names e.g " C:\temp " in the
bodytext. this file is imported into the DB using load data infile.
However, when i do a "select * " on that table which i've just imported,
the result looks like thi
Hi, all,
I recently posted this query and it doesn't seem to be getting any responses.
Is there something important that I left unsaid, making this one tough to
answer or is it, perhaps, not addressed to the right list?
I would like to redo my CREATE TABLE very much to allow me to do
more efficie
On 23 Dec 2002, at 16:11, Akash wrote:
> According to MySQL implementation, if I give the default value of the column
> during table creation as NULL, it will store the current time in the
> timestamp column. I do not want this "current time" to be stored in the
> timestamp column. I want it to be
For month now I have been plagued by the "Lost connection to MySQL server
during query" in a Perl program of mine that connects locally to
/tmp/mysql.sock.
Having taken everything apart, I have narrowed it down to this line:
$sth = $dbh -> prepare ("SELECT concat(newsgroup, ' ', stop, ' ', start,
hi, wonder if the sql gurus can help with this one. i have two tables
(simplified), tblAccounts and tblAccountsServices. tblAccounts has an ID
(PK) and an accountNumber, and tblAccountsServices has an ID (PK) and
accountID (FK to tblAccounts.ID). i want to run a query that gives me a row
for eac
> -Original Message-
> From: Mike Wexler [mailto:[EMAIL PROTECTED]]
> The best answer is, "try it and see." If your tables are
> small. Adding
> and removing indices is very quick. And testing queries is
> also very quick.
Enabling the slow query log, and enabling log-long-format can
hi,
I always have my problem and i didn't find any solution pour the moment.
Please, if somone have an idea ... :(
Thanks
David
Subject: [Error] Mysql server has gone away && 3.23.53a
Date: Thu, 19 Dec 2002 17:23:31 +0100
I've some problem with my Mysql servers since the beginning of this week.
Hi,
I was trying to upgrade my 3.23.52 MySQL to 5.23.54a using rpm -U. The
system just hangs. (I am running RedHat 8.0)
This is what I get running a strace on rpm -U MySQL-whatever:
[...]
stat64("/", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
stat64("/var/", {st_mode=S_IFDIR|0755, st_size=40
I've upgraded to 4.0.6 and now MyODBC does not function properly when it
used to work fine with 4.0.1. When I try to open a linked table in
Access I get the error:
ODBC--Call Failed
[MySQL][ODBC 3.51 Driver][mysqld-4.0.6*gamma-nt]Access denied for user:
'@(My IP)' to database '(Database name here)
hi gurus,
iam facing a problem or situation that i have installed mysql 3.23.52 on
Windows 2000 server..which will be my master... i want to setup my slave
server which will be on RedHat Linux 7.1 with mysql 3.23.49...
can anyone help me out on this
Thanks in advance
Ganesh Rajan
-
Hi,
I want to store NULLS or '0' in a column which is of type
TimeStamp.
According to MySQL implementation, if I give the default value of the column
during table creation as NULL, it will store the current time in the
timestamp column. I do not want this "current time" to be stored in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sun, 22 Dec 2002 [EMAIL PROTECTED] wrote:
> >Description:
> http://www.mysql.com/doc/en/Linux-x86.html
> says what to do to start MySQL on system boot in "Debian GNU/Linux".
> I don't know if this holds true for some of your
Hi,
I have a 3.23.52-3 MySQL RPM installed (I think it is a RedHat version)
and I would like to upgrade to 5.23.54a. What is the easiest way to do
this? Download the new RPM-s and make an update/freshen? Or should I
better remove the RPM and do a source install? What about my config
files, wil
Joe,
- Original Message -
From: ""Joe Smith"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, December 23, 2002 6:41 AM
Subject: Innodb querry optimizer suddenly making TERRIBLE choices? Urgent,
Please help!
> I'm in a bit of a tough spot -- My innodb table of WebA
Thanks for the link!
I was having some trouble figuring what keywords to search under ; )
At 11:43 PM 12/22/2002 -0800, Jeremy Zawodny you wrote:
On Mon, Dec 23, 2002 at 02:41:03AM -0500, Michael She wrote:
> Hi,
>
> Is the \ character a delimited in MySQL? I noticed in text inserts I have
>
67 matches
Mail list logo
