Re: BUG in UNION implementation?! Confimation or Explaination please

2007-07-11 Thread Joshua J. Kugler
On Wednesday 11 July 2007 00:34, Anders Karlsson wrote:
 UNION will only return distinct rows. This is according to spec and to
 the SQL Standard.

And of course, to no one's surprise, this also matches the mathematical 
definition of union: 

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



[OT] Re: General MySQL Question: Ed Reed (CA, United States of America) Medium

2007-01-29 Thread Joshua J. Kugler
On Monday 29 January 2007 12:57, Ed Reed wrote:
 I just didn't enjoy the location. When it was in Orlando a few years ago,
 it was great. There were plenty of things to do and see; different places
 to eat every night. I had a really good time. Then the following year I
 went to Santa Clara and there was nothing to do. I went to the movies one
 night. Had dinner at Sizzler three times. I drove 45 minutes to find a
 place I could buy a shirt. The rest of the time I stayed in the hotel and
 watched crappy tv. If you folks want me to be away from my family and
 friends for five days you've gotta give me a reason to wanna go besides the
 great technical information. I didn't go to last years, I'm not going to
 this years and I probably won't go to any future ones held in Santa Clara.
 When I came home from the last one, my kids asked what I got them from my
 trip and I had nothing for them. It was just a boring place to go and I
 don't wanna go back. I'd just like to see it held someplace new every year.

 Thanks for replying to my comment

That's funny...when I go to a technical conference, I usually go for the 
conference, and couldn't care less if there is other stuff to do in the area 
during the off hours.

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



Re: Visual Basic 6 + MySQL

2007-01-22 Thread Joshua J. Kugler
On Sunday 21 January 2007 16:41, Nuno Vaz Oliveira wrote:
  Just FYI: you can get the Express version of the VB.Net portion of
  Visual Studio for free:
  http://msdn.microsoft.com/vstudio/express/default.aspx  That way,
  you're much more likely to have a fully supported app.  I've not tried
  running VB6 apps on Vista. :)

 I wasn't able to find the EULA for the express products... And I didn't
 even know about free stuff from Microsoft.

 Anyway, can you tell me if the express editions are free for comertial
 use? I mean, this is not for a student work. It's for a company's use...

While it is officially for hobbyists, students, and novice developers due to 
some missing features versus the entire Visual Studio Suite, according to 
http://msdn.microsoft.com/vstudio/express/support/faq/ :

4.  Can I use Express Editions for commercial use?
 Yes, there are no licensing restrictions for applications built using the 
Express Editions.

So, you're free and clear.  Hope that answers your questions.

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



Re: Visual Basic 6 + MySQL

2007-01-21 Thread Joshua J. Kugler
On Sunday 21 January 2007 08:17, Nuno Vaz Oliveira wrote:
 Hello Miles,

  At 04:39 PM 1/19/2007, Nuno Vaz Oliveira wrote:
 
  Why VB6? This isn't an anti-Microsoft position, but that language has
  been left to die on the vine. So I'd think about .NET, or RealBASIC,
  or ... or  You will have to decide.

 Why VB6? That is an easy one. First, it's the one we have available on
 our office and tha boss ain't going to buy another.

Just FYI: you can get the Express version of the VB.Net portion of Visual 
Studio for free: http://msdn.microsoft.com/vstudio/express/default.aspx  That 
way, you're much more likely to have a fully supported app.  I've not tried 
running VB6 apps on Vista. :)

j


-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



Re: making graphs with MySQL data

2007-01-12 Thread Joshua J. Kugler
On Friday 12 January 2007 12:51, C.R.Vegelin wrote:
 Dear List,

 I have a MySQL database (V5.0.x) and I need to make graphs.
 Does anyone know about good utilities to make graphs ?
 I would appreciate your expertise or links.

If you're using Python, matplotlib is an excellent package.  If you want 
something fully graphical, you can connect MS Excel (and OO Calc) to backend 
databases and query data.

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



Re: Urgent please..

2006-11-15 Thread Joshua J. Kugler
On Wednesday 15 November 2006 18:14, Renish wrote:
  Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
 php.exe and nothing seems to happen.
  I have intalled
 1) webserver-Apache2
 2) MySql-41.1

Please read the documentation before asking questions such as these.  Thanks.

http://www.php.net/manual/en/install.windows.php

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



Re: Workbench

2006-10-30 Thread Joshua J. Kugler
On Sunday 29 October 2006 17:43, David Thole wrote:
 On Oct 22, 2006, at 11:37 AM, João Cândido de Souza Neto wrote:
  Hi everyone.
 
  I´m using mysql workbench to design my database and am heaving a snag.
 
  How can i rename my object? It always gets the name test and i
  did not
  found where can i change its name.
 
  Thanks in advance.
 If you mean trying to rename a table, you should be able to double
 click on the name to bring up the specifics of the table.

 I'm using the newest version of workbench, for OSX.  It should be the
 same for all platforms of workbench.

 -David Thole


He is referring to the database name.  I've run in to this problem too.  When 
you create a new project, your database (schema) is named test and there 
appears no obvious way to rename it.

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



Re: mysqlclient in Apache

2006-10-19 Thread Joshua J. Kugler
On Wednesday 18 October 2006 20:44, Dan Nelson wrote:
 In the last episode (Oct 18), Danny Swarzman said:
  I'm developing an Apache module that uses mySQL. It needs to be able
  to talk to a remote host.
 
  I'm doing this in a Mac.
 
  I have a simple program in C that calls mysql_real_connect(). It
  works with a remote host and with the localhost.
 
  When I put the same code into my Apache module, the call to
  mysql_real_connect() fails.
 
  Anyone have any idea why this is happening?

 In the last episode (Oct 18), Danny Swarzman said:
  I posted a question about running mysql in an Apache module. Maybe I
  need a list with a different focus. Please suggest.

 This list is fine; you just need to include more detail, I think.  Like
 the error code you get from mysql_real_connect(), for starters.

You might want to look at the source code for mod_auth_mysql (apache module) 
for some pointers on doing stuff like that.  Hope that helps.

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



Bug in mysqldump or mysql-server 5.0?

2006-07-28 Thread Joshua J. Kugler
[I searched the bug database...please let me know if I missed an already filed 
or fixed bug.]

I am trying to dump a database from MySQL 4.0.24 using the client tools from 
5.0.  Debian server, Ubutnu 6.06 client.

I use this command line (watch for wrap):

mysqldump -u jkugler -p -h 
dbserver --add-drop-database --add-locks --all --quick --lock-tables 
--disable-keys --create-options --comments --complete-insert -v --databases  
[lots of databases listed here]  mysql4dump.sql

This is then piped to the mysql command like so:

mysql -h dbserver -u jkugler -p -P 3307  mysql4dump.sql

Port 3307 is running MySQL 5.0.21

The first 21 lines of the dump:

-- MySQL dump 10.10
--
-- Host: dbserverDatabase: awra_abstracts
-- --
-- Server version   4.0.24_Debian-10sarge2-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, 
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `awra_abstracts`
--

/*!4 DROP DATABASE IF EXISTS `awra_abstracts`;*/

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `awra_abstracts`;

USE `awra_abstracts`;

When I run the command to import, I get this error:

ERROR 1064 (42000) at line 17: You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right syntax to 
use near '*/
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `awra_abstracts`' at line 1

Running /*!4 DROP DATABASE IF EXISTS `awra_abstracts`;*/ in the mysql 
command line tool also produces an error.  If I take out the /*!4 and */, 
that command will run fine.  Is this a case of mysqldump producing invalid 
syntax, or MySQL 5.0.21 not accepting valid syntax?  For now, i can just 
search/replace the DROP commands and take out the comments, but it is a bit 
annoying.

Thanks.

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



Re: I don't understand why SCSI is preferred.

2006-07-12 Thread Joshua J. Kugler
On Tuesday 11 July 2006 19:26, mos wrote:
 SCSI drives are also designed to run 24/7 whereas IDE drives are more
 likely to fail if used on a busy server.

This used to be the case.  But there are SATA drives out there now being made 
for enterprise class, 100% duty cycle operations.  See, for example, 
http://www.westerndigital.com/en/products/Products.asp?DriveID=238Language=en  
No, I am not affiliated with WD, just had good experience with these drives.  
1.2 Million Hours MTBF at 100% duty cycle and a five year warranty.  Not bad.

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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



Re: DWHS inc.

2006-02-15 Thread Joshua J. Kugler
On Tuesday 14 February 2006 18:37, [EMAIL PROTECTED] said something like:
 Hello,

 Is there anything we can do to help the MySQL project, we are firm
 believers and would like to contribute in some way.

 We have a several 100 mps connections and server space.

MySQL already has a Southern California mirror (H.E. in San Diego), but 
they might be willing to take on another.

j- k-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and 
under the earth, that Jesus Christ is LORD -- Count on it!

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



Re: this listserv function...?

2005-12-19 Thread Joshua J. Kugler
On Monday 19 December 2005 08:21, Rhino said something like:
 While Reply to all has the desired effect, I've always found it a
 pain-in-the-ass. I subscribe to a handful of other mailing lists and
 I always forget when my replies should be sent with Reply and when
 they should be sent with Reply All.  I know that only one of the
 lists requires Reply to all but I never remember which one.

 This does not cause any huge hardship - I *usually* catch any errors
 before I send the note - but it has caused some confusion when I
 didn't catch the error and replied offlist when I wanted to reply
 onlist.

 Is there any way the mysql list(s) can be modified so that a good
 ole' Reply has the desired effect, just as it does in seemingly
 every other mailing list in existence? Or is there some great reason
 why the mysql lists are different than everyone else's lists?

KMail has a handy little feature whereby when you press L while 
reading a message it replies to list.  I use that all the time.

j- k-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and 
under the earth, that Jesus Christ is LORD -- Count on it!

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



Re: MySQL and Mandrake 10.2

2005-07-26 Thread Joshua J. Kugler
See the release notes:

http://qa.mandriva.com/twiki/bin/view/Main/MandrivaLinux2005ReleaseNotes#MySQL

j- k-

On Monday 25 July 2005 23:43, Pascal Francq said something like:
 I made an upgrade from Mandrake 10.1 to 10.2. Since, I cannot connect
 anymore to the database locally using '127.0.0.1':

 [EMAIL PROTECTED] sysconfig]# mysql -u root -h 127.0.0.1
  ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1'
 (111)

 I suppose that something has changed concerning the configuration of
 MySQL or the access to the network, but I do not what. Anyone an
 idea? --


 Prof. Pascal Francq
 Université libre de Bruxelles
 CAD/CAM Department
 Avenue F.D. Roosevelt, 50
 CP 165/14
 B-1050 Brussels
 BELGIUM
 Tel. +32-2-650 47 65
 Fax +32-2-650 47 24

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and 
under the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device

2005-03-03 Thread Joshua J. Kugler
Please don't respond directly to me if you have further questions, as 
you would probably be more likely to get better help from the list.

It sounds like a typical database connection?  What is your problem?  
What are the errors you are getting?  All you have said so far is that 
you need help, and here is how you are doing it.  If you can get a 
TCP/IP connection on the mobile device, you should be good to go.

j- k-

On Tuesday 01 March 2005 22:44, you said something like:
 Thank you for your Reply,

 Yes I have a TCP/IP connection on the WinCE device.

 My VB application on the ipaq gets its data from a DB on the device.
 I use ADOCE to connect to this DB, this DB on the device synchronizes
 with a MYSQL DB, and currently I have a desktop application that
 handles the synchronization. This means I physically plug in to a
 desktop PC with a USB cable and then sync the 2 DBs. So what I want
 to do is move the sync app to the CE Device and connect to MYSQL
 directly from the mobile device.

 Hope this gives you a better idea of the problem.

 Regards
 Hough

  Joshua J. Kugler [EMAIL PROTECTED] 03/02/05 9:07 AM 

 On Wednesday 23 February 2005 03:47, Hough Van Wyk said something

 like:
  I am developing a embedded VB application running on a hp ipaq
  running Windows CE 2003. This app has to connect to a MYSQL DB over

 a

  wireless network. I have surfed the internet for hours with no
  luck. Can anyone please help me with this problem.

 What exactly is your problem?  Do you have a TCP/IP connection on the
 WinCE device?  Will the MySQL ODBC drivers run on the device (or does
 your programming environment have its own drivers, such as the
 light-weight drivers for VB)?  What have your tried?  If it's a
 standard ethernet connection, there is no difference than if you were
 plugged into a wall.

 What exactly are you looking for in your search?

 j- k-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and 
under the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device

2005-03-01 Thread Joshua J. Kugler
On Wednesday 23 February 2005 03:47, Hough Van Wyk said something like:
 I am developing a embedded VB application running on a hp ipaq
 running Windows CE 2003. This app has to connect to a MYSQL DB over a
 wireless network. I have surfed the internet for hours with no luck.
 Can anyone please help me with this problem.

What exactly is your problem?  Do you have a TCP/IP connection on the 
WinCE device?  Will the MySQL ODBC drivers run on the device (or does 
your programming environment have its own drivers, such as the 
light-weight drivers for VB)?  What have your tried?  If it's a 
standard ethernet connection, there is no difference than if you were 
plugged into a wall.

What exactly are you looking for in your search?

j- k-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and 
under the earth, that Jesus Christ is LORD -- Count on it!

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



Re: New to MySQL on Linux

2005-02-11 Thread Joshua J. Kugler
On Friday 11 February 2005 09:15, Terry Riley said something like:
 Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk,
 that had an apparently unusable XP SP2 OS on it, I decided to wipe
 the disk and install my first Linux instead, using an ancient RedHat
 7.3 distribution.

First suggestion: get something recent: Suse 9.2, Mandrake 10.1, Fedora 
Core 3, the latest Debian.  A distro that old will have major security 
(and probably usability issues).

 Now the question: If I'm only using this as a database (no
 development) on RH7.3, which is the preferred download? I am confused
 by the plethora of options available for Linux. Just need something
 that is relatively simple to install (either 4.1.9 or 5.0.x).

I would doubt the current MySQL RPM's would support something as old as 
RH 7.3.  If you install something recent, there will be recent versions 
of MySQL (Mandrake even has 5.0 in the contrib section, I would assume 
Fedora would too.

You will have to intstall the server portion, and probably the client 
portion.  You then can use the MySQL GUI tools to admin the box from a 
Windows machine.

Using something like Mandrake or Fedora, their installer tools will 
resolve all the dependencies for you.

Hope that gets you started a little.  If you need more detail, feel free 
to ask.

j- k-


-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and 
under the earth, that Jesus Christ is LORD -- Count on it!

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


Re: GRANT can't grant with a password?

2005-01-11 Thread Joshua J. Kugler
Yes, I hadn't thought of that.  But at the same time, the way it's presently 
set up, you *can,* and must, create a user with no password.  That doesn't 
seem very safe either.

j- k-

On Tuesday 11 January 2005 05:17, Tom Crimmins said something like:
 [snip]
 It seems that the GRANT syntax should allow the setting of a password upon
 account creation without requiring access to the mysql db.
 [/snip]

 Example:

 GRANT SELECT ON dbihavegrantprivon.* TO 'root'@'localhost' IDENTIFIED BY
 'newpassword';

 If you don't have privs to the mysql.user table you definitely should not
 be able to do that.

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: GRANT can't grant with a password?

2005-01-10 Thread Joshua J. Kugler
Right, I understand that, but then *why* can a user create another user, with 
all the priveleges they have, but with now password.  That seems like a great 
security hole.  It seems that the GRANT syntax should allow the setting of a 
password upon account creation without requiring access to the mysql db.

j- k-


On Saturday 08 January 2005 05:55, Gleb Paharenko said something like:
 Hello.

 As said at:

   http://dev.mysql.com/doc/mysql/en/SET_PASSWORD.html

 Only clients with access to mysql database can set passwords for
 other accounts.

 Joshua J. Kugler [EMAIL PROTECTED] wrote:
  I've read the sections on GRANT's and permissions, and done some
  googling, and
 
  still haven't found what I'm looking for.
 
  I have a user that has USAGE and GRANT global privs and all privs and
  GRANT on database rubric.
 
  However, when they try to run this query:
 
  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON rubric.* TO
  'user'@'localhost' IDENTIFIED BY 'password';
 
  They get the error
 
  ERROR 1044: Access denied for user 'user'@'host' to database 'mysql'
 
  They can log in just fine, so it is not a matter of host name.
 
  I found a post that seemed to allude to the fact that a user with GRANT
  could
 
  only create a new user via GRANT if there was not IDENTIFIED BY clause.
 
  (However, a user with write permissions to the mysql database could).  I
 
  verified this to be the case when this query,
 
  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON rubric.* TO
  'user'@'localhost'
 
  run as the user in question, worked and created the user, albeit with no
 
  password.
 
  Is there a way for a user with GRANT privs to create a user *with* a
  password?
-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Unique IDs

2005-01-07 Thread Joshua J. Kugler
When I saw this message a few weeks ago, I *knew* MySQL had something for 
this, but I couldn't remember where I saw it, and I couldn't find it.  Today 
I found it.

Take a look at: http://dev.mysql.com/doc/mysql/en/Miscellaneous_functions.html
and scroll down to UUID()

Returns a Universal Unique Identifier (UUID) generated according to ``DCE 1.1: 
Remote Procedure Call'' (Appendix A) CAE (Common Applications Environment) 
Specifications published by The Open Group in October 1997 (Document Number 
C706). A UUID is designed as a number that is globally unique in space and 
time. Two calls to UUID() are expected to generate two different values, even 
if these calls are performed on two separate computers that are not connected 
to each other.

This was added in MySQL 4.1.2.  You didn't mention the version you were using, 
but 4.1 is production now.

Hope that helps!!

j- k-

On Monday 20 December 2004 05:33, Andrew Mull said something like:
 I'm working on a rather large database with many cross-linked tables
 currently using auto increment IDs.  The system is primarily a web based
 system, however, there will be times that the system will be run as a stand
 alone server...meaning no internet connection is available.

 The question arises that if someone enters information to the database on
 the website, while others are entering information on the local database,
 what is the best way to merge the data?  I would imagine that we would run
 into many duplicate auto increment IDs.

 I'm sure that for one table insert, this would not be a problem as I could
 store the SQL statement in a text file without the ID specified, and run it
 as a batch process on the live server when we get connectivity.  But I
 don't have a handle on how to update the sub tables that have a FK pointer.

 Any ideas?

 Thanks!
 -Andy

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



GRANT can't grant with a password?

2005-01-07 Thread Joshua J. Kugler
I've read the sections on GRANT's and permissions, and done some googling, and 
still haven't found what I'm looking for.

I have a user that has USAGE and GRANT global privs and all privs and GRANT on 
database rubric.

However, when they try to run this query:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON rubric.* TO 'user'@'localhost' 
IDENTIFIED BY 'password';

They get the error

ERROR 1044: Access denied for user 'user'@'host' to database 'mysql'

They can log in just fine, so it is not a matter of host name.

I found a post that seemed to allude to the fact that a user with GRANT could 
only create a new user via GRANT if there was not IDENTIFIED BY clause. 
(However, a user with write permissions to the mysql database could).  I 
verified this to be the case when this query,

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON rubric.* TO 'user'@'localhost'

run as the user in question, worked and created the user, albeit with no 
password.

Is there a way for a user with GRANT privs to create a user *with* a password?

j- k-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

-- 
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-07 Thread Joshua J. Kugler
Take a look at http://mysql.he.net/doc/mysql/en/Upgrade.html

j- k-

On Tuesday 07 December 2004 15:01, A. Clausen said something like:
 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]

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: MySQL server is taking all my hardrive space

2004-10-21 Thread Joshua J. Kugler
Unless you're running InnoDB (with lots of data and indexes) I would assume 
your trouble has to do with the fact that you are running I am running 
4.0.20-Max-log.  (Namely the log part)  How large are the logs 
in /var/lib/mysql?

j- k-

On Wednesday 20 October 2004 22:41, C.F. Scheidecker Antunes said something 
like:
 Hello,

 I have a server with 18Gb of space. I have ran du to figure out how the
 harddrive is being used and I realized that the directory that is taking
 the most space is /var/lib/mysql

 I know that now I have much less database records than I used to have
 and I have the same database structure having not change any index or
 table.

 So I think there must be a bug and somehow the mysql server is consuming
 my entire harddrive.

 I have also ran show table status to see the actual physical size of
 each table. They do not correspond to 10Gb, much less in fact, but the
 dir where MySQL resides /var/lib/mysql is
 consuming about 10Gb of my hard drive.

 What can be going wrong here?

 I am running 4.0.20-Max-log

 Thanks,

 C.F.

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: MySQL Secure Connection(e.g. SSL) Question

2004-08-25 Thread Joshua J. Kugler
Something else to check out is Stunnel.  It creates SSL tunnels between hosts 
without requiring logins (basically port redirection).  Also, MySQL has built 
in SSL now, so you might want to look at that.

j- k-

On Wednesday 25 August 2004 08:10 am, [EMAIL PROTECTED] said something like:
 Something else I have done in the past was to use Cygwin to create an SSH
 session with the remote computer and use the remote computer's MySQL
 client/tools.

 If you are used to working in a Terminal Server session (I think they
 now call it Remote Desktop Connectivity) it will feel very familiar.  I
 also fiddled around with Cygwin long enough and hard enough (translate: I
 spent lots of time reading groups and docs and experimenting) to enable me
 to create local X windows so that I could run a full GUI shell (GNOME or
 KDE, I can't remember) remotely. Please don't ask me how I got it all set
 up as I only did it once and it was a long while ago. I know it's possible
 because I did it and it worked well for my situation.

 FWIW,
 Shawn Green
 Database Administrator
 Unimin Corporation - Spruce Pine

 Paul Maine [EMAIL PROTECTED] wrote on 08/24/2004 12:03:19 PM:
  I need to connect to a remote MySQL database from a PC using SSL. I

 would

  prefer to connect using perl DBD. Does anyone have a suggestion how I

 can

  accomplish this task or an alternative solution?
 
  Thank You
 
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: No Response from Server

2004-07-13 Thread Joshua J. Kugler
Can you give us more insight into your database layout?
Are you using indexes?
How many clients are accessing it?
What kind of queries?
Are those queries written to take advantage of the indexes?

j- k-

On Monday 12 July 2004 10:28 pm, s.ahmad said something like:
 Hello,
  Dear All,


 i'm now a days having quite big problem, i would like to get help from
 you guyz, ...  we have Railways Reservation System of whole country
 hosted on our servers which is purely in php MYSQL.

 problem is that when the country wide offices start working, our
 server CPU uUsage goes upto 99% and oftenly it chokes the server. We
 tried it on blank server with only 1 site hosted. the server specs
 were

 1 GB RAM
 Xeon Dual Processor
 100 GB HDD

 but same, a blank serevr was also choked by the usage. This started
 happening bcz. DB is growing day by day and is quite big in size. Can
 any body tell me what can i do. Should i use MYSQL Clusters or any
 other thing ... i'll be so gratefull

 regards,
 s.ahmad
 Lahore, Pakistan

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: No Response from Server

2004-07-13 Thread Joshua J. Kugler
50 clients accessing the database should not overload a system like that.  I 
would recommend posting your database layout.  That might help in diagnosing 
the problem.

j- k-

On Monday 12 July 2004 11:08 pm, s.ahmad said something like:
 thankyou for your kind attention.

 there are 50+ Reservation stations in the country. Where multiple
 operators are sitting and reserving seats. Indexes are being used in
 the DB. as i am related to hosting company, i havent seen if they are
 taking advantage of indexes.


 regards,
 s.ahmad

 On Mon, 12 Jul 2004 22:36:10 -0800, Joshua J. Kugler

 [EMAIL PROTECTED] wrote:
  Can you give us more insight into your database layout?
  Are you using indexes?
  How many clients are accessing it?
  What kind of queries?
  Are those queries written to take advantage of the indexes?
 
  j- k-
 
  On Monday 12 July 2004 10:28 pm, s.ahmad said something like:
   Hello,
Dear All,
  
  
   i'm now a days having quite big problem, i would like to get help from
   you guyz, ...  we have Railways Reservation System of whole country
   hosted on our servers which is purely in php MYSQL.
  
   problem is that when the country wide offices start working, our
   server CPU uUsage goes upto 99% and oftenly it chokes the server. We
   tried it on blank server with only 1 site hosted. the server specs
   were
  
   1 GB RAM
   Xeon Dual Processor
   100 GB HDD
  
   but same, a blank serevr was also choked by the usage. This started
   happening bcz. DB is growing day by day and is quite big in size. Can
   any body tell me what can i do. Should i use MYSQL Clusters or any
   other thing ... i'll be so gratefull
  
   regards,
   s.ahmad
   Lahore, Pakistan
 
  --
  Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
  Every knee shall bow, and every tongue confess, in heaven, on earth, and
  under the earth, that Jesus Christ is LORD -- Count on it!
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:   
  http://lists.mysql.com/[EMAIL PROTECTED]

 --
 s.ahmad [EMAIL PROTECTED]
 www.shakeelahmad.net

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: table scope

2004-07-13 Thread Joshua J. Kugler
If the db's are on the same server and you have the needed permissions for all 
of them, just prefix the table names with the db names like so:

select dbname.tablename.field1, dbname2.tablename2.field2. and so on.  
Your FROM will need similar qualifiers.

j- k-

On Tuesday 13 July 2004 11:28 am, Alex said something like:
 If I have tables within 3 different mysql dbs, is there a way for me
 to combine all 3 tables into a scope so that I may run a query
 accessing information from those 3 tables within 3 mysql dbs?

 In MS Access/MSSQL, it would be called linking, but I couldn't find
 out whether mysql has that or not.

 If not, are there any alternatives anyone can suggest?

 Thanks
 Alex

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: mySQL on MAC

2004-07-13 Thread Joshua J. Kugler
I gather you have used MySQL on other platforms?  Won't be much different.  OS 
X is BSD Unix-based, so it will be very similar (if not identical) to using 
MySQL on a Unix box.

Have fun.

Or were you asking about compiling, etc?

j- k-

On Tuesday 13 July 2004 03:21 pm, MySQL Junkie said something like:
 We've just bought a new Power Mac G5 Macintosh computer for the office and
 I'll be needing to do some database engineering work using it. I've never
 worked with mySQL on MAC, so I really have no experience with what happens
 on a MAC.. Anyone here who works with mySQL on a MAC? Any helpful insights?

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: DBF to MySQL

2004-07-08 Thread Joshua J. Kugler
Hmm...that seems like a bug...if those commas are inside quotes, they should 
not be interpreted as field delimiters.  You might want to check if there are 
any stray quotes elsewhere on the line that are messing up the 
interpretation.  If not, then I would think that to be a bug.

j- k-

On Thursday 08 July 2004 09:23 am, John Mistler said something like:
 I appreciated your first email, regardless of whether or not I was able to
 make it work.  Any response is welcome!  I am having some trouble with the
 final result using the CVS file:  some of the content uses commas i.e.
 Chinchilla Zúñiga, Guillermo and gets split up between two fields.  This
 whole process is pretty messy, but I'm sure I will find a solution.  The
 tools I was directed to below at freshmeat.net are a little out of my
 league.  I am a Macintosh user that programs in applescript, a little
 obj-C, and SQL.  I don't know if I can even implement those classes.
SNIP
  LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable
  FIELDS TERMINATED BY ',' ENCLOSED BY ''
  LINES TERMINATED BY '\n';


-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: problem importing .csv (excel format) into mysql

2004-07-08 Thread Joshua J. Kugler
On Thursday 08 July 2004 02:35 pm, Chip Wiegand said something like:
 I was sent an excel file from a remote office, and need to put the data
 into a mysql database to be displayed on our web site. I removed a few
 lines of fluff from the excel file and saved it as .csv (using .csv
 (ms-dos)). When I try to import the file it gives me a duplicate entry for
 key 1 error. I have looked through the file and the duplicate item it is
 pointing to does not exist in the file. Here is the error:

 mysql load data infile '/usr/home/autopilots/whs4.csv'
 - into table refurbs
 - fields terminated by ','
 - optionally enclosed by ''
 - lines terminated by '\n';
 ERROR 1062: Duplicate entry '2147483647' for key 1

That sounds like you have a number that is too large for the field, and MySQL 
is rolling it over.  What is the type of your key?  Int? Big int?  And what 
is in that field in the Excel file?  What kind of numbers?

j- k-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: INSERT DISTINCT?

2004-07-07 Thread Joshua J. Kugler
Certainly, it's called making a unique index on the field(s) you want to keep 
unique.

Hope that helps.

j- k-

On Wednesday 07 July 2004 12:48 pm, John Mistler said something like:
 Is there a way to do an INSERT on a table only if no row already exists
 with the same info for one or more of the columns as the row to be
 inserted? That is, without using a method outside SQL?

 Thanks,

 John

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: DBF to MySQL

2004-07-07 Thread Joshua J. Kugler
I'm sure it did...DBF and XLS files are not plain text.  What Chincilla gave 
your was a bit of code for importing CSV files, after they had been exported 
from Excel.  I'm not sure *why* he gave you that code.

You can do one of two things.  1) Open up those files in Excel (it will also 
open DBF files) and export them as CSV, or 2) find a class and 
programmatically import them (search freshmeat.net for 'dbf').

If you need more info, holler.

j- k-

On Tuesday 06 July 2004 07:55 pm, John Mistler said something like:
 For some reason, the imported information showed up as garbled nonsense.
 The file I was importing was an .xls file.  Do you know if there is another
 TERMINATED BY I should be using?  If not, I wonder how I can find out?

 The other question I have is:  do I have to create a table within the MySQL
 database with exactly the right number of columns ahead of time for the
 import to work? - this is what I did.  If so, is there a way to import info
 from a .dbf or .xls file without knowing the structure of the table ahead
 of time?

 Thanks,

 John

 on 7/6/04 3:59 PM, Chinchilla Zúñiga, Guillermo at [EMAIL PROTECTED]

 wrote:
  Try, for example:
 
  LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable
  FIELDS TERMINATED BY ',' ENCLOSED BY ''
  LINES TERMINATED BY '\n';
 
 
  -Mensaje original-
  De: John Mistler [mailto:[EMAIL PROTECTED]
  Enviado el: Martes, 06 de Julio de 2004 04:51 p.m.
  Para: [EMAIL PROTECTED]
  Asunto: DBF to MySQL
 
  I am wanting to parse the info in a .dbf file (or .xls file for that
  matter) and place it in a table in a MySQL database.  Is this something
  that I can do with the server side MySQL application, or do I need to
  figure out a way to do it on the client side?  Any description of the
  method would be very welcome!
 
  For what it is worth, I am a Mac OSX.3 user.
 
  Thanks,
 
  John

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: BLOB's - General Guidance

2004-05-27 Thread Joshua J. Kugler
There is one instance in which it is *not* convenient to store in seperate 
files: when you are exporting to another machine (maybe a sub set of data 
from an internal server to an external web server) or doing replication.

j- k-

On Wednesday 19 May 2004 01:01 pm, Greg Willits said something like:
 On May 19, 2004, at 1:19 PM, David Blomstrom wrote:
  I'd like to get some feedback on storing images in
  MySQL databases. The stuff I've read so far suggests
  that it's fairly difficult to work with images in
  MySQL, and they also slow down databases.
 
  I've also read that there isn't much you can do with
  BLOB's that you can't do with PHP manipulating images
  stored in an ordinary folder.
 
  So I just wondered if BLOB's are worth my time. For
  example, I'm working on a database with information
  about the 50 states. If I have maps of each state,
  pictures of each state's capital, etc., is there some
  BLOB feature that I would find really useful?

 All conventional wisdom I've ever come across for this type of
 application is that there's no advantage to keeping the image in the db
 itself. Just keep them as files on the server, store a filename /or
 location in the db if necessary, and use your middleware to display the
 images. Its faster, easier to maintain, and easier to backup. IMO,
 storing images in the db just bloats the file and complicates all the
 backup issues.

 -- greg willits

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Last inserted ID

2004-05-05 Thread Joshua J. Kugler
Well, you don't need the distinct.

Are you inserting with your PHP script?  LAST_INSERT_ID(), as per the manual, 
only returns the id from the last insert on that connect.  You cannot get the 
LAST_INSERT_ID() for another connection.

j- k-

On Wednesday 05 May 2004 05:11 pm, Erich Beyrent said something like:
 Hi there,

 I seem to be having a problem retrieving the last inserted ID for a
 table.

 The query I am using is as follows:

 mysql select distinct LAST_INSERT_ID() as LastID from listings;
 ++

 | LastID |

 ++

 |   3575 |

 ++
 1 row in set (0.00 sec)

 However, when I run this from my PHP script, I get a value of 0.

 Any clues as to how to resolve this?

 Thanks!

 -Erich-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Joshua J. Kugler
It sounds like someone upgraded your PHP libraries, and forget to include 
MySQL support.  Do you admin this server, or does someone else?

j- k-

On Monday 03 May 2004 09:20 am, Chip Wiegand said something like:
 I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
 freebsd-5.1.
 It has been working fine for the past few years, now all of a sudden today
 I get an undefined function error. This is from httpd-error.log -

  PHP Fatal error:  Call to undefined function:  mysql_connect() in
 /...stuff

 This is the connection function I am using -

 ? $conn=mysql_connect(localhost,user,) or die (Could not connect
 to the server);
 mysql_select_db(simradusa, $conn) or die (Could not get the database);
 ?

 If I comment out the above function the pages will load but of course none
 of the database stuff will load. If I leave the lines with the connect
 function uncommented the page fails to load altogether.

 As I mentioned - this just suddenly came about either today or over the
 weekend, I know it worked friday when I left the office. This particular
 machine has been up for 151 days 22 hours without a hiccup.

 thanks for the help,
 --
 Chip Wiegand
 Computer Services
 Simrad, Inc
 www.simradusa.com
 [EMAIL PROTECTED]

 There is no reason anyone would want a computer in their home.
  --Ken Olson, president, chairman and founder of Digital Equipment
 Corporation, 1977
  (Then why do I have 8? Somebody help me!)

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Connect string for ASP

2004-05-01 Thread Joshua J. Kugler
Ummm...you can't do that.  The MyODBC driver is used by the script to connect 
via ODBC.  It has to be in a place where ASP can find and use it.  It does no 
good if it is on another machine.  The driver does not need to reside on the 
server machine: it is a client-side piece of software.

j- k-

On Thursday 29 April 2004 11:06 am, michael johnson said something like:
 The connection I am trying to make is from a website where the hosting
 machine will not have Myodbc installed and the database I am trying to
 connect to is on another Internet visible server where MySQL is installed
 and myodbc is installed.

 -Original Message-
 From: Victor Pendleton [mailto:[EMAIL PROTECTED]
 Sent: 29 April 2004 19:54
 To: 'Joy Johnson '; Victor Pendleton; ''michael johnson ' ';
 ''[EMAIL PROTECTED] mysql. com ' '
 Subject: RE: Connect string for ASP


 You will need to have MyODBC installed. You do not need to create a DSN.

 -Original Message-
 From: Joy Johnson
 To: 'Victor Pendleton'; 'michael johnson '; '[EMAIL PROTECTED] mysql. com '
 Sent: 4/29/04 1:50 PM
 Subject: RE: Connect string for ASP

 I presume I do not need myodbc installed anywhere to do this.

 Thanks for the prompt response

 BPEnet Sales  Support Team

 BPEnet EMEA
 Sun iForce Premier Solution, Sales, Change Management  Development
 Partner
 Part of the BPE Group Limited
 13 Austin Friars
 London
 EC2N 2JX
 Tel: 0870 922 0247 / 0207 670 1690
 Fax: 0207 670 1717
 E-mail: [EMAIL PROTECTED]
 Web: www.bpenet.net
 BPEnet Offices in: Sussex, London  Dublin


 -Original Message-
 From: Victor Pendleton [mailto:[EMAIL PROTECTED]
 Sent: 29 April 2004 19:46
 To: 'michael johnson '; '[EMAIL PROTECTED] mysql. com '
 Cc: 'Joy Johnson '
 Subject: RE: Connect string for ASP


 ConnectStr = Driver={MySQL ODBC 3.51 Driver};server=;DB=;UID=;PWD=


 -Original Message-
 From: michael johnson
 To: [EMAIL PROTECTED] mysql. com
 Cc: Joy Johnson
 Sent: 4/29/04 1:33 PM
 Subject: Connect string for ASP

 Dear All

 I am using ASP. Can anyone give me the connection code to connect to a
 MySQL database without using ODBC DSN?

 Thanks

 Michael Johnson
 Director

 BPEnet EMEA
 Sun iForce Premier Solution, Sales, Change Management  Development
 Partner Part of the BPEnet Group Limited 13 Austin Friars London EC2N
 2JX Tel:. +44 (0)870 922 0247 / (0)207 670 1690
 Fax: +44 (0)207 670 1717
 E-mail: [EMAIL PROTECTED]
 Web: www.bpenet.net
 BPEnet Offices in ~ Sussex, London  Dublin

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: libmysql setting it's own signal handlers?

2004-05-01 Thread Joshua J. Kugler
OK...thanks for the clarification.  It helps.  And it's good to know that what 
I'm doing won't break anything.

j- k-

On Thursday 29 April 2004 07:16 pm, Sasha Pachev said something like:
 Joshua J. Kugler wrote:
  I have a program that is using (via a front end library) libmysql.  If I
  set up a signal handler before I initialize libmysql, my signal handler
  is not called when that signal is sent to the process.  If I move the
  line of code that sets the signal handler to *after* the line that
  initializes libmysql, my signal handler works fine.
 
  What does libmysql do to the signal handlers when it initializes?  I
  don't have the source for it in front of my, or I would probably go
  digging my self.  Running up against a deadline as it is. :)

 mysql client library traps SIGPIPE to deal with some weird threading
 issues. The problem is that is some cases, a threaded program might get a
 spurious SIGPIPE, and then the program crashes if it is not handled. What
 you are doing should be just fine - all that happens inside is that SIGPIPE
 is ignored. The only problem is if you really want to handle SIGPIPE while
 in the middle of a mysql call. In that case, recomple the client without
 --enable-thread-safe-client or hack the source.

 --
 Sasha Pachev
 Create online surveys at http://www.surveyz.com/

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: triggers (or too-many-crappy-questions)

2004-05-01 Thread Joshua J. Kugler
 I found that the Postgres mailing list was full of very polite, super
 helpful people. I found that the MySQL list was full of relatively cranky
 people with little patience.

 Over that last year, I've I think I've discovered why. The average quality
 of the questions posted on the MySQL list are quite low (compared to the
 Postgres lists), and I think many of the people who are in a position to
 respond are fed up.

That's part of the price of fame.  You get more people who know of MySQL as 
a buzzword, so think Oh, I'll try that.  In addition, there are a lot of 
open source programs out there that use MySQL as their back end, thus, many 
more people are trying to install MySQL.  In the end, you get the people that 
don't and/or refuse to read documentation, and just post to the list.

 Sir,

 How I use MySQL? Why I want use it? Where I download from?

 Kindest regard.

Not to disparage our foreign members, but it does seem that often those for 
whom English is not their mother tongue do not want to read through pages of 
English documentation.  There are other languages for the docs I believe, but 
those don't always get found.

 Maybe a new MySQL list is needed - one called Dumb Questions, and when
 someone posts one to any other list, someone can quickly respond, Please
 repost this on the MySQL Dumb Questions list, as that's where it belongs.

What is needed is moderation.  I would happily volunteer to serve as moderator 
on this list (check back later to see if I've changed my mind :), as it is 
not terribly high traffic (and would be even lower if we eliminated all the 
newbie posts).  When a post came across the list that is answered in the 
archives or the docs, a message could be bounced back saying so.  It would 
probably cut list traffic by half.

j- k-

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



libmysql setting it's own signal handlers?

2004-04-29 Thread Joshua J. Kugler
I have a program that is using (via a front end library) libmysql.  If I set 
up a signal handler before I initialize libmysql, my signal handler is not 
called when that signal is sent to the process.  If I move the line of code 
that sets the signal handler to *after* the line that initializes libmysql, 
my signal handler works fine.

What does libmysql do to the signal handlers when it initializes?  I don't 
have the source for it in front of my, or I would probably go digging my 
self.  Running up against a deadline as it is. :)

Thanks!

j- k-

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: What is your mysql debugging strategy?

2004-04-27 Thread Joshua J. Kugler
On Tuesday 27 April 2004 04:26 am, zzapper said something like:
 Even though I solved the following problem myself, I'd like to know
 what debugging strategy people use to solve problems when they get the
 dreaded Error in Mysql look in the manual

Fire up MySQL CC and paste the SQL in there, and see what error it gives me. 
As in 'You have an error near' type messages.

j- k-

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: SELECT duplicate rows

2004-04-21 Thread Joshua J. Kugler
Yes, there is a way.  It's called joins.  :) I don't remember the exact syntax 
off the top of my head, but the approach is thus:

Do a self join on the table and select records that match in their first three 
columns, but do not have the same primary key (you *do* have primary keys on 
your table, don't you?).  If you don't add one for this excercise.

j- k-

On Tuesday 20 April 2004 11:22 pm, John Mistler said something like:
 Is there a way to use a SELECT statement (or any other, for that matter)
 that will look at every table in a database and return every row whose
 first 3 columns are duplicated in at least one other row in any of the
 tables? Essentially, a command to find duplicate entries in the database .

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: SELECT duplicate rows

2004-04-21 Thread Joshua J. Kugler
Well, doing on all tables at once woule probably bring the server to its knees 
due to the cartesian product producing a VERY large temporary table.  You can 
do it on two tables at once like this (if my memory serves):

SELECT * from mytable as t1, mytable as t2
WHERE t1.column1 = t2.column1 AND
t1.column2 = t2.column2 AND
t1.column3 = t2.column3 AND
t1.id  t2.id

Of course, you can extend that to as many tables as you want, but the syntax 
and performance complications quickly arise.

I would recommend comparing all your tables to one another, two at a time.  A 
quick perl or C script should accomplish this quickly.  For 10 tables, that 
is only 45 queries. Not bad.

j- k-


On Wednesday 21 April 2004 12:56 am, John Mistler said something like:
 Thanks for the response, Joshua.

 I am so very new to MySQL, that I am afraid I require more guidance.

 Is there a way to join ALL tables in a database rather than just one table
 to itself, or one particular table to another?

 SELECT * FROM allTables WHERE column1=column1 AND column2=column2 AND
 column3=column3;

 I know this syntax is off the mark--it should specify:
 table1.column1=table2.column1, etc.  However, I need it to match columns on
 all of the tables in the database (of which there are many), rather than
 just two.

 Any ideas?

 Thanks,

 John

 on 4/21/04 12:57 AM, Joshua J. Kugler at [EMAIL PROTECTED] wrote:
  Yes, there is a way.  It's called joins.  :) I don't remember the exact
  syntax off the top of my head, but the approach is thus:
 
  Do a self join on the table and select records that match in their first
  three columns, but do not have the same primary key (you *do* have
  primary keys on your table, don't you?).  If you don't add one for this
  excercise.
 
  j- k-
 
  On Tuesday 20 April 2004 11:22 pm, John Mistler said something like:
  Is there a way to use a SELECT statement (or any other, for that matter)
  that will look at every table in a database and return every row whose
  first 3 columns are duplicated in at least one other row in any of the
  tables? Essentially, a command to find duplicate entries in the database
  .

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Learning curve

2004-04-15 Thread Joshua J. Kugler
Mike -

You didn't indicate your department, so I'm not sure what your background is.  
Your message, overall, is a bit scary, as any university that far behind 
right now would be worrisome.  I'm not exactly sure what you're asking for 
(as you didn't ouline your requirements), but I would first take a look on 
sites like sourceforge or freshmeat for systems that already do what you 
want.  I'm sure the kind of record keeping you do has been done before.

But as to your main quesiton, it is very doable.  You just need to keep in 
mind multi-user issue like record locking.  Search the archives for messages 
by me about record locking for an elegant way to do it via a flag field.  If 
you can't find it, let me know, and I'll type it up again.

j- k-

On Thursday 15 April 2004 02:06 pm, Mike T. Caskey said something like:
 Hi all!

 I'm wondering if anyone can help me find out how much time/training is
 needed to accomplish my task using MySQL.

 My background: I'm fresh to the world of MySQL and databases in
 general.  I do have some fundamental knowledge in the area of
 programming and databases, but nothing too in-depth.

 My story:  I work for a University that is seemingly falling behind the
 technical times.  My department is using MS Access as the primary
 software for handling data, but we're still mainly hard-copy for our
 records-management.  Obviously, there are problems with keeping
 hard-copy for everything.  I was buried in paperwork for a short while
 before I decided to create simple databases/forms using OpenOffice.org,
 since it was so easy.  Someone in management noticed the consistency
 emerging from my office and inquired. When I told them about my
 databases, they decided everyone in the department could benefit from
 them and assigned the project of making this available to all.

 My problem:  My databases are single-user systems for use in
 OpenOffice.org and would be difficult to roll them out to my entire
 team.  I don't want to install OO.o on everyones computer and I don't
 want to learn MS Access as it is known for being a temporary solution.
 So I need something that can keep up with the times and can be rolled
 out easily (web interface?).  I also need to be able to append scanned
 images to records (PDF or JPEG?).  This is all pretty complex and I'm
 definitely not technically equipped to create this just yet.

 MySQL?:  I believe a good question would be whether or not MySQL would
 be a good solution for this.  What do you think?  Also, how long would
 it take me to learn the necessary information?  Lastly, how long would
 it take to develop such a system?

 I appreciate your time and information!
 Thanks,
 Mike T. Caskey

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Multi-User Issues

2004-04-15 Thread Joshua J. Kugler
Just to get a general feel for interest:

Should I just whip up something quick and dirty and post to the mailing list, 
or should I work up a nice page or two and put it on a web site?

Anyone else interested?

Warnring: to work up something, it might be a week or two as school is getting 
really busy right now, but I'd love to do it, as I've used MySQL in 
multi-user environments.

j- k-

On Thursday 15 April 2004 03:05 pm, Justin Palmer said something like:
 Hi Joshua,

 I would love to here more about multi-user issues (like record locking).
 I searched the archives by the title and by your name with no luck. If
 you don't feel like going into detail, could you point out some good
 links to learn more about the subject.

 Regards,

 Justin Palmer



 -Original Message-
 From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
 Sent: Thursday, April 15, 2004 3:27 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Learning curve


 Mike -

 You didn't indicate your department, so I'm not sure what your
 background is.
 Your message, overall, is a bit scary, as any university that far behind

 right now would be worrisome.  I'm not exactly sure what you're asking
 for
 (as you didn't ouline your requirements), but I would first take a look
 on
 sites like sourceforge or freshmeat for systems that already do what you

 want.  I'm sure the kind of record keeping you do has been done before.

 But as to your main quesiton, it is very doable.  You just need to keep
 in
 mind multi-user issue like record locking.  Search the archives for
 messages
 by me about record locking for an elegant way to do it via a flag field.
 If
 you can't find it, let me know, and I'll type it up again.

 j- k-

 On Thursday 15 April 2004 02:06 pm, Mike T. Caskey said something like:
  Hi all!
 
  I'm wondering if anyone can help me find out how much time/training is
 
  needed to accomplish my task using MySQL.
 
  My background: I'm fresh to the world of MySQL and databases in
  general.  I do have some fundamental knowledge in the area of
  programming and databases, but nothing too in-depth.
 
  My story:  I work for a University that is seemingly falling behind
  the technical times.  My department is using MS Access as the primary
  software for handling data, but we're still mainly hard-copy for our
  records-management.  Obviously, there are problems with keeping
  hard-copy for everything.  I was buried in paperwork for a short while
 
  before I decided to create simple databases/forms using
  OpenOffice.org, since it was so easy.  Someone in management noticed
  the consistency emerging from my office and inquired. When I told them
 
  about my databases, they decided everyone in the department could
  benefit from them and assigned the project of making this available to
 
  all.
 
  My problem:  My databases are single-user systems for use in
  OpenOffice.org and would be difficult to roll them out to my entire
  team.  I don't want to install OO.o on everyones computer and I don't
  want to learn MS Access as it is known for being a temporary solution.
 
  So I need something that can keep up with the times and can be rolled
  out easily (web interface?).  I also need to be able to append scanned
 
  images to records (PDF or JPEG?).  This is all pretty complex and I'm
  definitely not technically equipped to create this just yet.
 
  MySQL?:  I believe a good question would be whether or not MySQL would
 
  be a good solution for this.  What do you think?  Also, how long would
 
  it take me to learn the necessary information?  Lastly, how long would
 
  it take to develop such a system?
 
  I appreciate your time and information!
  Thanks,
  Mike T. Caskey

 --
 Joshua J. Kugler
 Fairbanks, Alaska
 Computer Consultant--Systems Designer
 .--- --- ...  ..- .--.- ..- --. .-.. . .-.
 [EMAIL PROTECTED]
 ICQ#:13706295
 Every knee shall bow, and every tongue confess, in heaven, on earth, and
 under
 the earth, that Jesus Christ is LORD -- Count on it!

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

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Too many server instances

2004-04-12 Thread Joshua J. Kugler
Each one of those is a thread, not a server instance.  I assume you're using 
Linux, since linux shows separate threads as processes.

j- k-

On Saturday 10 April 2004 06:48 pm, Emmett Bishop said something like:
 Howdy all,

 I am having trouble configuring my server parameters
 with my.cnf because there seems to be several mysql
 server instances (mysqld processes) running on my
 linux box. What I would like to do is bump up the
 innodb_buffer_pool_size on the server to 512M (the box
 has 3GB of RAM). The problem is that there seem to be
 several instances of mysql server running concurrently
 on the box. Each one of them allocates 512M for the
 buffer pool and the box grinds to a halt, completely
 out of RAM to do anything!

 I've included a snippet of the top command display (I
 hope that you can read it easily).


-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: disabling backslash as an escape character in strings

2004-04-08 Thread Joshua J. Kugler
Are you using a high level library such as Perl::DBI?  If so, you should run 
all your strings the quote method.  That will quote it properly for each 
database you connect to.  If you are connecting to all the databases yourself 
using custom code, I would recommend you find some database neutral libraries 
and go from there.

j- k-

On Thursday 08 April 2004 01:37 pm, Christos Karras said something like:
 Is there a way to disable the use of the backslash as an escape
 character in strings? I need to use an application that's designed to
 work on any database server supporting ANSI SQL. When it generates SQL
 insert/update queries, it doesn't escape backslashes in strings, because
 the ANSI SQL standard doesn't require backslashes to be escaped.

 So to insert the value \, the application generates the following query:
 INSERT INTO (test) VALUES('\');
 Which causes an error in MySQL because it thinks the \ is an escape
 character and the string is not closed.

 If I modify the application to escape backslashes by replacing \ by \\,
 it works with MySQL, but with other databases that don't interpret the
 backslash as an escape character, it inserts two backslashes instead of
 one.

 What could I do to tell MySQL it should interpret strings in the
 standard way?
 I tried starting mysqld in ANSI mode (mysqld-max-nt --ansi) but it
 doesn't solve the problem.

 I would also prefer a per-connection way to fix this, is there an option
 I can set when connecting that won't affect other connections? I also
 have other applications using the same MySQL server, some of which are
 designed specifically for MySQL, so they may escape backslashes in the
 MySQL way and switching the whole server to ANSI mode would break them.

 I'm using MySQL 3.23 but I'm willing to upgrade to the latest 4.0x if it
 can solve this problem.

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: MSSQL Server to MYSQL migration problems

2004-04-06 Thread Joshua J. Kugler
Please reply to the list, and not to me.  Thanks.

Making the MySQL indexes would be your responsibility.  Importing the data 
would most likely not import the index definitions also.  You need to 
recreate those.  Your explain seems to indicate that you have *no* indexes on 
your table.  I would guess that your query doesn't hang it just takes a very 
long time to return.

j- k-

On Monday 05 April 2004 06:00 pm, Rodrigo Galindez said something like:
 Joshua, maybe there are some ineficient indexes, I don't know, because
 the MSSQL database was not made by me. Iam just trying to migrate the
 database to MYSQL and check that everything works fine.
 My query is
 SELECT * FROM postulantes LIMIT 1,30
 My phpmyadmin hungs :(
 When i put EXPLAIN in the query, phpmyadmin returns the following:
 table typepossible_keys   key key_len ref rowsExtra
 postulantes   ALL /NULL/  /NULL/  /NULL/  /NULL/  4499

 Thanks for your help, im still confused :(

 Joshua J. Kugler wrote:
 MySQL is very stable on large databases...I would suspect inefficient
  indexes. What does your query look like?  What is the output when you put
  EXPLAIN in front of your query?
 
 I don't know anything about SQLYog blob display, so can't comment there.
 
 j- k-
 
 On Monday 05 April 2004 05:41 pm, Rodrigo Galindez said something like:
 Im using SQLYog to display results. It lets me to display blob data
 types. By the way, i was trying to do some queries with phpmyadmin ...
 but, it hungs ... hmmm ... inestability with large databases in mysql
 maybe ? :S
 
 Joshua J. Kugler wrote:
 You can't?  How are you trying to display? What are you using?  A CGI
 script? A database utility?  Something else?  We need  a bit more
 information to answer the question.
 
 j- k-
 
 On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like:
 Hello list,
Recently I've been in the job of migrating a large (about 1.5GB)
 database build in MSSQL Server to MYSQL. The migration was done OK, I
 used the SQLYog utility to do this. The problem is that one table has
 image column types ... I tried to view this column types (blob data
 types now) but I can't in the MYSQL migrated data base, ... it just
 don't display anything. Any ideas ? Is there any issue problem when
 migrating MSSQL image column types to MYSQL ?
Thanks in advance, cheers from Argentina,

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: MSSQL Server to MYSQL migration problems

2004-04-05 Thread Joshua J. Kugler
You can't?  How are you trying to display? What are you using?  A CGI 
script? A database utility?  Something else?  We need  a bit more information 
to answer the question.

j- k-

On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like:
 Hello list,
 Recently I've been in the job of migrating a large (about 1.5GB)
 database build in MSSQL Server to MYSQL. The migration was done OK, I
 used the SQLYog utility to do this. The problem is that one table has
 image column types ... I tried to view this column types (blob data
 types now) but I can't in the MYSQL migrated data base, ... it just
 don't display anything. Any ideas ? Is there any issue problem when
 migrating MSSQL image column types to MYSQL ?
 Thanks in advance, cheers from Argentina,

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: MSSQL Server to MYSQL migration problems

2004-04-05 Thread Joshua J. Kugler
MySQL is very stable on large databases...I would suspect inefficient indexes.  
What does your query look like?  What is the output when you put EXPLAIN in 
front of your query?

I don't know anything about SQLYog blob display, so can't comment there.

j- k-

On Monday 05 April 2004 05:41 pm, Rodrigo Galindez said something like:
 Im using SQLYog to display results. It lets me to display blob data
 types. By the way, i was trying to do some queries with phpmyadmin ...
 but, it hungs ... hmmm ... inestability with large databases in mysql
 maybe ? :S

 Joshua J. Kugler wrote:
 You can't?  How are you trying to display? What are you using?  A CGI
 script? A database utility?  Something else?  We need  a bit more
  information to answer the question.
 
 j- k-
 
 On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like:
 Hello list,
 Recently I've been in the job of migrating a large (about 1.5GB)
 database build in MSSQL Server to MYSQL. The migration was done OK, I
 used the SQLYog utility to do this. The problem is that one table has
 image column types ... I tried to view this column types (blob data
 types now) but I can't in the MYSQL migrated data base, ... it just
 don't display anything. Any ideas ? Is there any issue problem when
 migrating MSSQL image column types to MYSQL ?
 Thanks in advance, cheers from Argentina,

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Transaction Not supported

2004-03-31 Thread Joshua J. Kugler
Hmm...but it *should* work.  DBI::mysql should implement those calls and 
transform them to BEGIN/COMMIT calls.  I wonder why it doesn't.

j- k-

On Tuesday 30 March 2004 11:24 pm, Jonas Lindén said something like:
  Sorry Mike, Joshua is absolutly correct. Dont listen to my nonses ;)

  What I did was trying to use something like this which  to my knowledge
  doesnt work on MySQL servers.

  $dbh-commit();
 $dbh-rollback();

  /Jonas

  - Original Message -
  From: Joshua J. Kugler [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Wednesday, March 31, 2004 9:02 AM
  Subject: Re: Transaction Not supported
 
  On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:
   I dont think that transactions are supported (yet?) by the PERL DBI.
 
  to  Mike Blezien [EMAIL PROTECTED].  My response follows.
 
  Yes they are...at least I have used them in a project before using
  Perl::DBI.
 
  [EMAIL PROTECTED] ~]$ perl
  use DBI;
 
  print $DBI::VERSION, \n;
  1.37
 
  [EMAIL PROTECTED] ~]$
 
 
  My mysql.pm shows $VERSION = '2.0419'
 
  Are you sure you are connecting to an InnoDB database and that you are

 doing

  transactions on InnoDB tables?
 
  My code is rather simple:
 
  #Begins the transaction
  $dbh-do('BEGIN');
  .
  .
  .
  .
  $dbh-do('COMMIT');
 
  What does your code look like?
 
  j- k-
 
  --
  Joshua J. Kugler
  Fairbanks, Alaska
  Computer Consultant--Systems Designer
  .--- --- ...  ..- .--.- ..- --. .-.. . .-.
  [EMAIL PROTECTED]
  ICQ#:13706295
  Every knee shall bow, and every tongue confess, in heaven, on earth, and
  under
  the earth, that Jesus Christ is LORD -- Count on it!
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
  http://lists.mysql.com/[EMAIL PROTECTED]

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: Transaction Not supported

2004-03-30 Thread Joshua J. Kugler
On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:
 I dont think that transactions are supported (yet?) by the PERL DBI.

to  Mike Blezien [EMAIL PROTECTED].  My response follows.

Yes they are...at least I have used them in a project before using Perl::DBI.

[EMAIL PROTECTED] ~]$ perl
use DBI;

print $DBI::VERSION, \n;
1.37

[EMAIL PROTECTED] ~]$


My mysql.pm shows $VERSION = '2.0419'

Are you sure you are connecting to an InnoDB database and that you are doing 
transactions on InnoDB tables?

My code is rather simple:

#Begins the transaction
$dbh-do('BEGIN');
.
.
.
.
$dbh-do('COMMIT');

What does your code look like?

j- k-

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

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



Re: High resolution timestamps

2004-03-23 Thread Joshua J. Kugler
You can get millisecond resolution in MySQL 4.1. Considering most systems 
don't even support *true* millisecond resolution, I don't think you're going 
to find anything that supports microsecond resolution.

j- k-

On Tuesday 23 March 2004 07:18 am, Leon Brocard wrote:
 Hello,

 Recently I've been needing high-resolution timestamps
 (year/month/day/hour/minute/seconds/microseconds) in MySQL (to store
 network packets, mmm). Is this a planned feature for MySQL in the
 future?

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Security

2004-03-11 Thread Joshua J. Kugler
You've been perfectly clear.  The MySQL permission system will not define this 
level of security.  You must design you application so that it will only give 
access to the rows that pertain to the customer that is logged in.  Create a 
MySQL user which can read and write to your database.  Then create another 
table in your database which defines users and passwords (separate from the 
MySQL users).  When a user logs in, you check their username and password 
against your user table, and then once they are logged in, you make sure the 
only rows they see or update are rows that pertain to them.

I hope this makes things clear.

On Wednesday 10 March 2004 05:39 pm, Mulugeta Maru wrote:
 Hi Mike,

 I am sorry for the confusion I might have caused. May be it would help to
 give a clear example.

 Table - Customers (CustomerID, CustomerName, Address, etc)

 Table - Transaction(TransactionID,CustomerID,Date,Amount)

 Note: CustomerID in Customer Table is a Primary Key. TransactionID is a
 Primary Key and CustomerID is a Foreign Key in Transaction Table).

 Question: How would I be able to give my customers access to the database
 so that they can update the customer table (for example address change) and
 add transactions to the transaction table. What I do not want to happen is
 that customer A is able to modify customer B's record.
 In short how would you restrict customer a to see transactions that pertain
 to him/her.

 Many thanks.

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: https access to phpmyadmin - mysql

2004-03-11 Thread Joshua J. Kugler
Just set PHPMyAdmin under the directory tree of your https server, and not 
under the directory tree of your http server.  That way you have to connect 
to the https server to log in.

j- k-

On Thursday 11 March 2004 02:15 pm, codefit wrote:
 Yes I have mod_ssl and have used it for a long time for other applications.

 What I am looking for are phpmyadmin specific instructions as to how to
 configure phpmyadmin to use mod_ssl and
 and DISALLOW http logins and only allow https logins and use of phpmyadmin.

 Thanks anyone.

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Span a database transaction across multiple CGI scripts

2004-03-10 Thread Joshua J. Kugler
The short answer is no, not using MySQL built in transaction system.  What I 
do for things like this is add a field to the table that indicates whether or 
not the record is locked.  It is usually a  Tiny Int that I just set to 1 or 
0.

Hope that helps.

j- k-

On Tuesday 09 March 2004 06:24 am, Sagara Wijetunga wrote:
 Hi all

 Is it possible to span a database transaction across
 multiple CGI scripts? That is, start transaction and
 lock some records in one CGI script and update and
 commit in another CGI script.

 Here is an example: I have a accounts database. Only
 one user should edit a given account at any given
 time. Once an account is open for editing, it should
 be locked so that other users cannot open in edit
 mode. Multiple users should be able to edit different
 accounts.

 The list.cgi lists accounts. Once click on an account,
 the edit.cgi reads account info and display in an
 editable form. This is where I need to lock the
 account. After editing is completed, user clicks on
 the Update button and data transfer to process.cgi.
 After the account is updated, I issue commit and
 release record locks.

 I use MySQL 4.x and Perl. Could my requirement be
 implemented in MySQL? Could somebody please at least
 give me a hint how to implement this?

 Many thanks in advance.

 Regards
 Sagara


 __
 Do you Yahoo!?
 Yahoo! Search - Find what you’re looking for faster
 http://search.yahoo.com

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Mysql timed actions... Confused

2004-03-10 Thread Joshua J. Kugler
Judging from the times on the clock (03:00 to 07:00) I would guess that the 
server on which MySQL is running is doing some scheduled activity.  Cron jobs 
for backup, slocate updates, security checks, etc.  MySQL doesn't do 
scheduled maintenance, especially not for four hours.

j- k-

On Tuesday 09 March 2004 01:49 pm, Scott Haneda wrote:
 Here is a log of query times I made when a certain page is loaded that uses
 php and mysql, does mysql 4 do some sort of scheduled maintenance I am not
 aware of?

SNIP
 2004/03/09 02:00:00OK, 77585 bytes1 seconds
 2004/03/09 02:05:01OK, 77591 bytes24 seconds
 2004/03/09 02:10:00OK, 77591 bytes23 seconds
 2004/03/09 02:15:00OK, 77585 bytes32 seconds
 2004/03/09 02:20:00OK, 77591 bytes26 seconds
 2004/03/09 02:25:00OK, 77591 bytes25 seconds
 2004/03/09 02:30:00OK, 77579 bytes27 seconds
 2004/03/09 02:35:00OK, 77585 bytes26 seconds
 2004/03/09 02:40:00OK, 77585 bytes27 seconds
 2004/03/09 02:45:00OK, 77572 bytes28 seconds
 2004/03/09 02:50:00OK, 77578 bytes26 seconds
 2004/03/09 02:55:00OK, 77578 bytes26 seconds
 2004/03/09 03:00:00OK, 77572 bytes26 seconds
 2004/03/09 03:05:00OK, 77578 bytes26 seconds
 2004/03/09 03:10:00OK, 77572 bytes28 seconds
 2004/03/09 03:15:00OK, 77572 bytes29 seconds
 2004/03/09 03:20:00OK, 77572 bytes33 seconds
 2004/03/09 03:25:00OK, 77572 bytes64 seconds
 2004/03/09 03:30:01OK, 77532 bytes27 seconds
 2004/03/09 03:35:01OK, 77526 bytes25 seconds
 2004/03/09 03:40:01OK, 77532 bytes114 seconds
 2004/03/09 03:45:01OK, 77532 bytes27 seconds
 2004/03/09 03:50:00OK, 77526 bytes79 seconds
 2004/03/09 03:55:00OK, 77532 bytes26 seconds
 2004/03/09 04:00:01OK, 77532 bytes27 seconds
 2004/03/09 04:05:00OK, 77526 bytes26 seconds
 2004/03/09 04:10:00OK, 77526 bytes26 seconds
 2004/03/09 04:15:00OK, 77526 bytes26 seconds
 2004/03/09 04:20:00OK, 77532 bytes33 seconds
 2004/03/09 04:25:00OK, 77532 bytes26 seconds
 2004/03/09 04:30:01OK, 77526 bytes167 seconds
 2004/03/09 04:35:01OK, 77532 bytes26 seconds
 2004/03/09 04:40:00OK, 77526 bytes29 seconds
 2004/03/09 04:45:00OK, 77532 bytes28 seconds
 2004/03/09 04:50:00OK, 77526 bytes26 seconds
 2004/03/09 04:55:01OK, 77526 bytes25 seconds
 2004/03/09 05:00:00OK, 77532 bytes28 seconds
 2004/03/09 05:05:00OK, 77526 bytes28 seconds
 2004/03/09 05:10:00OK, 77526 bytes27 seconds
 2004/03/09 05:15:00OK, 77526 bytes28 seconds
 2004/03/09 05:20:00OK, 77532 bytes26 seconds
 2004/03/09 05:25:01OK, 77526 bytes27 seconds
 2004/03/09 05:30:00OK, 77532 bytes27 seconds
 2004/03/09 05:35:01OK, 77526 bytes25 seconds
 2004/03/09 05:40:00OK, 77526 bytes26 seconds
 2004/03/09 05:45:01OK, 77526 bytes26 seconds
 2004/03/09 05:50:01OK, 77526 bytes26 seconds
 2004/03/09 05:55:00OK, 77526 bytes28 seconds
 2004/03/09 06:00:01OK, 77532 bytes27 seconds
 2004/03/09 06:05:01OK, 77526 bytes28 seconds
 2004/03/09 06:10:00OK, 77532 bytes30 seconds
 2004/03/09 06:15:00OK, 77532 bytes30 seconds
 2004/03/09 06:20:01OK, 77532 bytes27 seconds
 2004/03/09 06:25:00OK, 77526 bytes27 seconds
 2004/03/09 06:30:00OK, 77526 bytes27 seconds
 2004/03/09 06:35:00OK, 77526 bytes31 seconds
 2004/03/09 06:40:00OK, 77532 bytes27 seconds
 2004/03/09 06:45:00OK, 77526 bytes26 seconds
 2004/03/09 06:50:01OK, 77526 bytes29 seconds
 2004/03/09 06:55:00OK, 77526 bytes28 seconds
 2004/03/09 07:00:00OK, 77532 bytes28 seconds
 2004/03/09 07:05:00OK, 77526 bytes1 seconds

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Security

2004-03-10 Thread Joshua J. Kugler
Only being able to see certain rows is not a function of MySQL, it is a 
function of the application you write for the user to access the database.  
If a user has permission to read a table, they can read all rows.  It is up 
to your application to make sure they are only seeing rows that apply to 
them.

j- k-

On Tuesday 09 March 2004 05:57 pm, Mulugeta Maru wrote:
 Thank you for the kind response. May be I did not clearly ask the question.
 The user table in mysql database is used to set-up a user and password.
 Once I set-up my tables (customer, customer orders, customer order details,
 etc) in say abc database what will I have to do to make sure when customer
 A logs in to the database can only see his/her account, orders, order
 details without getting access to other customer accounts.

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Security

2004-03-10 Thread Joshua J. Kugler
Yes, you make sense.  But when you go in to access your bank account, you are 
not directly accessing the database.  The web application is opening the 
database and only returning rows in the table that pertain to you.  The web 
application can read all the rows; your user name has *no* read or write 
permissions to the database: the web application connects via its own 
username, and selects your account information from the database.

So, in other words, you need to keep a list of users separate from the list of 
MySQL users.  The mysql database controls which username/passwords can 
connect to the database.  Your user list would contain users which can log in 
to your system.

j- k-

On Wednesday 10 March 2004 01:47 pm, Maru, Mulugeta wrote:
 When I go online to access my bank account I only see transactions pertain
 to my account only. I think when ever I make a transaction the database
 records my account number in the transaction table. When I log-in using my
 account number and password the system checks whether it is correct or not
 and run another query to get all transaction that match my account number.

 Do I make sense?

 -Original Message-
 From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, March 10, 2004 5:34 PM
 To: Mulugeta Maru; MySQL
 Subject: Re: Security


 Only being able to see certain rows is not a function of MySQL, it is a
 function of the application you write for the user to access the database.
 If a user has permission to read a table, they can read all rows.  It is up
 to your application to make sure they are only seeing rows that apply to
 them.

 j- k-

 On Tuesday 09 March 2004 05:57 pm, Mulugeta Maru wrote:
  Thank you for the kind response. May be I did not clearly ask the
  question. The user table in mysql database is used to set-up a user and
  password. Once I set-up my tables (customer, customer orders, customer
  order details, etc) in say abc database what will I have to do to make
  sure when customer A logs in to the database can only see his/her
  account, orders, order details without getting access to other customer
  accounts.

 --
 Joshua J. Kugler
 Fairbanks, Alaska
 Computer Consultant--Systems Designer
 .--- --- ...  ..- .--.- ..- --. .-.. . .-.
 [EMAIL PROTECTED]
 ICQ#:13706295
 Every knee shall bow, and every tongue confess, in heaven, on earth, and
 under the earth, that Jesus Christ is LORD -- Count on it!


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

 VisionTV proudly celebrates 15 years as Canada's multi-faith television
 network.

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Saving file into database

2004-03-09 Thread Joshua J. Kugler
Yes, it's possible.  Just make sure you quote it (see the Perl DBI docs for 
the quote method) before you insert it.

j- k-

On Tuesday 09 March 2004 12:49 am, Isa Wolt wrote:
 Hi,

 I would like to save a binary file into a mysql database, for later being
 able to use the file. I am using a perl interafce. Is this at all
 possible???

 And would it be possible to then read that file from a c++ interface?

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Selectinmg most recent dates from multiple table items

2004-03-07 Thread Joshua J. Kugler
SELECT DISTINCT sensor_id, other_fields FROM table_name
ORDER BY time_stamp_field DESC LIMIT 40

Not sure if that will work, but does it point you in the right direction?

j- k-

On Saturday 06 March 2004 07:22 pm, Tim McDonough wrote:
 On Sat, 06 Mar 2004 20:40:24 -0600, Paul DuBois wrote:
  You can use your LIMIT clause as well, as long as by that you don't
  mean 5 most recent from *each* table.

 This seems similar to something I'm working on which I haven't sorted
 out to my satisfaction yet.

 We have a system that collects and stores data that is time stamped in
 a mysql database. There is data from 40 sensors and it does not arrive
 at exactly the same time so each sensor reading and it's time stamp
 are stored. The table contains a date/time, the sensor ID, and the
 value.

 One request is to have a web page that will display each sensor and
 it's most recent measurement so the most recent is always shown.
 regardless of which sensor it came from. How do I create a query that
 will extract the most recent data (latest date) from the database for
 each of the sensors and have it sorted it by the sensor ID?

 This isn't obvious to me from reading the documentation on queries and
 I've been searching and reading through messages without success yet.
 I suspect a big part of the problem is I'm fairly new to sql queries
 and am not exactly sure what terms to search for.

 Tim

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Information request

2004-03-04 Thread Joshua J. Kugler
Currently, everything you listed can be done via queries to the server.  Take 
a look at the MySQL manual for all the queries and their requisite responses.  
And I'm quite sure what you want to do has already been done.  Please take a 
look at MySQL CC and MySQL Administrator (both available from the MySQL web 
site), as well as PHPMyAdmin, if you are looking for a web-based front end.  
I believe Webmin also has a MySQL module.

If you want to do it for fun to learn, that's fine, but if you want to save 
your self a lot of time, I'd reccommend looking at existing products.

j- k-

On Wednesday 03 March 2004 03:29 am, [EMAIL PROTECTED] wrote:
 Hi all

 I would like to try and implement the MySQL socket protocol (or what ever
 you would call it), so that I can do all kinds of communication with a
 MySQL server, like normal SQL, MySQL environment variables, performance
 status, tables helth checks, and what ever is possible.

 The reson I need this, is just for fun :) Maybe if I succeed I will make
 some webapp that can monitor all our databases, maybe I will never get that
 far. But basicly its just an experiment I would like to try.

 So where do I get information about the protocol and the operations
 possible via the protocol?

 Best regards
 Søren

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: mysql import problem

2004-03-04 Thread Joshua J. Kugler
It sounds like the file is actually a MySQL database. Possibly an innodb file?  
You will need to create the requisite table definition so MySQL knows how to 
read it, then you might be able to read it.

j- k-

On Thursday 04 March 2004 12:08 am, Egor Egorov wrote:
 Manda Sairam [EMAIL PROTECTED] wrote:
  Hello Sir,
  I have a file with the name doc.db.001 It is a binary file and it is a
  mysql  file.I tried opening the file using load data file command but
  failed with errors .Actually the problem is i donot know about the
  columns or the details about the db file.How can i import such a file.

 How do you want to import this file? Do you want to load the whole file
 into specific field?

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Microseconds in the 4.0.x series...

2004-03-03 Thread Joshua J. Kugler
In the manual that came with MySQL 4.0.17 (at least in the Mandrake packages 
of such) it says I can use %f to get the microseconds in a DATE_FORMAT call.  
This does not work, however, and searching the archives reveals that %f was 
only added in 4.1.1.  So..which one is correct?  The release announcement or 
the 4.0.17 documentation?  Is there a way to get sub-second resolution in 
4.0.17, or must I rely on my application?

Thanks!

j- k-
-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Dream MySQL Server?

2004-03-03 Thread Joshua J. Kugler
 And the testing burden of the same software against several database
 back-ends would be considerable.

Just one comment.  If you are using MySQL, there would be no testing 
burden...against several database backends.  The protocol, commands, 
connection methods, etc, are identical.  A client on Windows, Mac, or *nix 
can talk to a MySQL server on a Windows, Mac, or *nix server, and will never 
know the difference.  All it knows it that it is connecting to port 3306 and 
it's talking to a MySQL server.  There is no difference among operating 
systems.

j- k-

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: locking

2004-03-03 Thread Joshua J. Kugler
You can use MySQL's built in locking, or you can do this:

Find a job that is waiting
Run an update like this:
UPDATE table SET status = 'processing'
WHERE jobid = found_job AND status = 'waiting'

If you get back a 1 from that query, it made one change, and you're good.  If 
you get back 0 (no rows updated) someone beat you to it.

j- k-

On Wednesday 03 March 2004 05:14 pm, tofu optimist wrote:
 Hi.  I am new to my my sql and have a basic question about locking.
 I am running Ver 11.18 Distrib 3.23.54, for Win95/Win98.

 I have a table that holds work on jobs needing processing

 FieldTypeNullKey Default  Extra
 ---  -  --  ---  --
 jobidint(11) PRI (NULL)   auto_increment
 status   enum('waiting','processing','done','failed')  YES waiting
 created  timestamp(14) YES (NULL)
 details  varchar(255)  YES (NULL)

 Right now, a single process checks this table occasionally.
 If it finds rows in 'waiting' status, it grabs the info,
 sets the row to 'processing', and does the computation.
 Upon completion, the process stores the results elsewhere,
 sets the row to 'done' (or failed, if it failed), looks for
 more work to do, and sleeps a bit if there is no futher processing
 to be done now.

 For speed, I'd now like several processes to grab work from the table.

 I am not sure how mysql handles locking.

 While a process is seizing a row (changing row status from
 'waiting' to 'processing'), how do I prevent another process
 from grabbing the same row?

 Thanks for any help or advice

 -TO

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: FW: query

2004-03-03 Thread Joshua J. Kugler
Oh, so what you're looking for a a find duplicates query (as MS Access calls 
it).  That's something like this (I'm rusty, so you might have to debug).

SELECT fname, lname, etc FROM my_table as table1, my_table as table2
WHERE table1.fname = table2.fname
AND table1.lname = table2.lname
...etc...
AND table1.customer_id  table2.customer_id

That should give you duplicate rows, or something close to it.

Hope that helps.

j- k-

On Wednesday 03 March 2004 06:51 pm, Elly Wisata wrote:
 In 1 table, I probably have double records or triple records with the same
 value for several fields.
 Example : table customer with field customer_id, address, DOB, Services
 I need to know that customer data in my table have more than 1 record for 1
 customer. So he/she has more then 1 customer_id.
 I need to query the double record, not the DISTINCT one.

 ~Elle~

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: FW: query

2004-03-03 Thread Joshua J. Kugler
That's true.  I'm only using one table.  It is called a self-join.  You alias 
the tables in the FROM clause, and then can refer to them as two separate 
tables in your WHERE clause. See the part of the FROM clause where I say 
as?  That's aliasing the table.  A temporary renaming, if you will.  Trust 
me, it will work with one table. :)

You might want to read the section of the MySQL manual on Selects as well as 
Joins.  You might want to learn SQL. :)

j- k-

On Wednesday 03 March 2004 07:35 pm, Elly Wisata wrote:
 I only have 1 table for this job. Your example is using 2 table.

 ~Elle~

 -Original Message-
 From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
 Sent: Thursday, March 04, 2004 11:08 AM
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: Re: FW: query

 Oh, so what you're looking for a a find duplicates query (as MS Access
 calls

 it).  That's something like this (I'm rusty, so you might have to debug).

 SELECT fname, lname, etc FROM my_table as table1, my_table as table2
 WHERE table1.fname = table2.fname
 AND table1.lname = table2.lname
 ...etc...
 AND table1.customer_id  table2.customer_id

 That should give you duplicate rows, or something close to it.

 Hope that helps.

 j- k-

 On Wednesday 03 March 2004 06:51 pm, Elly Wisata wrote:
  In 1 table, I probably have double records or triple records with the
  same value for several fields.
  Example : table customer with field customer_id, address, DOB, Services
  I need to know that customer data in my table have more than 1 record for

 1

  customer. So he/she has more then 1 customer_id.
  I need to query the double record, not the DISTINCT one.
 
  ~Elle~

 --
 Joshua J. Kugler
 Fairbanks, Alaska
 Computer Consultant--Systems Designer
 .--- --- ...  ..- .--.- ..- --. .-.. . .-.
 [EMAIL PROTECTED]
 ICQ#:13706295
 Every knee shall bow, and every tongue confess, in heaven, on earth, and
 under
 the earth, that Jesus Christ is LORD -- Count on it!


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

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Microseconds in the 4.0.x series...

2004-03-03 Thread Joshua J. Kugler
On Wednesday 03 March 2004 08:04 pm, Sasha Pachev wrote:
 Joshua J. Kugler wrote:
  In the manual that came with MySQL 4.0.17 (at least in the Mandrake
  packages of such) it says I can use %f to get the microseconds in a
  DATE_FORMAT call. This does not work, however, and searching the archives
  reveals that %f was only added in 4.1.1.  So..which one is correct?  The
  release announcement or the 4.0.17 documentation?  Is there a way to get
  sub-second resolution in 4.0.17, or must I rely on my application?

 Joshua:

 The truth is determined by the way things actually are, and not by how they
 are documented :-) MySQL documentation is always for the latest bleeding
 edge version, and, in theory, should mentioned when the feature was
 introduced if it is fairly new, and not just in the Changelog.
 Unfortunately, it does not always happen. In this case, I believe the
 feature was introduced somewhere in 4.1. In fact, it would have to be - in
 order to give ms of a timestamp you need to store it with ms precision - a
 change that I would not expect to see mid-version.

OK...I was not referring to a timestamp, but simply a DATE_FORMAT call.  I'd 
like to be able to do something like DATE_FORMAT(now(), %f), but when I do 
that, I just get an 'f' in the result column.  I'll consider upgrading to 
4.1.  We'll see.

Also, in regards to the documentation, I knew the documentation on the web 
site was always bleeding edge, but I had assumed that the docs included 
with a version would only apply to that version.

Thanks for your help.

j- k-

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Microseconds in the 4.0.x series...

2004-03-03 Thread Joshua J. Kugler
Sigh...RATFM: Read *All* The Fine Documentation.  I'll remember that in the 
future.  Thanks for pointing that out.

j- k-

On Wednesday 03 March 2004 09:16 pm, Paul DuBois wrote:
 DATE_FORMAT() is documented here:

 http://www.mysql.com/doc/en/Date_and_time_functions.html

 Hint: Take a look at the paragraph that follows the table that lists
 the formatting specifiers.

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Using mod_auth_mysql with Apache 2

2004-03-01 Thread Joshua J. Kugler
Look in /etc/httpd/conf.d.  These config files are included by a line in 
httpd.conf.

Now, find the config file for mod_auth_mysql.  At the top, there may be 
something like IfDefine HAVE_MOD_AUTH_MYSQL ...stuff there... /IfDefine.  
For some reason, the installed RPM is not defining HAVE_MOD_AUTH_MYSQL, thus 
it isn't loading.  Comment out the IfDefine ... and /IfDefine lines, 
restart Apache, and that should put you on your way.

You didn't say which distribution you were using, but I had that problem with 
an update to Apache on Mandrake 9.2.

Hope that helps!!

j- k-

On Friday 27 February 2004 10:24 am, James Marcinek wrote:
 Hello all!

 I know this isn't an Apache list but I already checked the documentation
 on Apache.org on trying to get this configured correctly.

 I have a question about mod_auth_mysql. I installed the rpms for
 Apache(2.x) and Mysql and I can see the module is in the
 /etc/httpd/modules dirctory:

 mod_auth_mysql.so

 However I do not see this added in the httpd.conf file. I also checked
 what modules are loaded statically with the httpd -l command, and it
 wasn't listed.

 The reference material I have is a bit vague so I'm hoping that someone
 can help me out as this is the first time I'm setting this up. The
 material covers  Apache 1.x and 2(at the same time) so I'm not sure what I
 have to do (if anything)

 I'm assuming that I have to add this module to the Dynamic Shared Object
 support section of the httpd.conf:

 auth_mysql_module modules/mod_auth_mysql.so

 Is this correct?

 Also, my reference material also indicates I need to add a line to the
 httpd.conf to give mod_auth_mysql the parameters it needs to connect to
 MySQL:

 Auth_MySQL_Info hostname user password

 Is this right? Where in the httpd.conf should this be placed.

 Any help would be great!

 Thanks,

 James

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Xserve G5

2004-03-01 Thread Joshua J. Kugler
Not to start a flame war, but just a question/suggestion...

Do you specifically want a Mac (i.e. are you a Mac shop), or are you looking 
for inexpensive 64 bit?

If the latter applies, you might want to look at an AMD64 box running Linux 
(SuSE and Mandrake are two that come to mind as having 64 bit versions, I'm 
sure there are others, just haven't kept up to date in that area).

Hope that helps.

j- k-

On Monday 01 March 2004 01:29 pm, Tom O'Neill wrote:
 Has anyone had any experiences running MySQL on a Xserve G5 with Macintosh
 OSX?

 We are thinking of purchasing some new hardware to run our MySQL server. 
 The 64-bit architecture is something we would like to take advantage of.

 Is this good, bad, otherwise? Any comments would be appreciated.

 Thanks

 TOM

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: A problem with access to data source, please help!!!!

2004-03-01 Thread Joshua J. Kugler
I had a bunch of problems setting up OpenCMS until I figured it out.  OpenCMS 
tries to connect via the network socket, so the connection to the database 
may look like it's coming from the.host.name.com.  You may need to add the 
full host name of the machine you are installing on to the privileges table 
as well.  (I'm not 100% sure of that...it's been a long time since played 
with OpenCMS.)

j- k-

On Monday 01 March 2004 06:55 am, Rafael Diaz Valdes wrote:
  Hi,
   I am trying to configure Open CMS
   5.0.0 with mysql. But while Database and and table creation I am
  getting
   following error.

   Could no connect to database via: jdbc:mysql://localhost:3306/
   java.sql.SQLException: Server configuration denies access to data =
  source
   ---
   java.lang.NullPointerException


  I tested mysql with the root password I assigned using mysqladmin -u
   root -p, so it looks like mysql is setup correctly.However when trying

  Also I tested the GRANTS of root and I get

  +=

   +

   | Grants for [EMAIL PROTECTED] =

  +=

   +

   | GRANT ALL PRIVILEGES ON *.* TO 'root'@'pcepaip30' IDENTIFIED BY

   PASSWORD '*F65E684A09D85F1DD4574279566B9E738DD597E7' WITH GRANT OPTION


  +

   +
   1 row in set (0.00 sec)


  I need a help,
thanks in advance
   Rafael

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: WHERE clauses across rows...

2004-02-27 Thread Joshua J. Kugler
Oh. Yeah. Joins. Right.  Self Joins.  I've done joins, this just didn't occur 
to me.  Thanks for the tip.  I'll try it out.

j- k-

On Friday 27 February 2004 07:55 am, Eric B. wrote:
 Not sure how you determine what the order of your rows are, but assuming
 you have a column called rownumber, or soemthing to that extent, which is a
 sequential numbering of the rows in your table, you can probably do it with
 a join on itself.  You might have to play with the join syntax a little (in
 the where clause), b/c this is totally off the top of my head.

 ie:
 SELECT unique_key_field FROM table_name as t1, table_name as t2 where
 t1.rownumber = t2.rownumber+1
 and
 (
 (t1.col1='strt' and t1.col2='word')
 OR (t1.col2='strt' and t1.col3='word')
 OR (t1.col3='strt' and t1.col4='word')
 OR (t1.col4='strt' and t2.col1='word')
 )

 Good luck.

 Eric


 Joshua J. Kugler [EMAIL PROTECTED] wrote in message
 news:[EMAIL PROTECTED]

  1) This is mostly an SQL question, although MySQL may have some trick up

 its

  sleeve that would help me.
  2) I've searched the archives, and google
  3) I've been using SQL for a long time, but can't think of a way to solve

 this

  4) This may not be possible. :)
 
  I am dealing with serial data that is being put into a table, and I have

 to

  search through that data to find certain start words.  That is, data

 that

  indicates the start of a new packet of data.  This start word, since this

 is

  asynchronous serial data, could be split over rows.
 
  For purposes of example, let us assume we have a table of four columns,

 and

  that my start indicator is strt in one column and word in the next
  column.  Now I want to find the next start word.  The first three cases

 are

  easy, I just do something like WHERE col1 = 'strt' AND col2 = 'word',

 etc..

  But, what I need to be able to do is something like this:
 
  SELECT unique_key_field FROM table_name
  WHERE (col1='strt' AND col2='word')
  OR (col2='strt' AND col3='word')
  OR (col3='strt' AND col4='word')
  OR (col4='strt' AND col1_in_the_next_row='word')
 
  Is this even possible?  I'd hate to issue hundreds of queries to check if
  strt word is split across rows.
 
  Should I investigate setting variables equal to the col4, and on a failed
  search, use that variable in the next query to see if the old col4
  pairs with anything in col1?
 
  Or am I better off searching for the good case, and on failure, go and

 look

  for 'strt' in col4, then when I get a row, see if 'word' is in col1 on
  the next row (via another query)?
 
  Ideas? Tips? Suggestions?
 
  Thanks much!
 
  j- k-
 
  --
  Joshua J. Kugler
  Fairbanks, Alaska
  Computer Consultant--Systems Designer
  .--- --- ...  ..- .--.- ..- --. .-.. . .-.
  [EMAIL PROTECTED]
  ICQ#:13706295
  Every knee shall bow, and every tongue confess, in heaven, on earth, and

 under

  the earth, that Jesus Christ is LORD -- Count on it!
 
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:

 http://lists.mysql.com/[EMAIL PROTECTED]

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



WHERE clauses across rows...

2004-02-26 Thread Joshua J. Kugler
1) This is mostly an SQL question, although MySQL may have some trick up its 
sleeve that would help me.
2) I've searched the archives, and google
3) I've been using SQL for a long time, but can't think of a way to solve this
4) This may not be possible. :)

I am dealing with serial data that is being put into a table, and I have to 
search through that data to find certain start words.  That is, data that 
indicates the start of a new packet of data.  This start word, since this is 
asynchronous serial data, could be split over rows.

For purposes of example, let us assume we have a table of four columns, and 
that my start indicator is strt in one column and word in the next 
column.  Now I want to find the next start word.  The first three cases are 
easy, I just do something like WHERE col1 = 'strt' AND col2 = 'word', etc..

But, what I need to be able to do is something like this:

SELECT unique_key_field FROM table_name
WHERE (col1='strt' AND col2='word')
OR (col2='strt' AND col3='word')
OR (col3='strt' AND col4='word')
OR (col4='strt' AND col1_in_the_next_row='word')

Is this even possible?  I'd hate to issue hundreds of queries to check if 
strt word is split across rows.

Should I investigate setting variables equal to the col4, and on a failed 
search, use that variable in the next query to see if the old col4 pairs 
with anything in col1?

Or am I better off searching for the good case, and on failure, go and look 
for 'strt' in col4, then when I get a row, see if 'word' is in col1 on the 
next row (via another query)?

Ideas? Tips? Suggestions?

Thanks much!

j- k-

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ...  ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!


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



Re: Is there any way to search a whole database for a value?

2003-03-11 Thread Joshua J . Kugler
A request such as this make me think the database is not properly normalized. 
 If there is one value that can be in several columns, it is very likely 
those columns need to be broken into their own table, so that they can be 
queried with a SELECT statement that has only one column in its WHERE clause.

Hope that helps.

j- k-

On Tuesday 11 March 2003 12:30, Paul DuBois wrote:
 At 11:01 -0800 3/11/03, Keith Roberts wrote:
 I need to look in several different tables/columns in a database for a
 particular value.  If I find it, I need to update it.  Is there any way to
 search/update every table/column in one query in a particular database?

 No.

mysql, query

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: what is wrong with this perl mysql code?

2003-03-04 Thread Joshua J . Kugler
You need quotes around $username in your SQL query, unless you've already run 
$username thorough $dbh-quote();

j- k-

On Tuesday 04 March 2003 13:11, Jianping Zhu wrote:
 I am writing a simple login system by using perl( this is almost my first
 program in perl), After user pick a username i need to check if this
 username already exsited in mysql database table. if it is  already in
 the table, this program will prompt user to pick another user name.
 but something wrong with following code, the program does not work.



 [code piece]***
 my $selsql=SELECT * FROM apidbusers WHERE username=$username;
 #prepare the query for $selsql

 my $selsth=$dbh-prepare($selsql);
 $selsth-execute();
   if($selsth-fetchrow_array()) #*username already in apidbusers
   {
 print h4(This user name already registerd, please select
  another user name.);
 regstrForm();
 return;
   }
 ***

 How to fix this problem?
 Any suggesion is appreciated.
 J.P.

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: problem: Loosing .MYD Files

2003-02-26 Thread Joshua J . Kugler
Daniel -

This might be a long shot, but since I've actually run into this problem 
before, here goes:

Check your partitions.  I had a server on which this very thing happened, and 
it turned out there were overlapping partitions.  This was all fine and dandy 
until data was written to those overlapping areas, and created BIG problems 
when fsck was run.  It sounds like your server might have gone down hard 
without a proper shut down, and then run fsck upon startup.  Check your boot 
logs.

It is also possible that there was severe corruption on the filesystem as a 
result of the system going down hard, and fsck did a best guess fix, which 
blew away your data.

I may be totally off base, but your symptoms at least match what mine were.

Hope that helps.

j- k-

On Wednesday 26 February 2003 00:50, Daniel Geske wrote:
 No, I didn't do anything at all. The server ran since months without any
 problems, and then suddenly this..
 I just found something that may be related:
 A program started writing errors to a log file saying it couldn't insert
 into one of the tables that is now missing and the log file grew up to 2
 GB. Certainly the mysql problem occured before the disk was full, else the
 log couldn't have been written.

 Could mysql delete data files if there's no more diskspace?

 My monitoring server says there have been 1.3GB left on the server at
 18:05. At 18:01 the problem with mysql started. The log ends at 20:13, that
 must have been when the monitoring program shut down for a yet unknown
 reason, the pid file still exists.
 The MySQL server never stopped running.
 Now I have 12GB free, 2GB less compared to before the problem occured.
 These 2GB are the log of the monitoring program.
 Here's the question: who created 10GB of data and where is that data now?
 The 10GB pretty sure weren't the 3 missing tables - the entire database
 never gets bigger than 1MB.

 To get back running for now, is it OK to 'touch tablen.MYD' to recreate the
 missing files. As I said, the frm files still exist.

 Hope to hear from you soon.

 Sincerely,

 Daniel Geske

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: Different value from same function

2003-02-18 Thread Joshua J . Kugler
Your INT in your table is a signed INT, which is going to have a maximum 
value of 2^31, thus your IP address is causing the field to roll over.  You 
need to change your IP column to UNSIGNED INT.  That should solve your 
problem.

j- k-

On Tuesday 18 February 2003 12:33, Aaron Conaway wrote:
 ++-+--+-+-+---+

 | Field  | Type| Null | Key | Default | Extra |

 ++-+--+-+-+---+

mysql

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: Applications for creating reports for MySQL

2003-02-06 Thread Joshua J . Kugler
How much work do you want done for you?  Perl and Python are great apps for 
writing MySQL reports, and you can output all the report to a text file, 
which would be great for a reader.  But as report applications, can't help 
you there.

Sorry.

j- k-

On Tuesday 04 February 2003 09:10, Octavian Rasnita wrote:
 Hi all,

 Does anyone know a program for Windows that can create reports for MySQL
 databases?

 If you know more, please tell me more, because I need to check which of
 them are accessible for the blind.

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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




/usr/bin/safe_mysqld: 5: command not found (WAS: Re: 3.23.54 compile error)

2002-12-14 Thread Joshua J . Kugler
I got that as well., and like the case below, MySQL is up and running just 
fine.  I tried looking in safe_mysqld for a spurious '5' but couldn't find 
anything.  Does anyone know what's up with the most recent safe_mysqld?

j-- k-

On Thursday 12 December 2002 17:16, Gabriele Carioli wrote:
 When I start mysql with

 service mysql start

 I get this error:

 /usr/bin/safe_mysqld: 5: command not found
 What's that?

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: Now() and Timestamp

2002-11-21 Thread Joshua J . Kugler
 INSERT INTO $tablename
 (sender, recipient, whenread, whensent, subject,
  messagetext, folder, priority, condition)
 VALUES
 ('$directorid', '$SendTo', '00', NOW(), '$SetSubject',
  '$MessageText', 'Inbox', '$SetPriority', 'TO')

Easy as that! 

j- k-

mysql, sql

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: last_insert_id()

2002-11-12 Thread Joshua J . Kugler
This looks like the same problem I have with MS Access.  It seems MS Access 
uses the SELECT id FROM table_name WHERE is IS NULL, and this syntax clears 
the last insert ID field.  My solution is here:

--- One Line URL, might wrap ---
http://groups.google.com/groups?hl=ensafe=offthreadm=9ehc8i%2428sa%241%40FreeBSD.csie.NCTU.edu.twrnum=5prev=/groups%3Fq%3Dodbc%2Blast_insert_id%2Baccess%26hl%3Den%26lr%3D%26safe%3Doff%26btnG%3DGoogle%2BSearch%26site%3Dgroup
--- One Line URL, might wrap ---

On Tuesday 12 November 2002 12:04, Alan McDonald wrote:
 The .Neta Adapter.. does it make a persistent connection?
 If the connection drops between the first insert and the call to select,
 then the return would be zero

 Alan

  -Original Message-
  From: Cain O'Sullivan [mailto:cos;iinet.net.au]
  Sent: Wednesday, 13 November 2002 16:13
  To: [EMAIL PROTECTED]
  Subject: last_insert_id()
 
 
  Hi,
 
  I am using C# with ODBC.Net to communicate with MySQL.  I want to
  determine
  the last ID of an auto_increment field in the database.  When I manually
  perform the insert using the MySQL command window I can then
  follow up with
  select last_insert_id() and I get the correct value, however, when
  using ODBC to perform the insert (via a .Net DataAdapter) the
  last_insert_id() returns 0.
 
  Can anyone provide some insight into this?
 
  Best Regards,
 
  Cain O'Sullivan
  [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

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: AutoNumber Question

2002-11-11 Thread Joshua J . Kugler
The correct behavior is the number starting at the last number used.  If you 
are using MyISAM tables, you should see this behavior.  If you are using the 
old style ISAM tables, it will restart at 1 every time.

j- k-

On Monday 11 November 2002 11:41, Jessee Parker wrote:
 I have a script that inserts records into a MySQL table, does the
 processing and
 then deletes those records. The field name that is autonumber is called
 BID. When I run the script again, the BID will sometimes start out at 1 and
 other times it will start at the last number. What is the correct
 behavior?? TIA

 Jessee

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: Dual processors and mysql

2002-10-14 Thread Joshua J . Kugler

MySQL is multithreaded, so your OS will send separate threads to different 
processors.  So, yes, MySQL will automatically take advantage of multiple 
processors, no need to tell it explicitly.

j- k-

On Monday 14 October 2002 08:49, Dyego Souza do Carmo wrote:
 Hello all...

 I´m compiling the mysql 3.23.53 in DUAL PROCESSOR MACHINE...
 in mysql exists an option to optimize on DUAL PROCESSOR MACHINE ?

 my system is mysql 3.23.53 in linux 2.4.18 ( with 1G RAM )

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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 db as filesystem.

2002-10-12 Thread Joshua J . Kugler

There has been such a project for quite a while.  Take a look at 
http://no.spam.ee/~tonu/ and find the link about SQLFS.

j- k-

On Thursday 10 October 2002 02:58, Alex Polite wrote:
 Is there any way I could display a MySQL database as a filesystem
 under Linux?

 alex

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: resetting mysql server gently

2002-10-10 Thread Joshua J . Kugler

I agree completely with Egor!  You should not be killing your processes to 
solve load problems.  If there is a load problem 1) You need to write your 
applications better, 2) you need to have a better database structure, 3) you 
need to analyze where indexes would help you, or 4) you need a more powerful 
machine.  I know Apache has directives in the config file to tell it the 
maximum number of daemons to run.

As in real life, so it is with computers: killing never solves the real 
problem, it just make it go away for a while.

So, tune your app, tune Apache, tune MySQL, or get a bigger machine.  But DO 
NOT implement your kill when load is high solution.  BTW, enough temporary 
glitches and you won't have users any more.  People like a trouble-free web 
site: unreliability is perceived as being unprofessional, unprofessional web 
sites lose clients in a hurry.

j- k-

On Thursday 10 October 2002 07:56, Egor Egorov wrote:
 BC I have a script that runs every minute to deterimine
 BC if the load is above a certain value (or if swap is
 BC high) and if so, it kills all the httpd processes,
 BC does /etc/rc.d/init.d/mysql stop

 BC The script then starts everything back up again.
 BC I am curious if there is a better way to restart mysql

 I can say that solving performance/load problems by resetting
 SQL server or web server is a totally wrong solution.

 The Right Way(tm) is to fine-tune both MySQL and Apache to fit in
 memory/CPU load - this way you'll get much better performance and
 reliability!

 So you can take a look at
 http://www.mysql.com/doc/en/MySQL_Optimisation.html

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: Mixing Linux and Windows and paying for it

2002-09-30 Thread Joshua J . Kugler

On Monday 30 September 2002 10:13, Drulli B wrote:
 Hi,

 I have a grand total of two very important but possibly humiliatingly daft
 questions, that I hope some kind soul will patiently solve:

 1. Can I run a mySQL server on a Linux computer, and query it through
 myODBC running on a Windows computer?

Yes.  But, as another poster pointed out, there are native ways of querying 
MySQL as well.  I believe every major programming language has (at least) one 
MySQL library.

 2. The licensing info seems only relevant to people who develop
 applications. I just want to use it as a repository for data, and then
 query it myself through such decidedly closed-source bastards as Excel and
 Access, but I'm doing this for profit. If I use mySQL for such a purpose,
 and not as a part of an application, do I then need to sell my boss a
 license? The morally correct answer is obvious to me, but I'd like to know
 what the demands of the mySQL company are: do I have more than one morally
 correct option?

MySQL is GPL now.  Buying a license would be nice to help support MySQL, but 
IIRC, you don't HAVE to buy a license.

j- k-

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: Bitten by a strange bug...

2002-09-03 Thread Joshua J . Kugler

Tom -

I'll address what I can

I had the same problem with fields being truncated on direct connections (the 
problem does not manifest on ODBC table attaches in Access).

IIRC, the way to solve this problem is to make sure the optimize columns 
widths (option 1) in the ODBC properties.

Hope that helps (at least a little).

j- k-

On Wednesday 28 August 2002 15:37, Tom Emerson wrote:
 But enough of the background, here is the problem:

 developing a visual-basic (6) application using myodbc connected to a mysql
 database on the network.  Adding records works well the first time, but
 after the database has closed (i.e., the next time I run the program), I
 run into problems.  I've tracked it down to what VB believes is the
 maximum field size for a given field, and it appears to be limited to
 whatever the longest value is in the particular field -- when a table is
 new (empty), there are no entries, so VB thinks the fields are -1 in
 length (technically, unlimited), and the program works fine.  The next
 time the program runs, the fields definedlength property is set to
 whatever the longest value happens to be in the table (hence the ugly
 workaround is to insert a bogus entry with spaces or some filler
 character padded out to the maximum length -- this is fine for master
 [key] tables, but for detail entries it might become problematic.)

 I've even tried the pad char fields to maximum option via the ODBC driver
 window in the control panel, but that doesn't seem to have any effect.

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

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

2002-06-20 Thread Joshua J . Kugler

If you are running Linix, at the prompt type:

md5sum filename

I'm sure you can get md5sum for other Unices as well.

j- k-

On Thursday 20 June 2002 13:00, Kiss Dániel wrote:
 Hi everyone,

 Can anyone tell me how to create an MD5 checksum on a file.
 I tried to do this by using the MySQL MD5 function, but it does not work on
 too big files (above 650MB), even if I set max_allow_packet size very big.
 Is there any small program to do this, anyway?

 Thx
   Daniel
-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: Problems with UPDATE in v3.23.49 (is this a bug)

2002-04-05 Thread Joshua J . Kugler

It's not illogical at all.  You often want (sometimes need) that field to
make sure a record has not changed when you go back to update the row.  MS
Access (and others) uses this so as not to overwrite changes made since the
record was retrieved.  You can't always rely on the client to set
field=NOW(), and it makes for that much less coding.

mysql, query

j- k-

On Friday 05 April 2002 07:53, Hihn Jason wrote:
 Yes I did, but it is very long, and it was very long ago.
 Could someone please explain to me why this was done? It seems more
 confusing to do this than to not do this. Why when you can just say SET
 field=NOW() in the update statement would anyone build this auto update
 of timestamps in? (the kicker is you HAVE to do it for all timestamps in
 a schema past the first) Additionally, what if I wanted the time stamp
 format (without formatting (spaces, colons, and dashes)) (which I do)

 A very illogical feature I must say... Anyone agree with me?
 (Forgive me Rick, I didn't hit reply to all)

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: MyODBC for Core Business, followup...

2002-03-06 Thread Joshua J . Kugler

To all:  This is in response to a request for more information.  I thought 
others may find it useful.

   Thanks so much for your reply.  It's good news to hear that
 someone is relying on MyODBC for an important purpose, much of the
 usage I've seen seemed rather small.

Like I said, we have had not problems with it, other than the problems that 
Access is causing because of its non-standard implementation of ODBC.  I will 
make note of the fact, however, that we *did* have some issues with the 
driver, but those were fixed, and those bugs are now no longer a problem.  
Again, I think when it came right down to it, it was Access issues, and not 
really MyODBC issues.

   If you don't mind, I'd like to ask just a few more questions...

Not at all. I'll do my best.

   - Can you describe what your application does a bit?  I'm
 also interested in why you chose the Access/MyODBC route.  My
 reasoning is a desire to PHP on the Web side of things, and certainly
 the easse and cost of running a MySQL server...

The application primarily provides for entry, editing, and procession 
(through various states) of student government legislation.  It also keeps 
track of who is in what postion, when they were placed and removed, and why.  
We also plan to implement a module that prints agendas and minutes.

We chose Access/ODBC for a few reasons.

1) We were rewriting an existing application, and while it *was* a total 
rewrite, and went from using a local Access database to using a MySQL server, 
we wanted to keep the interface and behavior as similar as possible. 

2) We wanted more control over format of reports.  As much as I hate to admit 
it, Access does have strong (and pretty easy) report design and generation.  
This especially comes in handy when printing out official documents.  Also, I 
didn't want to design reports by hand, as I would have had to do in Perl 
(formating issues, etc).

3) When wanting to update fields on the fly, e.g. change the values available 
in another field based on a drop down box, it can be very cumbersome to 
convert that to the web. Either you have to use Javascript and pull a new 
page every time, or make it a multistep process.  It is much easier, from a 
design viewpoint, to use the instant response of a local GUI.

We will, however, have an online module pretty soon here to search and view 
existing legislation, which was why we moved it to a MySQL back-end in the 
first place.

   - Any details on the 'gotcha' issues with Access you
 mentioned you've been through is certainly appreciated.

Some you may have heard, others you may not.

1) Make sure every table has a unique ID field (auto increment works just 
fine) and a TIMESTAMP field.  Access will use those on updates to make sure 
nothing has changed since it pulled in the record for edit, and to make sure 
it's only affecting one record.

2) On your connect options (either the FLAGS in connect parameters, or in 
ODBC setup) make sure you select Don't optimize column width and Return 
matching rows.  Using both of these would make for FLAGS=3 in your connect 
statement

3) On direct connections, for some reason, using rst.addnew, adding values, 
and rst.update, then repeating that will repeat the value of the first 
rst.addnew.  I'm quite sure it's an access bug.  I have an MDB file with a 
test case if you are interested.

4) If you don't use the Don't optimize option above, updates using 
recordssets may end up with truncated data if the new data is longer than the 
old data.

5) Inserts on direct connections (and an empty table) using recordsets (not a 
direct INSERT query) fail, and insert blank records.  Again, I have a test 
case for that.

   - I'm assuming your Access application is all with linked
 ODBC tables...  what type of load does it receive and how is
 performance (vs. a more typical SQL Server setup if you happen to
 know)?

We use a hybrid linked/direct connection set up.  Partially for Gotchas 3, 
4 and 5 above. But also for speed.  We use some pretty hairy joins in our 
program. Some as large as 4 or 5 tables.  When Access processes that, it 
breaks it down into 3 or 4 queries (for computability, I'm sure) and sends 
those.  This makes it very slow.  In one case, when I pull in a history, it 
could take 2 or 3 seconds (literally).  When I optimized the query, and sent 
it over the direct connection, it could pull in histories as fast as I could 
click the mouse.  We also use the hybrid setup because reports can't use 
direct connections.

This does, of course, make for a rather dicey situation, since we need to do 
inserts and updates (sometimes with recordsets) on attached tables.  Which 
means those tables need to be connected with the proper username/permissions. 
Which means we have the slightly ugly hack of attaching/unattaching the 
tables everytime someone logs in or out.  It's not pretty, but it works.

Our next time around for this application is going to be in VB (using 

Re: How compressable is a typical MySQL database?

2002-02-17 Thread Joshua J . Kugler

Oh.  OK.  Didn't know that.  Thanks.

j- k-

On Saturday 16 February 2002 22:26, Jeremy Zawodny wrote:
 On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote:
  In that case, i would highly recommend using mysqldump to backup
  your databases.  Simply compressing the actual DB's could give you
  tables in inconsistent states, UNLESS you first shut down your DB
  server, then run the backup.

 Not true at all.  Try this:

   FLUSH TABLES WITH READ LOCK
   back stuff up
   UNLOCK TABLES

 It's safe and keeps the server on-line.

 Jeremy

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: How compressable is a typical MySQL database?

2002-02-16 Thread Joshua J . Kugler

In that case, i would highly recommend using mysqldump to backup your 
databases.  Simply compressing the actual DB's could give you tables in 
inconsistent states, UNLESS you first shut down your DB server, then run the 
backup.

Something to think about.

j- k-

On Saturday 16 February 2002 15:26, George Labuschagne wrote:
 Sorry, I forgot to ask the folowing as well. When considering the amount
 by which text can be compressed as compared to other data types, would
 it be better to store numerical values as text or to store them as
 integer/float values. If the db needs to be compressed and backed up on
 a bi-weekly basis.

 George

  tc lewis [EMAIL PROTECTED] 02/17 2:14 AM 

 would probably be very dependent on the data within the database.  if
 it's
 a lot of text data, then very compressable, as text typically
 compresses
 nicely.  if you store a bunch of binary data (images or something),
 then
 probably not as much...

 tar your mysql dir and gzip it, or gzip -9 or bzip2 if you're looking
 for
 more compression.  test it out.

 -tcl.

 On Sun, 17 Feb 2002, George Labuschagne wrote:
  Hi list,
 
  How compressible is a typical MySQL database? Is this more dependent

 on

  the type of columns used i.e. a lot of text columns as opposed to a

 lot

  of columns containing integer values?
 
  The uncompressed size of the database is in the region of about

 800-MB.

  Also will it suffice to only compress the specific sub-directory
  pertaining to the relevant database below /mysql/ ?
 
  George
  mysql, sql, query

 -

  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

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: forms?

2002-02-12 Thread Joshua J . Kugler

Using Perl/CGI and DBI::MySQL would work for forms.  You could take the input 
from the browser, and print the results back to the browser.  Would that work?

j- k-

On Monday 11 February 2002 05:20, Jim Hatridge wrote:
 Hi all...

 First of all, I think that MySQL is really great. The only thing I need now
 is a way to do forms.

 What I'm looking for is something that will allow me to do data input,
 update, output either at the command line or by browser, but only if I can
 use lynx as the browser.

 I wrote a database system for my stamp export company back around 1990 in
 Dbase III+. That system is getting very old now. DBase III + has scripts
 and forms. Something like this is what I'm looking for.

 Thanks

 JIM

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: LIKE work around??

2002-02-11 Thread Joshua J . Kugler

Umm, I take it you haven't read the documentation?  MySQL fully supports 
LIKE.  Can you tell us the error you are getting? Along with the full query?

j- k-

On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote:
 MySQL doesn't support LIKE does it?  I got an error when I tried.

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: LIKE work around??

2002-02-07 Thread Joshua J . Kugler

Umm, I take it you haven't read the documentation?  MySQL fully supports 
LIKE.  Can you tell us the error you are getting? Along with the full query?

j- k-

On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote:
 MySQL doesn't support LIKE does it?  I got an error when I tried.

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: i686 Binary on i586 OK?

2002-02-01 Thread Joshua J . Kugler

You can try...but, an i686 binary may use machine code instructions that are 
not present in the i586 chip.  Thus, the program will crash with an illegal 
instruction message.

j- k-

On Friday 01 February 2002 16:11, Steve wrote:
 I'm wanting to install mysql on an older i586 machine running RedHat (AMD
 K62)  and was wondering if the 3.23.47 i686 binary currently available is
 OK on older CPUs.

 I've been reading but don't understand if the i686 binary is just optimized
 for the newer CPUs or if it shouldn't be run on the older ones.

 I understand the source is available but I'd like to use the binary, if
 possible.

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: Problem with MySQL and SMP?

2002-01-11 Thread Joshua J . Kugler

We are having the same problem.  Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. 
Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5.

After being up for a few days, the system completely froze.  No ssh, no 
console, nothing.  Had to hard reset the server.

Yes, we compiled MySQL: we have to.  Our application relies on SELECT id ... 
WHERE id IS NULL behaving the same way as LAST_INSERT_ID(), and to do that, I 
have to comment out one (yes, just one) line of code.  Which means I have to 
compile.

Anyway, this is sort of a longish me too, but I wanted to confirm that 
Gavin was not alone in this problem.

j- k-

On Thursday 10 January 2002 21:11, [EMAIL PROTECTED] wrote:
 I am having a problem with MySQL that I believe is related to SMP. I
 have a machine that is an exact copy of another machine, only difference
 is that this one is Dual processor, and the other one is single. The
 single one has had no problems for the last 6 months the dual dies every
 2 days This is the 2nd SMP server that I have had (i thought it was the
 mobo or something) both produce the same results. I get no output to
 logs, machine just goes black (and hangs). Any input?

 This is on RedHat 7.2 linux with the 2.4.17 kernel and MySQL 3.23.47

 Gavin

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601


-
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: Problem with MySQL and SMP?

2002-01-11 Thread Joshua J . Kugler

Yes, this had occured to me.  I am thinking about downgrading to kernel 
2.4.8, or such.  Not sure I really want to do that, but I'd rather do that 
than face system lock ups.

j- k-

On Friday 11 January 2002 08:55, Sinisa Milivojevic wrote:
 If nothing works as you said, no ssh, no console, this is not MySQL
 issue.

 It is either hardware or some unknown (?) 2.4.17 SMP bug.

On Friday 11 January 2002 08:43, Thibaut Allender wrote:
 i don't have any problem with this config :
 slackware 7.1, kernel 2.2.18, MySQL 3.23.41
 Dual PIII-800, 256MB RAM, SCSI Ultra-160

 maybe it's kernel 2.4 fault.


-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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




What kind of crashes with GCC 2.96?

2002-01-07 Thread Joshua J . Kugler

On the MySQL download page, there is a warning for GCC 2.96/x86/Linux that 
reads thus: Several of our users have reported random crashes and table 
corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux 
platform.

I was wondering what kind of crashes users had experienced.  Crashes of the 
database server, or crashes of the entire system?  I have been using a GCC 
2.96 compiled MySQL binary on an AMD system for months without problems.  
But, I just installed a GCC 2.96 compiled binary** on a new Mandrake install, 
and today my server stopped responding after being up for a few days: 
couldn't ssh in, no console/keyboard/ctrl-alt-del. Nothing.  Is this the kind 
of crash we are talking about, or should I look somewhere else?

** As to compiling with GCC 2.96, I don't have a choice.  For MySQL to work 
with one of our Access applications I have to comment out one line of code 
(so SELECT...WHERE id = NULL behavior is the same as LAST_INSERT_ID() 
behavior).  And I'm afraid that compiling on a system with GCC 2.95, and 
associated libraries would break dependencies, although I could try.

Thanks for any help you can offer.

j- k-

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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: Are there any openly-accessible MySQL server [I can use for testing]?

2001-12-27 Thread Joshua J. Kugler

Umm, why not just install a copy locally?  You can get a binary for just 
about any OS.  And a local copy would be much faster than working over the 
internet.

j- k-

On Thursday 27 December 2001 06:31, David Ayliffe wrote:
 I am writing a conversion tool for MySQL and I could do with some real
 data to use to test it with.

 I am wondering are their any MySQL servers out their accessible via the
 internet which I can use to test this program?

 All I need is the IP address a un/pass if no generic ones exist and I
 only need select privileges on the server itself.

 Hope you can help.

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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




  1   2   >