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://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 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
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)
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)
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
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
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
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
- 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
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
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
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
- 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
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
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
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
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.
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
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
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
- 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
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
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
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
-- 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
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
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
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
-- 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