Query Question

Clausen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Limit Which IP Address MySQL Answers On

I'm running MySQL 3.23.58 on a Win2k server with multiple IP addresses and I'm wondering whether there is a way to limit the MySQL server to answering on just one IP address. -- A. Clausen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Cygwin Compiled Version of MySQL Client

that outpouts with just line feeds. -- A. Clausen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Cygwin Compiled Version of MySQL Client

[EMAIL PROTECTED] wrote: A. Clausen [EMAIL PROTECTED] wrote on 02/07/2005 01:35:31 PM: I'm having a problem with the default Win32 mysql client program running in the Cygwin environment, in that it writes CRLF pairs out, causing some Bash scripts that I'm running on both a Linux box and a Win2k

Re: Problems Moving from 3.23 to 4 (Win2k)

Victor Pendleton wrote: A. Clausen wrote: I made a copy of my entire Mysql 3.23 data directory and moved it on to a box with a fresh install of MySQL 4. While the NT service starts up fine (I'm using 4.0.22-nt-max), I can't login. I know that there are supposed to be mods made to the mysql

Problems Moving from 3.23 to 4 (Win2k)

there was at least a minimum compatibility. The only way to get access to anything is to shut down MySQL, put in the default table that came with the install. What am I doing wrong here? -- A. Clausen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Upgrading from 3.23.58 to 4.1

Joshua J. Kugler wrote: Take a look at http://mysql.he.net/doc/mysql/en/Upgrade.html Hmmm... Can 4.1 mirror a 3.2 server? That might be a good deal easier. -- A. Clausen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Upgrading from 3.23.58 to 4.1

I've been running, with great success, version 3.23.58 on my Win2k box for quite a while now, but am interested in moving up to 4.1. Is there any incompatiblities between the two versions, or any gotchas to the upgrade? -- A. Clausen [EMAIL PROTECTED] -- MySQL General Mailing List For list

MySQL Behind Firewall

We are running MySQL 3.23.58-max-nt and are preparing to put the server it's running on behind a firewall. What ports do I have to leave open to the outside world so that outside customers can still access their databases, run queries, manage databases, etc? -- A. Clausen[EMAIL PROTECTED

Tough Query Problem

for a couple of days ago had 1.2 million rejections). -- A. Clausen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tough Query Problem

- Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Aaron Clausen [EMAIL PROTECTED] Cc: MySQL Mailing List [EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 10:20 Subject: Re: Tough Query Problem In the last episode (Jun 16), Aaron Clausen said: I am trying to write a script

[Slightly OT] Tricky SQL Query

to do is to find out just how much traffic that unit has done in the month of February. I realize I will have to do one query to discover the byte counts for the last record in January, but beyond that I'm stumped. -- Aaron Clausen -- MySQL General Mailing List For list archives: http

Cygwin and Mysql Tools

I'm looking for the Cygwin-compiled ports of the Mysql tools mysql and mysqldump. There is an old version on the Mysql site, but being that it was compiled back in 1998, it does not function with the current versions of Cygwin. -- A.Clausen -- MySQL General Mailing List For list archives:

Re: Creating backups

(I've only seen it take that long when things have been pretty busy). -- A. Clausen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

IP Address Operations in MySQL

I'm running 3.23.49 on a Win2k machine and wonder if anybody has some advice on how to write queries dealing with IP addresses. Specifically, I have a table with an ip address field. I want to be able to do queries based on subnet. Has anybody got anyting like this? -- Aaron Clausen [EMAIL

Re: Backups mechanism

database and pipe it into a test database. I found mysqldump to have a bit of a learning curve, but I could not survive without it now. -- Aaron Clausen - Before posting, please check: http://www.mysql.com/manual.php

Re: Backups mechanism

. Even better, mysqlbackup generates SQL files, which, with a little manipulation, can be imported into other database systems. -- Aaron Clausen - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Can MySQL handle 120 million records?

in the next six months. But MySQL has been rock solid. I have lost no data, save through my own stupidity, at any point. I would recommend it without reservations. -- Aaron Clausen - Before posting, please check: http

RE: Offer to Help MySQL Win32 Port -- Passing Command Parameters

. In other words, the rule of thumb should be Keep it simple, stupid. -- Aaron Clausen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Accessing MySQL Using ASP

% A. Clausen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: Replication Problem on MySQL 3.23.45/Win32

The replication server functions perfectly, but the slaves are not updating. A. Clausen [EMAIL PROTECTED] - Original Message - From: Miguel Angel Solórzano [EMAIL PROTECTED] To: A. Clausen [EMAIL PROTECTED]; MySQL Mailing List [EMAIL PROTECTED] Sent: Friday, December

Re: Creating MySQL table w/2 primary keys

I do it all the time, just go primary key c (a,b) A. Clausen [EMAIL PROTECTED] - Original Message - From: sherzodR [EMAIL PROTECTED] To: Demirchyan Oganes-AOD098 [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 06, 2001 11:58 Subject: Re: Creating

Replication Problem on MySQL 3.23.45/Win32

this? A. Clausen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Re: Replication Problem on MySQL 3.23.45/Win32

No, it is not directly supported, but, according to the manual, using the option use-symbolic-links and placing the file database_name.sym in the MySQL data directory, with a line pointing to the location of the database files, you fake it. A. Clausen [EMAIL PROTECTED

Re: MySQL 3.23 Manual - PDF

nowadays? A. Clausen [EMAIL PROTECTED] - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: A. Clausen [EMAIL PROTECTED] Cc: MySQL Mailing List [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 03:24 Subject: Re: MySQL 3.23 Manual - PDF On Wed, 28 Nov 2001

MySQL 3.23 Manual - PDF

Is there still a PDF-formatted version of the MySQL 3.23 manual available? A. Clausen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: MySQL 3.23 Manual - PDF

- Original Message - From: Tony [EMAIL PROTECTED] To: A. Clausen [EMAIL PROTECTED]; MySQL Mailing List [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 11:20 Subject: Re: MySQL 3.23 Manual - PDF Image you had a product and wanted to make a PDF manual available for your users

Re: MySQL 3.23 Manual - PDF

. A. Clausen [EMAIL PROTECTED] - Original Message - From: -BD- [EMAIL PROTECTED] To: A. Clausen [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 12:02 Subject: Re: MySQL 3.23 Manual - PDF Ive got a copy of the 3.23 PDF I'll be happy to e-mail you if you haven't found one

MySQL 3.23 Manual

Where can I find a copy of the latest MySQL 3.23 manual? All I've been able to find is the newer 4.x. A. Clausen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

MySQL/MyODBC and IMail

Has anyone had any experience using Mysql via MyODBC with Ipswitch's IMail mail server? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: Expiring Binary Logs

-- Original Message -- From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 7 Sep 2001 00:12:24 -0700 On Wed, Sep 05, 2001 at 01:33:03PM -0700, A. Clausen wrote: PURGE LOGS: http://www.mysql.com/doc/R/e/Replication_SQL.html

Expiring Binary Logs

I've been running a master/slave MySQL database system for about four months now and I've got nearly 360mb of binary logs. I want to archive anything over about a month old, but I've heard that there is a procedure that you have to go through to do that.

MySQL Error Codes

I'm developing some MySQL applications using VB6 and ADO, and need to do some work on error handling. I can get the error code easily enough from ADO's Error collection, but is there a list of error codes and their descriptions. I've been doing this by generating errors and seeing what codes

Upgrading mysql on Win2K

What is the process of upgrading v3.23.36 to 3.23.40 on Windows NT. Can I just install over top or is there some other steps that should be taken? I am running two mysql servers, one a master and one a slave. Does this make a difference?

Re: mysql.org

-- Original Message -- From: [EMAIL PROTECTED] Date: Fri, 13 Jul 2001 12:36:08 -0700 I am far from a legal expert on this... but is it all that bad that NuSphere wishes to sell a derivative work of MySQL? Other than it competes with MySQL AB's business

Best Column Type for Currency Calculations

I've been having some problems with currency calculations in SQL queries. I've been using Double, but often get some very small rounding errors. What is the recommended column type for currency in MySQL? Aaron - Before

mysqlbug

Hi! My name is Cathy and I have a problem after installing MySQL. I cannot get connection to the localhost. Whenever I type mysqld I get this message: C:\mysql\binmysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set. I'm using Microsoft Windows 98 and the version of MySQL is

Replication Slave to Master

How much difficulty is there in turning a MySQL replication server into a master?