Re: Installing on OS X without installer

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 X

Looking for libmysqld.dll (embedded server) for MySQL 4.1.1 on Win2k

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:http://lists.mysql.com

Re: copying longblob value to another table...

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

Re: 'group by' does a free 'sort by'?

It's right there in the manual : | 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 speci

Re: 'group by' does a free 'sort by'?

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?

'group by' does a free 'sort by'?

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 Kas

Re: Installing on OS X without installer

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

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 X. Can anyone help me on how to install without the installer. best regards -- *-*-*-*-*-*-*-

Re: Database loses rows from the 'mysql' permissions database when restarted.

[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:

Re: Subtracting two Dates and getting days

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) http://dev.mysql.com/doc/mysq

Database loses rows from the 'mysql' permissions database when restarted.

>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.

Re: Subtracting two Dates and getting days - SOLVED

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 Mail

Subtracting two Dates and getting days

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]

Drop & Rebuild Index Failure

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 < dropIndex.s

Re: MySQL performance on FreeBSD compared to Linux

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. >

Access denied for user: 'root@localhost' (Using password: NO)

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 use

rpm packages for 4.0.20 (compat-libs)

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 a

Re: Links to myisam database files

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 fa