RE: MySQL or PostgreSQL

> Since you're posting on a MySQL list, you could probably expect some > biased responses. Could you post more about what you need to use a > database for, i.e., what are your needs, wants, what kind of data are > you handling, connection rates, serving platform, code base, etc. > > Here are a few

re: trouble setting key_buffer_size on a debian slave

ef=ensita This email is sponsored by > Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.co

Re: Using MySQL to store email

nk. > > Thanks for any thoughts on this, > Jeff > > > > > > William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 - Before posting, please check: http://www.

Re: Slower access from a client some router hops away from mysql server

eck is if bandwidth is the issue. 2 Mbps is much slower than local LAN. Also there is the possiblity of dropped packets and retransmittals. The more routers the slower this would be. Have you checked how busy the WAN is. Just my $0.02 worth. > I will appreciate a lot any ideas about this.

Re: encrypted password

> On Wed, 2003-02-05 at 13:53, Kamara Eric R-M wrote: > >> INSERT into tbl_name (username,password) values >> ('user',PASSWORD('passwd')); >> >> and when authenticating the user you can do something like >> >> SELECT username from tbl_name where passwd=PASSWORD('$pass'); and in >> this case $pass i

Re: encrypted password

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

Re: Help with SELECT, JOIN and WHERE query

+-+ > | 1 |1000 | > > Who is not in team no. 2? > > Result: > +-+ > |1002 | > | 1004 | > +-+ > > Thanks for any hint > > Kind regards Heiko Mundle > William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-6

Re: Storeing images in Database

duce the number of files in a given directory which can be a problem with VERY large numbers of files. You can also put them on a totally differnet drive from the database data to increase performance. The cost is bit of setup (have to create the directories) and programming. This should allow

Re: Version 4 "safe" to use?

On Thu, 9 Jan 2003, Paul DuBois wrote: > Date: Thu, 9 Jan 2003 11:29:03 -0600 > From: Paul DuBois <[EMAIL PROTECTED]> > To: Maximo Migliari <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: Re: Version 4 "safe" to use? > > At 13:51 -0300 1/9/03, Maximo Migliari wrote: > >What were the main benefi

RE: Hiding the password

more than an apache solution but it > > explains chroot. This is the best model I know of. I read that it is being > > used less often than in the past so there may be some other methods > > that are more prevalent now but this is one definite working solution. > > > >

Re: Hiding the password

On Mon, 6 Jan 2003, Mark wrote: > Date: Mon, 6 Jan 2003 22:48:06 +0100 > From: Mark <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]>, > Octavian Rasnita <[EMAIL PROTECTED]> > Cc: Larry Brown <[EMAIL PROTECTED]>, > MySQ

Re: Hiding the password

On Mon, 6 Jan 2003, Octavian Rasnita wrote: > Date: Mon, 6 Jan 2003 08:33:48 +0200 > From: Octavian Rasnita <[EMAIL PROTECTED]> > To: Larry Brown <[EMAIL PROTECTED]>, > MySQL List <[EMAIL PROTECTED]> > Subject: Re: Hiding the password > > No, we are not talking about the staff of the hosting

Re: sql help

You want to look at 'group by acctSrv.accountID' rather than a compound select. On Mon, 23 Dec 2002, Adam Nowalsky wrote: > Date: Mon, 23 Dec 2002 09:04:32 -0500 > From: Adam Nowalsky <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: sql help > > hi, wonder if the sql gurus can help with

Re: protecting ccard numbers

On Sun, 1 Dec 2002, David T-G wrote: > Date: Sun, 1 Dec 2002 18:42:03 -0500 > From: David T-G <[EMAIL PROTECTED]> > To: mysql users <[EMAIL PROTECTED]> > Subject: protecting ccard numbers > One way would be to encode the credit card number field using data from an external file for the key and t

RE: Removal of Primary Key in Mysql

On Tue, 5 Nov 2002, Alan McDonald wrote: > Date: Tue, 5 Nov 2002 18:49:22 +1100 > From: Alan McDonald <[EMAIL PROTECTED]> > To: Eric Frazier <[EMAIL PROTECTED]>, Paul DuBois <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: RE: Removal of Primary Key in Mysql > > Because a primary key is a t

Re: users who can access a database

On Thu, 10 Oct 2002, Anil Garg wrote: > Date: Thu, 10 Oct 2002 13:38:52 -0400 > From: Anil Garg <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: users who can access a database > > hi, Please checkout the GRANT command. In earlier versions of mysql you had to put information into the mys

Re: protecting CC numbers

On Sun, 6 Oct 2002, David Gerler wrote: > Date: Sun, 6 Oct 2002 14:21:11 -0400 > From: David Gerler <[EMAIL PROTECTED]> > To: Mysql <[EMAIL PROTECTED]> > Subject: protecting CC numbers > > Hi, > I am working on an application that will need to store users CC > numbers so that they can be c

Re: Mixing Linux and Windows and paying for it

On Mon, 30 Sep 2002, Drulli B wrote: > Date: Mon, 30 Sep 2002 18:13:51 - > From: Drulli B <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Mixing Linux and Windows and paying for it > > Hi, > > I have a grand total of two very important but possibly humiliatingly daft > questions, tha

Re: Urgent!!

On Sun, 29 Sep 2002, Insanely Great wrote: > Date: Sun, 29 Sep 2002 22:43:43 +0530 > From: Insanely Great <[EMAIL PROTECTED]> > To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: Re: Urgent!! > > Greetings... > > I believe that ASP works well with MySQL thru ODBC. As of lear

Re: PD: The win admin for Mysql

I've used dbtools http://www.dbtools.com.br/ However I'm using 1.0.12 rather than 1.0.15 since the newer version appears to have a few bugs. there is of cours mysqlgui from mysql (see their site). On Wed, 11 Sep 2002, =?iso-8859-2?Q?J=EAdrzej_Kolesi=F1ski?= wrote: > Date: Wed, 11 Sep 2002 21

RE: Tape backups from live slave

to recreate indexes for > every table if I have to restore. I'd rather spend an hour restoring > from tape and let replication catch me up. > > -J > > -Original Message- > From: William R. Mussatto [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 30,

Re: Tape backups from live slave

On Fri, 30 Aug 2002, Jeremy Tinley wrote: > Date: Fri, 30 Aug 2002 12:36:28 -0500 > From: Jeremy Tinley <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Tape backups from live slave > > Howdy, > > Before I run off and try it, can anyone offer up any problems with doing > a LOCK TABLES, FL

Re: MySQL and Service Pack 3 - OT comment

This might explain how I lost my secondary IDE controller. I just unistalled SP3 to resolve my issue. On Thu, 29 Aug 2002, =?ISO-8859-1?Q?Iikka_Meril=E4inen?= wrote: > Date: Thu, 29 Aug 2002 23:10:06 +0300 (EEST) > From: =?ISO-8859-1?Q?Iikka_Meril=E4inen?= <[EMAIL PROTECTED]> > To: Marc Hus <[

Re:

Can connector/J coexist with mm.mysql on the same tomcat? I'd like to upgrade one site at a time rather than then all the sites at once. On Wed, 28 Aug 2002, Mark Matthews wrote: > Date: Wed, 28 Aug 2002 08:59:33 -0500 > From: Mark Matthews <[EMAIL PROTECTED]> > To: neal <[EMAIL PROTECTED]> >

Re: NULL ?

On Tue, 27 Aug 2002, Will K. wrote: > Date: Tue, 27 Aug 2002 01:09:32 + > From: Will K. <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: NULL ? > > hello, > > Please dont tell me to RTFM on this one (cause I am already doing that), but > for clarity's sake... can someone tell me what

RE: View current connections

Is the MySQL serving a web site? If yes, wrap show processlist in perl or php and have it generate an auto refreshing page. On Thu, 15 Aug 2002, Tab Alleman wrote: > Date: Thu, 15 Aug 2002 11:01:44 -0400 > From: Tab Alleman <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: RE: View curren

Re: Found cause of crash - simple SQL statement.

Pardon my ignorance, what "Linux table corruption" and what versions of Linux and MySQL are we talking about? I googled, but came back only with "4.4.6.7 Using myisamchk for Crash Recovery ... --skip-external-locking". Not much help. I'm sorry if this is old news, but I thougth I was followi

Re: Automatic timestamping

On Wed, 31 Jul 2002 [EMAIL PROTECTED] wrote: > Date: Wed, 31 Jul 2002 12:49:35 -0300 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Automatic timestamping > > Hi all, > > As I'm not very experienced with DB technology, I'm very sorry if my > question seems stupid. > > I have set

Re: how to update time field with current time?

On Wed, 24 Jul 2002, Dermot Paikkos wrote: > Date: Wed, 24 Jul 2002 17:46:00 +0100 > From: Dermot Paikkos <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: how to update time field with current time? > > Hi > Probably a silly question but how can I set a time field to the current > time wi

Re: Fw: Problems with high-use tables

Just a quick question. Why are you not running DBD::Mysql directly? It should eliminate the ODBC layer and help with speed. On Thu, 18 Jul 2002, Christopher A. Libby wrote: > Date: Thu, 18 Jul 2002 08:22:33 -0400 > From: Christopher A. Libby <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subje

Re: Dreamweaver MySql Databases

Does your server support .jsp pages? Does your version of dreamweaver support editing .jsp pages? If yes to both questions, you can install a copy of MySql on your development box and develop there and move the pages up when you are ready to go live. Make sure both databases have the same stru

Re: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql

On Thu, 27 Jun 2002, jason wesley upton wrote: > Date: Thu, 27 Jun 2002 14:05:34 -0500 > From: jason wesley upton <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql > > EXPLANATION: > > here's the pertinent piece of my sql creat

Re: alter column without dropping

On Fri, 14 Jun 2002, Peak Digital Productions wrote: > Date: Fri, 14 Jun 2002 16:33:05 -0600 > From: Peak Digital Productions <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: alter column without dropping > > The data going into one of my mySQL columns has suddenly changed, so I need > to

RE: Is the order same?

On Fri, 14 Jun 2002, Francisco Reinaldo wrote: > Date: Fri, 14 Jun 2002 12:52:15 -0700 (PDT) > From: Francisco Reinaldo <[EMAIL PROTECTED]> > To: Steve Edberg <[EMAIL PROTECTED]>, Vandana <[EMAIL PROTECTED]> > Cc: Jay Blanchard <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > Subject: RE: Is the or

Re: JDBC connection to MySQL

On Tue, 7 May 2002, George Pitcher wrote: > Date: Tue, 7 May 2002 06:15:28 +0100 > From: George Pitcher <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: Re: JDBC connection to MySQL > > Just a guess, but how about an ampersand? > > Connection c = > DriverManager.getConn

Re: Scheduling with MySQL

Minor change, I think it should be a datetime field not a timestamp field since timestamps are supposed to be updated by the database. On Fri, 26 Apr 2002 [EMAIL PROTECTED] wrote: > Date: Fri, 26 Apr 2002 17:16:06 +0100 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] >

Re: mysql innodb error

I thought the 4.0 series was still Beta? On Mon, 1 Apr 2002, Heikki Tuuri wrote: > Date: Mon, 1 Apr 2002 18:09:53 +0300 > From: Heikki Tuuri <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: mysql innodb error > > Kannan, > > please upgrade to 3.23.49a or 4.0.1. > > 101 used to m

Re: Report to Recipient(s)

On Tue, 26 Mar 2002 [EMAIL PROTECTED] wrote: > Date: Tue, 26 Mar 2002 16:39:05 -0500 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Report to Recipient(s) > > Incident Information:- > > Originator:[EMAIL PROTECTED] > Recipients:[EMAIL PROTECTED] > Subject: mysql Digest 26

Re: Optimizing tables

Ok this works on myisam tables, but what about InnoDB On Fri, 22 Mar 2002, Egor Egorov wrote: > Date: Fri, 22 Mar 2002 15:38:03 +0200 > From: Egor Egorov <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Optimizing tables > > Vijay, > Friday, March 22, 2002, 1:14:33 PM, you wrote: > > V>

RE: 3.22.32: max table size

Fromt the mysql.com site: http://www.mysql.com/doc/I/S/ISAM.html for all the limits.. Remember that your files sizes may be smaller because of your OS. On Fri, 22 Feb 2002, Brian Warn wrote: > Date: Fri, 22 Feb 2002 09:11:07 -0800 > From: Brian Warn <[EMAIL PROTECTED]> > To: 'Gurhan Ozen' <[E

RE: 3.22.32: max table size

You, like me, are using 3.22 which does not have the myisam table type (or others for that matter). ISAM I believe, has a lower limit. They do support sizes less that 4GB (up to the OS file size limits). The three file extentions total do constitute the total table size, but I believe that e

Re: Please, need help urgently

Had a similar problem a few years back. System worked fine for a number of months then started crashing whenever I recompiled the kernel. Turned out to be a defective secondary cache (yes it was a Pentium and yes it was a number of years ago). Showed up only under heavy cpu load. Try stres

Re: sysctl & process limitations

On Mon, 4 Feb 2002, Randy Arabie wrote: > Date: Mon, 4 Feb 2002 12:01:11 -0700 (MST) > From: Randy Arabie <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: Dan Nelson <[EMAIL PROTECTED]>, > Manuel Bouyer <[EMAIL PROTECTE

Re: sysctl & process limitations

Have you checked on the ulimit for the user that is mysql? On Sat, 2 Feb 2002, Dan Nelson wrote: > Date: Sat, 2 Feb 2002 20:58:07 -0600 > From: Dan Nelson <[EMAIL PROTECTED]> > To: Randy Arabie <[EMAIL PROTECTED]> > Cc: Manuel Bouyer <[EMAIL PROTECTED]>, [EMAIL PROTECTED], > [EMAIL PROTECTED

Re: SV: MySQL on the Playstation2? (OT? You betcha)

I'm glad you spelled it out. When it first started I thought you were refering to IBM PS/2 computer, silly me. On Thu, 31 Jan 2002 [EMAIL PROTECTED] wrote: > Date: Thu, 31 Jan 2002 16:01:46 +0100 > From: [EMAIL PROTECTED] > To: [EMAIL PROTEC

Re: Batch load of data problems (fwd)

I'm forwarding this to the list since I can't offer any more advice myself. -- Forwarded message -- Date: Wed, 30 Jan 2002 19:41:32 -0500 From: [EMAIL PROTECTED] To: "William R. Mussatto" <[EMAIL PROTECTED]> Subject: Re: Batch load of data problems I

Re: next insert id (slightly OT)

On Thu, 31 Jan 2002, DL Neil wrote: > Date: Thu, 31 Jan 2002 21:28:04 - > From: DL Neil <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: next insert id (slightly OT) > > William, > &

Re: Batch load of data problems

On Wed, 30 Jan 2002, Eurico de Sousa wrote: > Date: Wed, 30 Jan 2002 16:56:24 -0500 > From: Eurico de Sousa <[EMAIL PROTECTED]> > To: mysql post <[EMAIL PROTECTED]> > Subject: Re: Batch load of data problems > > Hi. Resubmitting a post... > > Basically, my question is if you have defined an INT

RE: Urgent Business Assistance.

On Wed, 30 Jan 2002, Marjolein Katsma wrote: > Date: Wed, 30 Jan 2002 12:33:29 +0100 > From: Marjolein Katsma <[EMAIL PROTECTED]> > To: MySQL <[EMAIL PROTECTED]> > Subject: RE: Urgent Business Assistance. > > > At 03:52 2002-01-30, Todd Williamsen wrote: > >If its so urgent and private then why

Re: next insert id (slightly OT)

On Thu, 31 Jan 2002, DL Neil wrote: ... > > What should be understood is that MySQL's implementation of AUTO_INCREMENT requires >a particular/different > philosophical view: that first the 'primary row' is to be stored, then the >AUTO_INCREMENT data captured, and > finally the dependent row is

Re: How to install JDBC driver!

On Fri, 25 Jan 2002, Rahadul Kabir wrote: > Date: Fri, 25 Jan 2002 12:40:35 -0500 > From: Rahadul Kabir <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: How to install JDBC driver! > > > mm.mysql-2.0.10-you-must-unjar-me.jar > this is the JDBC driver for Mysql3.23.47. Can someone tell me

Re: Decrypting PASSWORD() from MySQL

On Wed, 19 Dec 2001, Matt Wagner wrote: > Date: Wed, 19 Dec 2001 13:51:30 -0600 (CST) > From: Matt Wagner <[EMAIL PROTECTED]> > To: Zach Curtis <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Decrypting PASSWORD() from MySQL > > Zach Curtis writes: > > I have a form for a user to requ

Re: Password encryption

If you want to be able to store information encrypted and then decrypt it later and you use perl see Crypt::CBC and pick an algorythim. The only trick is that, with blowfish at least, you need a larger field than the original. Also you must figure out how to hide the key... On Wed, 12 Dec 20

Re: changing allowed number of connections

On Wed, 12 Dec 2001, Jari =?iso-8859-1?Q?M=E4kel=E4?= wrote: > Date: Wed, 12 Dec 2001 13:25:09 +0200 > From: Jari =?iso-8859-1?Q?M=E4kel=E4?= <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: changing allowed number of connections > > Hi, > > Where one can alter the number of connections g

Re: MySQL and encryption

On Tue, 20 Nov 2001, Ken Kinder wrote: > Date: Tue, 20 Nov 2001 08:41:20 -0700 > From: Ken Kinder <[EMAIL PROTECTED]> > To: Thomas Kotze` <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: Re: MySQL and encryption > > I would like to know if anyone has some advice on encrypting credit cards > my

Re: What maintenance is needed for MyISAM tables?

On Fri, 16 Nov 2001 [EMAIL PROTECTED] wrote: > Date: Fri, 16 Nov 2001 11:40:06 + (GMT) > From: [EMAIL PROTECTED] > To: Rick Robinson <[EMAIL PROTECTED]> > Cc: "Mysql \\(E-mail\\)" <[EMAIL PROTECTED]> > Subject: Re: What maintenance is needed for MyISAM tables? > > On Thu, 15 Nov 2001, Rick Ro

Re: Cannot add blob data to innodb table

On Mon, 12 Nov 2001, Heikki Tuuri wrote: > Date: Mon, 12 Nov 2001 09:06:42 +0200 > From: Heikki Tuuri <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: Cannot add blob data to innodb table > > Steve, > > >Date: Mon, 12 Nov 2001 08:52:54 > >To: [EMAIL PROTECTED] > >From: Heikki Tuuri <[

RE: Securing username and password in script file

Our php users run their scripts under their own username. this requires the performance hit of treating php like any other cgi script (no mod_php) but they are on a shared server because they are a low volume site. On Sun, 11 Nov 2001, Peter Lovatt wrote: > Date: Sun, 11 Nov 2001 10:20:11 -

Re: Keeping SQL dbs separated

Apache supports running cgi scripts as a designated user on a virtual host basis (only key is the files can be writable by ONLY the USER not his GROUP (toe badly stubbed making this mistake). However, why doesn't the isp create a separate mysql user for each client's database and restrict per

Re: Beginner question - getting last inserted ID

On Fri, 9 Nov 2001, Carl Troein wrote: > Date: Fri, 09 Nov 2001 15:41:21 GMT > From: Carl Troein <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: Beginner question - getting last inserted ID > > > Anna Åhnberg writes: > > > Thanks, I actually already found the chapters but now I also

Re: Can't set max_connections on debian version

Thanks, got it. On Wed, 31 Oct 2001, Wouter de Jong wrote: > Date: Wed, 31 Oct 2001 09:19:14 +0100 > From: Wouter de Jong <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Can't set max_connect

RE: Can I use the concept of Effective Date with MySQL?

I have had to do this problem and i solved it by having 4 fields, Normalprice (PrPrice), Tempprice (PrTempPrice), Start date (PrStart) End Date (PrStop). In the select IF(((CURDATE() >= PRStart) and (PRStop >= CURDATE())), PrTempPrice, PrPrice) as CurrentPrice hope this helps On Thu, 1 Nov

Re: Can't set max_connections on debian version

thanks, I finnally figured out how to set it on the command line and modified safe_mysql script to do it. Thanks On Wed, 31 Oct 2001, Wouter de Jong wrote: > Date: Wed, 31 Oct 2001 09:19:14 +0100 > From: Wouter de Jong <[EMAIL PROTECTED]> > To: "William R. Mussatto"

Re: Can't set max_connections on debian version

successful restart. I am probably missing something basic but... On 30 Oct 2001, Tonu Samuel wrote: > Date: 30 Oct 2001 21:21:32 +0200 > From: Tonu Samuel <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subjec

Can't set max_connections on debian version

I realize this is not the current version, but debian stable is stuck on: 3.22.32. mysqld does not start when I enter max_connections 200 although it reports max_connections 100 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 --

Re: very newbie insert question

Slight error here if you want the auto icrement field to work properly On Wed, 3 Oct 2001, Chris Johnson wrote: > Date: Wed, 3 Oct 2001 20:07:49 -0500 > From: Chris Johnson <[EMAIL PROTECTED]> > To: Russell Miller <[EMAIL PROTECTED]>, sjs <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > Subject: R

RE: Faliue: Write huge binary data to blob Field of mysql use jdbc

Glad to hear this. I was already going that way with my site because I didn't want to have to either drop and reload the database or take ther mysql server down to run the cleanup utility. W/o blobs/text you can use fixed length fields which means the database doesn't become fragmented. On F

Re: Let's approach stored procedures

On Fri, 7 Sep 2001, Cal Evans wrote: > Date: Fri, 7 Sep 2001 11:05:27 -0500 > From: Cal Evans <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp <[EMAIL PROTECTED]> > Subject: Re: Let's approach stored procedures > > Ed, > > Stored procedures allow you to pre-compile and re

Re: order by number

What about a number field w/zero fill? On Thu, 30 Aug 2001, Adams, Bill TQO wrote: > Date: Thu, 30 Aug 2001 08:48:11 -0700 > From: Adams, Bill TQO <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: order by number > > If the column is an int then it will order it

Re: Problem with nested delete - help

On Sat, 18 Aug 2001, Ram wrote: > Date: Sat, 18 Aug 2001 06:16:39 -0700 (PDT) > From: Ram <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Problem with nested delete - help > > Hi, > > I have a problem with nested delete query. I want to > delete some record from one table based on the se

RE: Downsides of MySQL?

Don't forget to include the intermediate software to cache connections since it takes so long to make an oracle connection. On Thu, 16 Aug 2001, Robinson, Mike wrote: > Date: Thu, 16 Aug 2001 11:03:21 -0400 > From: Robinson, Mike <[EMAIL PROTECTED]> > To: "'Boget, Chris'" <[EMAIL PROTECTED]>, >

Re: Nested Queries in MySQl

You can also do it programatically. I find, even with MySQL that this is faster since it avoids the NxM intermediate table creation where one can limit the number of rows intially. I'm using Debian so I'm stuck on .22 for now, this might change in .23. It would definitely be the way to go fo

Re: mysql and credit cards

But what happens when the customer returns the product? You no longer have the cC to do a chargeback On Wed, 25 Jul 2001, Elvis wrote: > Date: Wed, 25 Jul 2001 20:53:26 -0400 (EDT) > From: Elvis <[EMAIL PROTECTED]> > To: Steve Brazill <[EMAIL PROTECTED]> > Cc: Fletcher Sandbeck <[EMAIL PROTECT

Re: Questions about extremely large database support

On Sat, 21 Jul 2001, Sergei Golubchik wrote: > Date: Sat, 21 Jul 2001 10:36:22 +0200 > From: Sergei Golubchik <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: Tom Wheeler <[EMAIL PROTECTED]> > Subject: Re: Questions about extremely large database support > > Hi! > > On Jul 20, Jeremy Zawodny w

Re: Fwd: Join syntax

I think the solution would be to do the "join" at the application level rather than in the database. We frequently had to do this in msql because it did joins so badly. Basically you do the select in the first table including the linking field and then do selects against the second table (th

Re: mysql GUI for windows NT/98 is it available?

you might checkout dbtools. It seems to work quite well for me. Had some problems with setting permisions with it, but that was an earlier version. http://dbtools.vila.bol.com.br Also there is a myGUI in development from the My Sql team. Check the downloads area http://www.mysql.com/downlo

Re: mysqldump all dbs

I prefer dumping things one database at a time so I can more easily recover them. See script below, run from the mysqlback directory which is at the same level as the directory containing the directories of all of the files. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategie

RE: characters - URGENT!!

It is frequently faster. Although, not a problem in mysql, msql frequently ran an order of magnitude faster if the "joins" were done in perl rather than in the SQL statements. On Thu, 24 May 2001, Brian Kaney wrote: > Date: Thu, 24 May 2001 10:01:04 -0400 > From: Brian Kaney <[EMAIL PROTECT

Re: Commit and Rollback.

On Tue, 8 May 2001, Rajeev Ramanujan wrote: > Date: Tue, 8 May 2001 19:49:11 +0530 > From: Rajeev Ramanujan <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Commit and Rollback. > > Hi, > >Will MySQL support COMMIT and ROLLBACK. > > Thank You > Rajeev Ramanujan > > Depends

Re: Mysql speed :)

On Fri, 6 Apr 2001, Tim Bunce wrote: > Date: Fri, 6 Apr 2001 17:25:27 +0100 > From: Tim Bunce <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: Tim Bunce <[EMAIL PROTECTED]>, > Heikki Tuuri <[EMAIL PROTECTED]>, [EMAIL

Re: Mysql speed :)

How do you get it not to try an quote numbers? I realize this should be obvious, but I can't find an exampl in the msql/mysql book. On Fri, 6 Apr 2001, Tim Bunce wrote: > Date: Fri, 6 Apr 2001 11:00:57 +0100 > From: Tim Bunce <[EMAIL PROTECTED]> > To: Heikki Tuuri <[EMAIL PROTECTED]> > Cc: [EM

Re: MySQL Security

Apache can be set to run your cgi as you user which means that it could be set world unreadable I think. On Wed, 4 Apr 2001, Taing Nguon wrote: > Date: Wed, 4 Apr 2001 07:14:33 +0700 > From: Taing Nguon <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTEC

Re: MySQL Security

Make sure that the files are not world readable. On Tue, 3 Apr 2001, Taing Nguon wrote: > Date: Tue, 3 Apr 2001 09:52:30 +0700 > From: Taing Nguon <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: MySQL Security > > Dear sir or madam > > MySQL user's account is not related to user's a

Re: selecting null values

On Wed, 21 Mar 2001, Peter Szekszardi wrote: > Date: Wed, 21 Mar 2001 14:36:02 +0100 (CET) > From: Peter Szekszardi <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: selecting null values > > Hi, > > I have a database which has a text field (let's name it title). The field > is NULL initia

Re: Re[2]: Innobase in MySQL

If you block user access during the recovery, would it be faster w/o the indexes and then add the indexes through alter table and then let the user's in. This is the recommended solution for recovery for DB2. If you have to do a recovery, its normally assumed that the database is locked for s

Re: DBI for Windows

If you are using a current "activestate" release it should be included, if not use their package manager. On Wed, 7 Mar 2001 [EMAIL PROTECTED] wrote: > Date: Wed, 7 Mar 2001 15:59:36 GMT > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: DBI for Windows > > Dear Sirs: > > Please c

Re: file insertion?

On Tue, 6 Mar 2001, Kevin Connolly wrote: > Date: Tue, 6 Mar 2001 18:15:17 - > From: Kevin Connolly <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: file insertion? > > Hi, > Is it possible to insert a file into the MySQL database? I want a table = > with certain entries such as name, a

Re: Patching w/o the compiler was Re: Replication time patch

43:13 -0500 > From: Thimble Smith <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: Re: Patching w/o the compiler was Re: Replication time patch > > On Fri, Feb 23, 2001 at 03:35:06PM -0

Re: MySQL, Linux and Hardware config

Check under ulimit to raise the number of file descriptors. ulimit -n # Linux has a global limit (4096 in debian' case) which may also be raised. However, as someone else has recommended, look at shortening the time you are actually connected. Connect, get data, disconnect, process d

Patching w/o the compiler was Re: Replication time patch

Your reply triggered a question? If you are on a win32 box and using the binary builds, what is the proceure for getting these patchs? Last time I checked the site is was still showing 3.23.33 as the current release? On Fri, 23 Feb 2001, Sasha Pachev wrote: ... > Just realized that a while

Re: ssh

On Thu, 22 Feb 2001, Karl Chen wrote: > Date: Thu, 22 Feb 2001 12:30:25 -0800 > From: Karl Chen <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: ssh > > Hi everyone : > > I wonder what is ssh stand for . and what is benifit over telnet Secure Shell, the information is sent en

RE: Fields

What about varchar binary? On Thu, 22 Feb 2001, Johnny Withers wrote: > Date: Thu, 22 Feb 2001 13:35:44 -0600 > From: Johnny Withers <[EMAIL PROTECTED]> > To: Chris <[EMAIL PROTECTED]>, mysql <[EMAIL PROTECTED]> > Subject: RE: Fields > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > base

Re: ReisserFS

RE ReiserFS What is the hardware (32 bit or 64) and what is the maximum files size MySql will support on it? Thanks. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Befor

RE: Future suggestion

Also, specifying fields won't break things when people add fields to a table. On Wed, 21 Feb 2001, Cal Evans wrote: > Date: Wed, 21 Feb 2001 11:07:36 -0600 > From: Cal Evans <[EMAIL PROTECTED]> > To: Jason Landry <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: Future suggestion > > Hey H

Re: float value is changed

Floats are inexact. If you want exact try the numeric data type. Its stored as a character. On Sat, 17 Feb 2001, Xi Jiang (ITSPORTSNET) wrote: > Date: Sat, 17 Feb 2001 21:05:25 -0700 > From: Xi Jiang (ITSPORTSNET) <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: float value is changed

Re: varchar and sql92

db2 is limited to 255. On Fri, 16 Feb 2001, Eric Frazier wrote: > Date: Fri, 16 Feb 2001 14:13:00 -0800 > From: Eric Frazier <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: varchar and sql92 > > Hi, > > I am writing a program to do queries on a lot of different databases. I have > run i

Re: JDBC question

(EST) > From: webmaster <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: Chen Ka Pong <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: JDBC question > > I am , well I will have to wioork with oracle and jdeveloper, can some of >

Re: JDBC question?

Had similar problem, get the current version of the driver. On Fri, 16 Feb 2001, Chen Ka Pong wrote: > Date: Fri, 16 Feb 2001 20:29:27 +0800 > From: Chen Ka Pong <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: JDBC question? > > I cannot use the jdbc connection which the driver is downl

Re: taxes

Ran into an interesting twist on "presence" in a state. One client went to a trade show in Nevada. She was informed that for the next quarter she would have to consider herself "in" Nevada, even though she did not sell anyting at the show. I don't think she is going back. On Thu, 15 Feb 200

Re: auto_increment problem with mysql 3.23.32

On Wed, 14 Feb 2001, Sinisa Milivojevic wrote: > Date: Wed, 14 Feb 2001 16:21:31 +0200 (EET) > From: Sinisa Milivojevic <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: auto_increment problem with mysql 3.23.32 snip.. > > Hi! > > The above is actually documente

<    1   2   3   >