Re: BUG in UNION implementation?! Confimation or Explaination please
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
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
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
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
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..
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
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
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?
[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.
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.
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...?
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
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
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
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
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?
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?
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
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?
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
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
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
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
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
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
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
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
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
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?
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
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
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
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
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
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?
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)
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?
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 youre 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
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
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
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
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
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
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
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...
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?
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
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
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
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...
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...
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
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
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!!!!
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...
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...
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?
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?
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
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
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
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)
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
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()
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
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
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.
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
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
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...
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
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)
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...
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?
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?
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?
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??
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??
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?
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?
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?
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?
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]?
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