Limit Which IP Address MySQL Answers On

2005-04-14 Thread A. Clausen
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://lists.mysql.com/[EMAIL PROTECTED]



Re: Cygwin Compiled Version of MySQL Client

2005-02-07 Thread A. Clausen

[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 box 
to give garbled results.  I wondered if there's a Cygwin compiled 
version that outpouts with just line feeds.
I may be wrong about this, but aren't you in a *nix environment when 
running inside Cygwin? 
Well, sort of.  It does some DOS to Unix text file translation, and 
generally when you use Cygwin-compiled programs and have the system set 
to LF-only, things work as they should.

Your Win32 compiled client binary may be working 
but shouldn't you be using a *nix compiled client from WITHIN Cygwin? I 
would try one of the other *nix-type client binaries (you may need to 
compile one from within Cygwin itself) to get your setup to work because I 
agree with you that the Win32 client is not going to cut it.
Well, I was hoping that someone had the "mysql" Cygwin binary.  I know a 
long time ago there was one, because when I was first testing MySQL on 
an old Win98 box, the MySQL distribution had one that worked because the 
native Win32 binary didn't have the editing keys function unless you 
were in WinNT.

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


Cygwin Compiled Version of MySQL Client

2005-02-07 Thread A. Clausen
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 box 
to give garbled results.  I wondered if there's a Cygwin compiled 
version 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: Problems Moving from 3.23 to 4 (Win2k)

2004-12-16 Thread A. Clausen
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 database tables, but I 
thought 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?
>
> What errors are being displayed when you attempt to log in? Is
> anything
> being written to the error log itself?
Nothing out of the ordinary that I can see.  It just simply doesn't seem 
to recognize 3.23's security settings.  If I replace the 3.23 mysql 
database tables with 4.1 stock ones, I can log in, but I don't want to 
have to re-enter all of this by hand.

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


Problems Moving from 3.23 to 4 (Win2k)

2004-12-10 Thread A. Clausen
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 database tables, but I thought 
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
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: Upgrading from 3.23.58 to 4.1

2004-12-08 Thread A. Clausen
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://lists.mysql.com/[EMAIL PROTECTED]


Upgrading from 3.23.58 to 4.1

2004-12-07 Thread A. Clausen
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 archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


MySQL Behind Firewall

2004-11-17 Thread A. Clausen
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]


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



Re: Tough Query Problem

2004-06-16 Thread A. Clausen

- 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 that can take logs from our mail
> > server, boil down the rejections to determine the sources of
> > distributed SMTP dictionary attacks against our mail server.
> > 
> > Basically I have a table "send_failures like this that gets fed with
> > the raw data from the logs:
> > 
> > host_ip date
> > ---
> > 111.111.111.110 2004-06-03 13:42:22
> > 
> > And so on and so forth.
> > 
> > Now it's trivial to write a query to find the pure counting of the
> > attacks: However, I also want to have latest date of the attack
> > included as well, so that the above exampe would boil down to a query
> > with results like this (I'm running MySQL 3.23.58):
> 
> Add "MAX(date) as last_attempt_date" to your select field list.

That did the job!  Thanks.

-- 
A. Clausen
[EMAIL PROTECTED]

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



[Slightly OT] Tricky SQL Query

2004-02-17 Thread A. Clausen
I am trying to construct what is proving to be a somewhat tricky SQL query.
I have a database in which wireless activity data is dumped.  The following
is a boiled down version of what the table and the contents may look like:

Date,Unit,InputOctets,OutputOctets,AccountingID
2004-01-31 23:59:05,0E:3A:0F,10101,3949,SLAKRMMM
2004-02-01 00:04:07,0E:3A:0F,13843,4192,SLAKRMMM
2004-02-01 00:09:10,0E:3A:0F,53233,9021,SLAKRMMM
2004-02-01 00:14:08,0E:3A:0F,2383,109,NX0ADFF
...
2004-02-29 23:59:15,0E:3A:0F,481234,18233,LAQ5YN3

This requires a bit of explanation.  The Unit is the actually wireless
modem, and the octet counts are the totals for the unit since it was last
rebooted (by adding the new byte activity since the last accounting data
five minutes before).  The problem comes when the unit is rebooted.  At that
point the counters start at 0 and a new accounting ID is written.

What I need 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://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Cygwin and Mysql Tools

2004-02-16 Thread A. Clausen
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: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Creating backups

2003-10-29 Thread A. Clausen
avenger wrote:

but if my table is sooo big..
eg if large than 1 G. so use the mysqldump is more and more slowly
speed.
I don't have one gig tables, but I do have a few that come in at a few 
hundred meg.  I actually dump them to another machine on my network 
(100mbit NIC cards) and it usually takes no more than a four or five 
minutes.  Since I do the main dump once a day at 1am, it could run for a 
half hour and I wouldn't care.

For critical data (mainly our accounting database), I do hourly dumps. 
Those tables are relatively small, so it doesn't take more than 40 or 50 
seconds (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]


Re: Accessing MySQL Using ASP

2002-01-29 Thread A. Clausen

- Original Message -
From: "sdfine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 28, 2002 12:06
Subject: Accessing MySQL Using ASP


>
> Does anyone have a good example of accessing and displaying data in a
MySQL
> database using ASP and displaying it on a web page?  I'm a VB programmer
and
> I'm new to accessing databases from the web and just need one good example
> to tie everything together.
>
> Thanks


Here's a small one off the top of my head.  Obviously you will have to set
up an ODBC DSN on the web server for this to work.  I use MySQL with IIS 5
and ASP all the time and have no problems.

<% @Language = "VBScript" %>
<% Response.buffer = true %>

<%
Dim conDB' ADODB connection object
Dim rsBirthdays' Query recordset
Dim strSQL' SQL query

' Create ADODB connection instance
Set conDB = Server.CreateObject("ADODB.Connection")
' Create ADODB recordset instance
Set rsBirthdays = Server.CreateObject("ADODB.Recordset")

' Open a recordset
strSQL = "SELECT firstname, lastname, birthday FROM employees order by
lastname;"
rsBirthdays.Open strSQL, conDB
%>




First NameLast NameBirthday

<% Do While Not rsBirthdays.EOF %>

<%= rsBirthdays("firstname") %>
<%= rsBirthdays("lastname") %>
<%= FormatDateTime(rsBirthdays("birthday"), 1) %>
<% Loop %>





<%
' Close recordset
rsBirthdays.Close
' Close connection
conDB.Close
%>


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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Replication Problem on MySQL 3.23.45/Win32

2001-12-10 Thread A. Clausen

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 07, 2001 21:41
Subject: Re: Replication Problem on MySQL 3.23.45/Win32


At 12:04 07/12/01 -0800, A. Clausen wrote:
Hi,

Does print the command "show databases" the db in question ?
and you are able for perform commands on the tables using
the mysql client tool ?

Regards,
Miguel
>I have been using replication for several months between to Win2k machines.
>Last week I upgraded to MySQL 3.23.45, and everything continued working
>fine.  Yesterday, I put the line "use-symbolic-links" in the my.cnf file
>because I've created a very large database that I have another drive
>reserved for.  Since that time, when I enter "show processlist" the top
line
>shows:
>
>|1 | system user | none   | NULL   | Connect | 88449 |
>connecting to master | NULL |
>
>Of course, the replicating server is not getting through at all.  Anybody
>know what could be causing 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 PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com




-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Replication Problem on MySQL 3.23.45/Win32

2001-12-07 Thread A. Clausen

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]


- Original Message -
From: "Gustavo A. Baratto" <[EMAIL PROTECTED]>
To: "A. Clausen" <[EMAIL PROTECTED]>
Cc: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 12:16
Subject: Re: Replication Problem on MySQL 3.23.45/Win32


> I'm not sure,
>
> But I don't think symbolic links are allowed on win2k...
>
> Take a look into this...
>
> Regards,
> gustavo
> 
>
> On Fri, 2001-12-07 at 12:04, A. Clausen wrote:
> > I have been using replication for several months between to Win2k
machines.
> > Last week I upgraded to MySQL 3.23.45, and everything continued working
> > fine.  Yesterday, I put the line "use-symbolic-links" in the my.cnf file
> > because I've created a very large database that I have another drive
> > reserved for.  Since that time, when I enter "show processlist" the top
line
> > shows:
> >
> > |1 | system user | none   | NULL   | Connect | 88449
|
> > connecting to master | NULL |
> >
> > Of course, the replicating server is not getting through at all.
Anybody
> > know what could be causing 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 PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> --
>
> --
>  Gustavo Baratto - Programming and Technical Support
>  [EMAIL PROTECTED] * (604) 638-2525 ext. 408
>
>  Technical support web-site: http://support.superb.net
>  Superb Internet Corp. "Ahead of the Rest"
>
> -
>
>
> -
> 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]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Replication Problem on MySQL 3.23.45/Win32

2001-12-07 Thread A. Clausen

I have been using replication for several months between to Win2k machines.
Last week I upgraded to MySQL 3.23.45, and everything continued working
fine.  Yesterday, I put the line "use-symbolic-links" in the my.cnf file
because I've created a very large database that I have another drive
reserved for.  Since that time, when I enter "show processlist" the top line
shows:

|1 | system user | none   | NULL   | Connect | 88449 |
connecting to master | NULL |

Of course, the replicating server is not getting through at all.  Anybody
know what could be causing 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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Creating MySQL table w/2 primary keys

2001-12-07 Thread A. Clausen

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 MySQL table w/2 primary keys


>
> As far as I know, you can't do tht. What you could do instead is
> have one Primary Key col and make another one UNIQUE.
>
> I did that several times, and it does work!
>
> --
>
> What they need to teach in school is for people to think for themselves.
:-)
>  -- Larry Wall in <[EMAIL PROTECTED]>
>
> Demirchyan Oganes-AOD098 wrote:
>
> DO: Hello everyone,
> DO:
> DO: I have this create table statement,
> DO:
> DO: drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE;
> DO:
> DO: CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING(
> DO: ANALYSIS_RESULT_ID MEDIUMINT(20)  PRIMARY KEY REFERENCES
PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID),
> DO: GROUP_CONCLUSION_IDMEDIUMINT(20)  PRIMARY KEY REFERENCES
GROUP_CONCLUSION(GROUP_CONCLUSION_ID)
> DO: ) Type=InnoDB;
> DO:
> DO: where I want to create table with 2 primary keys, but it won't let
me.
> DO:
> DO: How could I do it.
> DO:
> DO: Regards,
> DO:
> DO: Oganes Demirchyan
> DO: Motorola Life Science
> DO: 757 S.Raymond
> DO: Pasadena, CA  91105
> DO: Tel: 626-584-5900
> DO: email: [EMAIL PROTECTED]
> DO:
> DO:
>

   DO: -
> DO: Before posting, please check:
> DO:http://www.mysql.com/manual.php   (the manual)
> DO:http://lists.mysql.com/   (the list archive)
> DO:
> DO: To request this thread, e-mail <[EMAIL PROTECTED]>
> DO: To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> DO: Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
> DO:
>
>
> -
> 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]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: conceptual question.

2001-11-29 Thread A. Clausen

I was taught that when it comes to files, use the DBMS designed for files,
namely the file system.


A. Clausen [EMAIL PROTECTED]


- Original Message -
From: "Etienne Marcotte" <[EMAIL PROTECTED]>
To: "Venu Allavatam" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 11:14
Subject: Re: conceptual question.


> I store links instead of the data.
>
> I don't know I seem to prefer a "light" database and the retreival of
> images/others from the server itself instead of pulling it from the
> database.
>
> There are a lot of debates on this, I'm only telling you what I prefer
> to use:)
>
> Etienne
>
> Venu Allavatam wrote:
> >
> > hello all!
> > i have a question regarding the storage of data. The
> > doubt is...
> > Should the data (mostly binary files) be stored in the
> > database as a field or a link(a path) to the data be
> > stored.
> >
> > i have read some of the pros and cons on both the
> > issues and am confused. what is the practice usually
> > and what are you guys doing in this matter? please
> > suggest and in case you have good references to look
> > into i would be eager to read them too.
> >
> > thanks
> >
> > venu
> >
> > __
> > Do You Yahoo!?
> > Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
> > http://geocities.yahoo.com/ps/info1
> >
> > -
> > 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]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> --
> Etienne Marcotte
> Specifications Management - Quality Control
> Imperial Tobacco Ltd. - Montreal (Qc) Canada
> 514.932.6161 x.4001
>
> -
> 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]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL 3.23 Manual - PDF

2001-11-29 Thread A. Clausen

Well there is a 4.x manual, and I know from a few months ago that there was
a 3.23 manual on the site which I foolishly decided I didn't need.  Do the
developers of MySQL just delete all copies of manuals for previous version
when they move to new software?  I mean, what is a 3 or 4mb file 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, A. Clausen wrote:
>
> > That is the MySQL 4.x manual, I'm looking for the 3.23.x PDF-formatted
> > manual.  The HTML and text versions supplied with the 3.23 distributions
are
> > way too unwieldly, and I'm not going to upgrade my mission critical app
to
> > what is apparently alpha software, just so I can have an up-to-date
manual.
>
> The very fine manual is not distributed in PDF format, because it's much
> too big in this format. However, you may get your copy without upgrading
> your software. Just get the latest mysql-3.23.45.tar.gz, unzip, untar, go
> to the mysql-3.23.45 directory and type:
>
> me@host:~/mysql-3.23.45> ./configure
>
> to create the Makefiles. Then go to the Docs/ directory and
>
> me@host:~/mysql-3.23.45/Docs> make manual.pdf
>
>  ... and have a cup of coffee. You need the GNU TeX-info and pdftex
> (available from the teTeX package). In case all else fails I put a copy of
> the manual in PDF format on:
>
> http://www.polyreg.ch/ssl/misc/mysqlmanual/
>
> To use the manual on the screen without printing I recommend the
> pinfo viewer (ver 6.3) and mysql.info
> This provides for the ease of lynx and the speed of light.
>
> Regards,
> Thomas
>
>


-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL 3.23 Manual - PDF

2001-11-28 Thread A. Clausen

If you wouldn't mind, though I think the folks at MySQL.Com should consider
throwing a copy back up.  Maybe I'm just a nervous nelly, but I won't be
moving update Mysql 4 until it's beyond the alpha stage.  I'm running an
accounts receivable system, and I just upgraded to 3.23.45 yesterday.


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 yet...
>
> Jerry
>
> http://www.rfbdproductions.com
> Web Hosting & Design
> Event Production
> Home Of Radio Free BD
>
> - Original Message -
> From: "A. Clausen" <[EMAIL PROTECTED]>
> To: "MySQL Mailing List" <[EMAIL PROTECTED]>
> Sent: Wednesday, November 28, 2001 2:49 PM
> Subject: 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.  Where would you put it?
> > >
> > > Website, under documentation.  BINGO!
> > >
> > >
> >
>
http://www.mysql.com/downloads/download.php?file=Downloads/Manual/manual.pdf
> > >
> > > Not sure why this MySQL list has so many questions and folks have to
be
> > > trained to check the main website first.  Heck it even says to RTFM in
> the
> > > trailer message on each of the posts...but people post Q's here first.
> > >
> > > I know.  I was one.  For 3 months.  The truth is, the main website,
> > bitbybit
> > > FAQ and Paul DuBois' MySQL book have an enormous wealth or well
> organized
> > > information.  Not trying to bust your chops, I did it (and still do
from
> > time
> > > to time), just letting you know that there is a faster (and more
> complete)
> > > way to find answers.
> >
> > That is the MySQL 4.x manual, I'm looking for the 3.23.x PDF-formatted
> > manual.  The HTML and text versions supplied with the 3.23 distributions
> are
> > way too unwieldly, and I'm not going to upgrade my mission critical app
to
> > what is apparently alpha software, just so I can have an up-to-date
> manual.
> >
> > 
> > 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]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>


-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL 3.23 Manual - PDF

2001-11-28 Thread A. Clausen

- 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.  Where would you put it?
>
> Website, under documentation.  BINGO!
>
>
http://www.mysql.com/downloads/download.php?file=Downloads/Manual/manual.pdf
>
> Not sure why this MySQL list has so many questions and folks have to be
> trained to check the main website first.  Heck it even says to RTFM in the
> trailer message on each of the posts...but people post Q's here first.
>
> I know.  I was one.  For 3 months.  The truth is, the main website,
bitbybit
> FAQ and Paul DuBois' MySQL book have an enormous wealth or well organized
> information.  Not trying to bust your chops, I did it (and still do from
time
> to time), just letting you know that there is a faster (and more complete)
> way to find answers.

That is the MySQL 4.x manual, I'm looking for the 3.23.x PDF-formatted
manual.  The HTML and text versions supplied with the 3.23 distributions are
way too unwieldly, and I'm not going to upgrade my mission critical app to
what is apparently alpha software, just so I can have an up-to-date manual.


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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MySQL 3.23 Manual - PDF

2001-11-28 Thread A. Clausen

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://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MySQL 3.23 Manual

2001-11-26 Thread A. Clausen

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   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MySQL/MyODBC and IMail

2001-09-13 Thread A. Clausen

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)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Expiring Binary Logs

2001-09-07 Thread A. Clausen

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

Thanks for the pointer.

Aaron

-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Expiring Binary Logs

2001-09-05 Thread A. Clausen

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.

-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MySQL Error Codes

2001-08-28 Thread A. Clausen

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 come back, but it would be nice to have a 
definitive list.

Aaron

-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Upgrading mysql on Win2K

2001-08-07 Thread A. Clausen

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?


-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: mysql.org

2001-07-13 Thread A. Clausen

-- 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 of selling their own commercial deployments of the
>package?  And by that I can somewhat see why NuSphere is using the phrase
>"unfair business practice."
>
>I'm fairly certain that MySQL is primarily developed on RedHat Linux
>servers, is it not?  Linux has gotten itself out of the "hackers" domain
>into the mainstream due to the commercial investments of companies like
>RedHat and Caldera, both of which sell the GPL product at a profit,
>including their own enhancements to it.  I can walk into Office Depot this
>afternoon and purchase RedHat 7.x right off the shelf.  It's sitting right
>there beside Windows2000.  Obviously, agreements are in place to allow
>this.  Linux has also suffered its pitfalls from being distributed in this
>manner.  Caldera, Slackware, RedHat and a number of other Linux derivatives
>are not fully inter-operable.  On the other hand, Linus and his friends
>certainly have not suffered from the popularity of his operating system.
>
>MySQL can and will survive as an open-source project.  But to compete truly
>on the commercial level with companies that have PR teams and sales reps
>and advertising budgets (ala Oracle or MicroSoft), commercial investment is
>needed... and that's where companies like NuSphere come into play.  Or will
>MySQL AB be incorporating in the U.S. and offering an IPO?
>
>Of course, the final decision is left to those at MySQL AB.  And whatever
>that decision, rest assured that I am behind it 100%.  I am an avid
>supporter and I continually pitch the worth of all your work to colleges
>all the time. I simply wish to present the possible positive side of
>this situation for consideration.

HOw is being legal holder of the copyright, and enforcing that copyright, be 
considered "unfair business practice"?  Open source is NOT public domain, and those 
that use MySQL are bound by the GPL.  If NuSphere does not like that agreement, it, 
like anybody else, does not have to use, support, or even mention it.  This is nothing 
more than an attempt to wrestle control of a product protected by international 
convention.  If NuSphere were permitted to get away with this, it would cast a pall 
over all open source activities.  Many open source developers don't mind "giving away" 
the product, even permitting derivative works, as long as they are protected from the 
likes of NuSphere.  Theft is theft, no matter how you try to rationalize it.


-
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php