On Fri, May 21, 2004 at 08:01:31PM -0400, [EMAIL PROTECTED] wrote:
Luis - you're quite polite so I'll assume that you are ignorant rather than
prejudiced.
I'm polite since I wanted to be respectful but honest at the same time.
You have a university email so I'll also assume you're a student
Hi all,
I'm using 3.23.49a-max-log and as a temporary fix for a disk space
problem, I shut mysql down,, moved some database files to different
partitions on the system and symlinked them back into the datadir.
Everything seems to work ok... So far... Mysql came up with no errors,
selects and
In the last episode (May 22), Bruce Ferrell said:
I'm using 3.23.49a-max-log and as a temporary fix for a disk space
problem, I shut mysql down,, moved some database files to different
partitions on the system and symlinked them back into the datadir.
Everything seems to work ok... So far...
Hey folks,
just wanted to upgrade from 4.0.18 to 4.0.20 but found the following.
The Dynamic client libraries (including 3.23.x libraries) are still 4.0.18 ...
does that mean that they don't NEED to be changed or were they just forgotten?
TIA,
Thomas
--
MySQL General Mailing List
For list
Hello,
I would be happy to solve the following problem :
I get every week the following message on my Linux root mail account :
/etc/cron.daily/logrotate:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for
On Sat, May 22, 2004 at 11:25:54PM -0500, mos wrote:
Once I wiped this and tried Linux (both gentoo, with their
patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which
had just been released by the time I installed) this figure jumped to
35,000 queries per second.
First of
Once a week, we run a script to drop all the indexes on tables in our
db, followed by another to add those indexes back (we insert every
day, so we do this to prevent index fragmentation).
The database is named BX, and the script runs these two commands:
c:\mysql\bin\mysql BX
Hi,
How can I subtract two dates and get the number of days?
(date1 - date2) = days
Thanks.
--
Andre Matos
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
I found a function named TO_DAYS that solved my problem.
Thanks.
Andre
On Sun, 23 May 2004, Andre MATOS wrote:
Hi,
How can I subtract two dates and get the number of days?
(date1 - date2) = days
Thanks.
--
Andre Matos
[EMAIL PROTECTED]
--
MySQL General Mailing List
Description:
Every time I restart the database engine it loses grant entries, and I have
to manually reenter them by hand. Why aren't there rows finding their
way to disk?
How-To-Repeat:
Add some grants, restart the database.
Fix:
I don't know of a fix.
Andre MATOS [EMAIL PROTECTED] wrote:
How can I subtract two dates and get the number of days?
(date1 - date2) = days
Take a look at TO_DAYS() function:
SELECT TO_DAYS(date1) - TO_DAYS(date2)
or DATEDIFF() function (supported from 4.1.1)
[EMAIL PROTECTED] wrote:
Description:
Every time I restart the database engine it loses grant entries, and I have
to manually reenter them by hand. Why aren't there rows finding their
way to disk?
How-To-Repeat:
Add some grants, restart the database.
Fix:
Hi,
I've just downloaded the latest version of MySQL (4.0.20) for OS X.
They seem to have omitted the installer - there's no .dmg file to
download. The manual only covers installing from the .dmg for OS X.
Can anyone help me on how to install without the installer.
best regards
--
On May 23, 2004, at 3:30 PM, Chris Curnow wrote:
I've just downloaded the latest version of MySQL (4.0.20) for OS X.
They seem to have omitted the installer - there's no .dmg file to
download. The manual only covers installing from the .dmg for OS X.
I think you must have just missed it. There's
Hi all.
I've noticed that if I do a 'group by xxx' I get the results sorted by
xxx ( when I'm only grouping on 1 field ).
It seems to happen that way every single time.
Is this faster than doing both a 'group by' and 'sort by', and is it
something I can rely on?
Just curious...
Dan
--
Daniel
At 06:29 PM 5/23/2004, you wrote:
Hi all.
I've noticed that if I do a 'group by xxx' I get the results sorted by xxx
( when I'm only grouping on 1 field ).
It seems to happen that way every single time.
Is this faster than doing both a 'group by' and 'sort by', and is it
something I can rely on?
It's right there in the manual http://dev.mysql.com/doc/mysql/en/SELECT.html:
| If you use GROUP BY, output rows are sorted according to the GROUP BY
| columns as if you had an ORDER BY for the same columns. MySQL has extended
| the GROUP BY clause as of version 3.23.34 so that you can also
Hello,
Thanks for the reply, I will check out the mentioned links. I hope I
will get my answers there.
Regards,
Abubakr
- Original Message -
From: Michael Kruckenberg [EMAIL PROTECTED]
To: Abubakr [EMAIL PROTECTED]
Cc: MySql Mail List [EMAIL PROTECTED]
Sent: Friday, May 21, 2004
I've have been looking for libmysqld.dll so I can test the MySQL embedded
server on my Win2k machine. Where can I download it? I've searched
www.mysql.com to no avail. TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
At 08:30 +1000 on 05/24/2004, Chris Curnow wrote about Installing on
OS X without installer:
Hi,
I've just downloaded the latest version of MySQL (4.0.20) for OS X.
They seem to have omitted the installer - there's no .dmg file to
download. The manual only covers installing from the .dmg for OS
20 matches
Mail list logo